Question
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?
Accepted Solution
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.
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.