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

Upgrading rules schema from Pega 7.1.7 to Pega 7.1.8 failed



An error occurred when the rules schema was updated from Pega 7.1.7 to Pega 7.1.8.

Error Messages

[java] 793 (SQLLoader) WARNING - Failed to execute SQL in file oracledate00610.sql
[java] java.sql.SQLException: ORA-01442: column to be modified to NOT NULL is already NOT NULL

/smartpaas-backup/vol1/PRPC718/scripts/setupDatabase.xml:317: The following error occurred while executing this line:
/smartpaas-backup/vol1/PRPC718/scripts/setupDatabase.xml:1975: Java returned: 1
Last Update

Steps to Reproduce

1. Design file related to rules upgrade in single schema.
2. Run the file for the rules schema.

Root Cause

The rules schema of  Pega 7.1.7 has PZINSKEY primary key defined as NOT NULL column in the table pr_log_reportstats. Due to the bug in the upgrade step, the DDL script generated contains the SQL statement to modify the field to NOT NULL. This script throws an error during upgrade.


1. Edit the DDL script (PRPC_DISTRIBUTION/schema/generated/oracledate/update/oracledate.sql ) manually, and comment the faulty DDL statement.
     /* ALTER TABLE RULES.pr_log_reportstats MODIFY pzInsKey NOT NULL  */

2. Run the DDL and UDF scripts manually from PRPC_DISTRIBUTION/schema/generated/oracledate/update/oracledate.sql and PRPC_DISTRIBUTION/schema/generated/oracledate/update/udfstatements sql files. 

3. Set the properties given below to true in file, in order to bypass the DDL and UDF generation into the schema. 

4. Run script.

Published March 5, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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