Support Article

CS Framework install fails unique constraint error

SA-32935

Summary



The CS jar import failing in user's QA environment. Itwas successful in lower environment.

Error Messages



Upon import following entries are observed in the logs and as well on the UI:

2017-01-19 14:48:16,660 [PegaWorkManager : 18] [ STANDARD] [ PegaRULES:07.10] ( internal.loaders.SaverLoader) ERROR - Save failed for 'RULE-OBJ-FIELDVALUE @BASECLASS PYCAPTION!BROWSE… #20160321T102308.982 GMT'
com.pega.pegarules.pub.database.DuplicateKeyException: ORA-00001: unique constraint (SSWMSR01.PR4_FIELDVALUE_PK) violated

DatabaseException caused by prior exception: java.sql.BatchUpdateException: ORA-00001: unique constraint (SSWMSR01.PR4_FIELDVALUE_PK) violated


Steps to Reproduce

  1. Launch the import wizard
  2. Import the CS jar file.

Root Cause



A defect or configuration issue in the operating environment:

Primary key with the similar value already exists in the pr4_fieldvalue table.

Resolution



Perform the following local-change:

Delete the rows which has matching keys from
pr4_fieldvalue table and rerun the import wizard.

Published January 26, 2017 - Updated January 31, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.