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



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

Error Messages

...\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] 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.


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

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