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).