JBoss Community

created by Mahi M in jBPM - View the full discussion

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.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)