Question
TCS
IN
Last activity: 11 Jan 2018 9:51 EST
unique constraint PEGA_RULES.PR_ASSEMBLEDCLASSES_PK violation error
Hi,
when we are running performance test in our application we are getting the below error frequently. please let me know if you have came across this one.
java.sql.SQLIntegrityConstraintViolationException ORA-00001: unique constraint (PEGA_RULES.PR_ASSEMBLEDCLASSES_PK) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) at
JPMorgan Chase & Company
US
Hi,
In performance testing SQLIntegrityConstraintViolationException will come when multiple requestor performing the same operation. To understand in which scenario this exception is coming please share the complete stack trace.
Pegasystems Inc.
IN
Incase if you’re seeing cluster related errors you can follow below article
Thanks,
Arun
TCS
IN
Thanks for your responses. I will share the complete log.
But one thing to note here is unique key violation error happened in PEGA_RULES.PR_ASSEMBLEDCLASSES which is PRPC's internal rule engine table.
Also i found the below article in PDN (which is closely related) after I have posted the message.
based on the article, my understanding is I am getting the above exception because it is PRPC's way of handling things. Please share your thoughts.
Thanks,
Siva