Question

3
Replies
136
Views
mkarunagama Member since 2013 2 posts
Virtusa Corp.
Posted: 8 months ago
Last activity: 7 months 3 weeks ago

Violation of PRIMARY KEY constraint 'pr4_rule_property_PK'. Cannot insert duplicate key

Getting the below error for multiple rules during an import process. We have checked the table before importing the product and verified that the mentioned rules do not exist in the table. But still we encounter the same duplicate key issue everytime we try the process from the scratch. anyone has encountered this ?

RULE-OBJ-PROPERTY VIRT-FW-CMFW-DATA-APPSETTINGS-SLA CASESLADATA #20180522T121005.153 GMT

Save Failed: Violation of PRIMARY KEY constraint 'pr4_rule_property_PK'. Cannot insert duplicate key in object 'PegaRULES.pr4_rule_property'. The duplicate key value is (RULE-OBJ-PROPERTY VIRT-FW-CMFW-DATA-APPSETTINGS-SLA CASESLADATA #20180522T121005.153 GMT). DatabaseException caused by prior exception: java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'pr4_rule_property_PK'. Cannot insert duplicate key in object 'PegaRULES.pr4_rule_property'. The duplicate key value is (RULE-OBJ-PROPERTY VIRT-FW-CMFW-DATA-APPSETTINGS-SLA CASESLADATA #20180522T121005.153 GMT). | SQL Code: 2627 | SQL State: 23000

Share this page LinkedIn