[jBPM] - Re: java.sql.BatchUpdateException: ORA-00001: unique constraint (DB007.SYS_C0044325) violated
6:01 a.m.
Prashanth Karnam [https://community.jboss.org/people/pras_karnam] created the discussion
"Re: java.sql.BatchUpdateException: ORA-00001: unique constraint (DB007.SYS_C0044325)
violated"
To view the discussion, visit: https://community.jboss.org/message/720417#720417
--------------------------------------------------------------
Check the logs for jBPM hibernate queries being executed after starting a process , this
is mainly because one of the parameters in the query is null or the user in the first task
is not available in the organizationalentity table.
regards
Prashanth Karnam
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/720417#720417]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
7:13 a.m.
Mahi M [https://community.jboss.org/people/jbpm_new] created the discussion
"Re: java.sql.BatchUpdateException: ORA-00001: unique constraint (DB007.SYS_C0044325)
violated"
To view the discussion, visit: https://community.jboss.org/message/720774#720774
--------------------------------------------------------------
Hi Prashanth,
Please find the exact exception. I confirmed your reply. Actully I am getting this
exception very rarely. I mean 1 in 10 process launchs.
I am able to launch the process successfully 9 times but one time i am getting the
following exception. So i am forced to mark this exception as a high threat for my overall
application.
If you have any idea on this Please do tell.
I am getting the below exception whenever i proceed with my application in JBPM 5.2.
Please do share some information to get out of it.
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)
at
bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:478)
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:193)
at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:120)
at
org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:179)
at
org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:348)
at
org.drools.command.impl.CommandBasedStatefulKnowledgeSession$1.completeWorkItem(CommandBasedStatefulKnowledgeSession.java:150)
at
com.jpmorgan.tss.dm.service.scheduler.common.UpdateIRCatgoryJob.completeWorkItem(UpdateIRCatgoryJob.java:155)
at
com.jpmorgan.tss.dm.service.scheduler.common.UpdateIRCatgoryJob.execute(UpdateIRCatgoryJob.java:78)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint
(DM154.SYS_C0044325) violated
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:498)
at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12432)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 17 more
Feb 23, 2012 6:42:21 PM org.drools.persistence.jta.JtaTransactionManager commit
WARNING: Unable to commit transaction
javax.persistence.PersistenceException:
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
at
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:513)
at
bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:478)
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:193)
at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:120)
at
org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:179)
at
org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:348)
at
org.drools.command.impl.CommandBasedStatefulKnowledgeSession$1.completeWorkItem(CommandBasedStatefulKnowledgeSession.java:150)
at
com.jpmorgan.tss.dm.service.scheduler.common.UpdateIRCatgoryJob.completeWorkItem(UpdateIRCatgoryJob.java:155)
at
com.jpmorgan.tss.dm.service.scheduler.common.UpdateIRCatgoryJob.execute(UpdateIRCatgoryJob.java:78)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC
batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)
... 10 more
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint
(DM154.SYS_C0044325) violated
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:498)
at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12432)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 17 more
Feb 23, 2012 6:42:21 PM org.drools.persistence.SingleSessionCommandService
rollbackTransaction
SEVERE: Could not commit session
java.lang.RuntimeException: Unable to commit transaction
at
org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:182)
at
org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:348)
at
org.drools.command.impl.CommandBasedStatefulKnowledgeSession$1.completeWorkItem(CommandBasedStatefulKnowledgeSession.java:150)
at
com.jpmorgan.tss.dm.service.scheduler.common.UpdateIRCatgoryJob.completeWorkItem(UpdateIRCatgoryJob.java:155)
at
com.jpmorgan.tss.dm.service.scheduler.common.UpdateIRCatgoryJob.execute(UpdateIRCatgoryJob.java:78)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
at
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:513)
at
bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:478)
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:193)
at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:120)
at
org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:179)
... 6 more
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC
batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hiber
Thanks
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/720774#720774]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
7:23 a.m.
Mahi M [https://community.jboss.org/people/jbpm_new] created the discussion
"Re: java.sql.BatchUpdateException: ORA-00001: unique constraint (DB007.SYS_C0044325)
violated"
To view the discussion, visit: https://community.jboss.org/message/720775#720775
--------------------------------------------------------------
Hi Prashanth thanks for the reply, I confirmed your reply on this exception.
Actually I am getting this exception randomly. I mean 1 in 10 times.
I can able to launch the process successfully 9 times but one time I am getting this
constaraint violation exception.
Detailed Log for your reference,
Please so reply as i am forced to mark it as a high threat as it is happening
aperiodically.
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)
at
bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:478)
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:193)
at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:120)
at
org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:179)
at
org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:348)
at
org.drools.command.impl.CommandBasedStatefulKnowledgeSession$1.completeWorkItem(CommandBasedStatefulKnowledgeSession.java:150)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint
(DM154.SYS_C0044325) violated
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:498)
at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12432)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 17 more
Feb 23, 2012 6:42:21 PM org.drools.persistence.jta.JtaTransactionManager commit
WARNING: Unable to commit transaction
javax.persistence.PersistenceException:
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
at
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:513)
at
bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:478)
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:193)
at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:120)
at
org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:179)
at
org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:348)
at
org.drools.command.impl.CommandBasedStatefulKnowledgeSession$1.completeWorkItem(CommandBasedStatefulKnowledgeSession.java:150)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC
batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)
... 10 more
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint
(DM154.SYS_C0044325) violated
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:498)
at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12432)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 17 more
Feb 23, 2012 6:42:21 PM org.drools.persistence.SingleSessionCommandService
rollbackTransaction
SEVERE: Could not commit session
java.lang.RuntimeException: Unable to commit transaction
at
org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:182)
at
org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:348)
at
org.drools.command.impl.CommandBasedStatefulKnowledgeSession$1.completeWorkItem(CommandBasedStatefulKnowledgeSession.java:150)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
at
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:513)
at
bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:478)
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:193)
at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:120)
at
org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:179)
... 6 more
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC
batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hiber
Thanks
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/720775#720775]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
8:01 a.m.
Arun V G [https://community.jboss.org/people/arunvg] created the discussion
"Re: java.sql.BatchUpdateException: ORA-00001: unique constraint (DB007.SYS_C0044325)
violated"
To view the discussion, visit: https://community.jboss.org/message/720781#720781
--------------------------------------------------------------
Please check the detail of the constraint DB007.SYS_C0044325 in your RDBMS.
Initially during the evaluation I was getting a similar issue due to the settings of
hibernate.hbm2ddl.auto in the persistence.xml
For me the issue was with the organizationalentity table .
Hope this hint helps
Cheers :)
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/720781#720781]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
4439
days inactive
4440
days old
3 comments
3 participants
participants (3)
-
Arun V G -
Mahi M
-
Prashanth Karnam