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

SqlIntegrityConstraintViolation during update from 7.1.7 to 7.2

SA-24667

Summary



When updating from Pega 7.1.7 to 7.2 the update tool fails with a SQL constraint violation.
 

Error Messages



BUILD FAILED
...\Pega72installfolder\pegaGuiInstallerTemp\build.xml:105: The following error occurred while executing this line:
...\Pega72installfolder\scripts\setupDatabase.xml:380: The following error occurred while executing this line:
...\Pega72installfolder\scripts\setupDatabase.xml:2279: Java returned: 1

Total time: 45 minutes 7 seconds

Following error in the log is observed:
[java] com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: Error for batch element #3: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=3;DBRERULES.PR_INDEX_REFERENCE, DRIVER=3.63.75.


Steps to Reproduce



Update from 7.1.7 to 7.2


Root Cause



The cause of this issue is the fact that the PegaUVU ruleset was refactored as Pega-UVU in Pega 7.1.8 and included in the base product, however indexes for the rules matched previous PegaUVU rules which had been imported manually in previous versions but not included in the base product.

Resolution

Remove the PegaUVU releated records in the PR_INDEX_REFERENCE table before you trigger the update using this SQL:

DELETE FROM pr_index_reference WHERE pxreferencingrulesetname LIKE 'PegaUVU%'

Then resume the update using the update script (update.bat or update.sh).

Suggest Edit

Published July 28, 2016 - 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