CS Framework install fails unique constraint error
SummaryThe CS jar import failing in user's QA environment. Itwas successful in lower environment.
Error MessagesUpon 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
- Launch the import wizard
- Import the CS jar file.
Root CauseA defect or configuration issue in the operating environment:Primary key with the similar value already exists in the pr4_fieldvalue table.
ResolutionPerform 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