ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint violated in jBPM5
Issue
- I get errors while persisting details into JBPM database.
2012-10-17 16:12:02,299 ERROR [STDERR] (http-0.0.0.0-8443-4) 95819563 [http-0.0.0.0-8443-4] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
2012-10-17 16:12:02,299 ERROR [STDERR] (http-0.0.0.0-8443-4) 95819563 [http-0.0.0.0-8443-4] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (XXX.SYS_C004892) violated
2012-10-17 16:12:02,299 ERROR [STDERR] (http-0.0.0.0-8443-4) 95819563 [http-0.0.0.0-8443-4] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
2012-10-17 16:12:02,299 ERROR [STDERR] (http-0.0.0.0-8443-4) 95819563 [http-0.0.0.0-8443-4] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (XXX.SYS_C004892) violated
2012-10-17 16:12:02,299 ERROR [STDERR] (http-0.0.0.0-8443-4) 95819563 [http-0.0.0.0-8443-4] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
2012-10-17 16:12:02,299 ERROR [STDERR] (http-0.0.0.0-8443-4) org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
2012-10-17 16:12:02,300 ERROR [STDERR] (http-0.0.0.0-8443-4) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
2012-10-17 16:12:02,300 ERROR [STDERR] (http-0.0.0.0-8443-4) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
2012-10-17 16:12:02,300 ERROR [STDERR] (http-0.0.0.0-8443-4) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
2012-10-17 16:12:02,300 ERROR [STDERR] (http-0.0.0.0-8443-4) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
or
13:53:11,561 ERROR [org.drools.persistence.SingleSessionCommandService] (http-localhost/127.0.0.1:8080-1) Could not commit session: java.lang.RuntimeException: Unable to commit transaction
at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:182) [drools-persistence-jpa-5.3.1.BRMS.jar:5.3.1.BRMS]
...
Caused by: javax.transaction.RollbackException: ARJUNA016053: Could not commit transaction.
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1177)
at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:117)
at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)
at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:167)
at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:179) [drools-persistence-jpa-5.3.1.BRMS.jar:5.3.1.BRMS]
... 38 more
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: ORA-00001: unique constraint (BRMS.SYS_C0036086) violated
...
Environment
- Red Hat JBoss Enterprise Business Rules Management System (BRMS)
- 5.3.x
- Oracle
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.