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.
...\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
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 update.sh).