Question
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
Hi,
As Sudhakar mentioned, please attach the complete log file.
Incase if you’re seeing cluster related errors you can follow below article
https://pdn.pega.com/community/product-support/question/pega-73-ignite-…
Thanks,
Arun
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.
https://pdn.pega.com/support-articles/ora-00001-unique-constraint-error…
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
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.