SA-14486

Summary

During PFG Framework installation on Pega 7.1.7, SQL query is fails with ORA-01400 error.


ERROR MESSAGE

Error starting at line : 108 in command -
 Insert into PS_PFG_BUSINESSASSOCIATE (BUSINESSID,CITIZEN_ID,ROLE,PERCENTAGEOWNED) values ('A','B','Employee',100)
 Error report -
 SQL Error: ORA-01400: cannot insert NULL into ("PEGADATA"."PS_PFG_BUSINESSASSOCIATE"."BRANCHID")
 01400. 00000 - "cannot insert NULL into (%s)"
 *Cause:
 *Action:
 Error starting at line : 109 in command -
 Insert into PS_PFG_BUSINESSASSOCIATE (BUSINESSID,CITIZEN_ID,ROLE,PERCENTAGEOWNED) values ('C','D','Employee',75)
 Error report -
 SQL Error: ORA-01400: cannot insert NULL into ("PEGADATA"."PS_PFG_BUSINESSASSOCIATE"."BRANCHID")
 01400. 00000 - "cannot insert NULL into (%s)"
 *Cause:
 *Action:

Steps to Reproduce

1. Run the script, oracledate_install_717.sql, in PRPC DATA schema provided in the installables for the framework under "\schema\PFG\oracledate\install" as per installation guide.
2. Run the insert script, PFG_Insert_Scripts_Oracle.sql, in PRPC DATA schema provided in the media '\Data' as per installation guide.

Root Cause

The table, PS_PFG_BUSINESSASSOCIATE contains a not null constraint for the column BRANCHID and on executing the insert script, 'PFG_Insert_Scripts_Oracle.sql' provided in the media '114813_PFG71501\Data' the insert will fail with the error, as you try to insert a null value inside a NOT NULL column.

Resolution

Install HFix-23993 which contains the insert script to the table, PS_PFG_BUSINESSASSOCIATE, which was modified to contain a value, 'NONE' in place of nothing being mentioned for the BRANCHID column.