Question
Accenture Federal Services
US
Last activity: 4 Mar 2016 14:16 EST
Getting ORA-00001: unique constraint violated when running install.sh
I'm in the process of installing Pega 7.1.9 with Oracle WebLogic, and ran into this error while running install.sh:
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PEGA_RULES.PR4_RULE_PROPERTY_PK) violated
This message was followed by a multitude of errors like the following (differing only by the key):
ERROR - The update for instance of type Rule-Obj-Property with key RULE-OBJ-PROPERTY @BASECLASS PXALLCHANGELIST #20130918T234213.729 GMT was aborted.
I checked my schema against the SQL scripts I ran (following the Installation Guide), and everything appears to have been set up correctly. Does anyone know what might be causing this primary key violation during installation?
Pegasystems Inc.
US
Did you try running the install script earlier, it failed and then re-ran install? This is because the PRPC install is trying to install rules data and your table is not clean.
Accepted Solution
Pegasystems Inc.
US
You may try cleaning up the schema using the drop_oracle.sql located under the /schema/generated/oracle/install folder and re-run the install.