Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

SQL exception while trying to install framework

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.

 

Suggest Edit

Published October 1, 2015 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us