Support Article
unique constraint (RULES.PR_DATA _PRODUCTS_PK) violated error
SA-32043
Summary
System throws unique constraint (RULES.PR_DATA _PRODUCTS_PK) violated error while re-installing the existing hotfix with updated version.
Error Messages
[java] com.pega.pegarules.pub.PRException: Exception caught processing DL file: Could not save rollback information for an installed hotfix: ORA-00001: unique constraint (RULES.PR_DATA _PRODUCTS_PK) violated
Steps to Reproduce
Apply the old version of HFix-27918 followed by its updated version.
Root Cause
pyLastReservedID is not updated properly while installing the hotfix.
Resolution
Perform the following local-change:
- Take the backup of the table pc_data_uniqueid;
- Check pyLastReservedID for the table for entry HOTFIXORDER- by running the following query: select pyLastReservedID from dbo.pc_data_uniqueid where pxInsName='!HOTFIXORDER-'
- Note the pyLastReservedID.
- Take a note of highest hotfix order number from dbo.pr_data_products table by running the following query: select pyUniqueID from dbo.pr_data_products;
- For example, if it is HOTFIXORDER-8, update the table with pc_data_uniqueid as given below, and try installing the DL:
UPDATE dbo.pc_data_uniqueid
SET pyLastReservedID='10' // (increase the no. by 2)
WHERE pxInsName='!HOTFIXORDER-';
Published January 12, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.