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 |
Pegasystems Inc.
IN
Verify in prconfig.xml, if "database\databases\database_name\batchUpdates" setting is present.
Or please verify if the same is present as DSS.
Updated: 5 Nov 2020 9:05 EST
Lanit
RU
@nimmm Hello, we are have same issue, are you can explain which value must be in mentioned DSS ? We also notice issue don't rely on thus settings, because we have multiple environments and currently we have problem only at one environment.
Anthem Inc
US
Is there any on the import process engine or batch DB updates , we are also facing this issue on the 7.2.1 version while importing a fresh new ( all new rules ) product file in our higher environment.