jnorris [
https://community.jboss.org/people/jnorris] created the discussion
"Re: Exception retrieving task"
To view the discussion, visit:
https://community.jboss.org/message/745166#745166
--------------------------------------------------------------
I changed the handler to AsyncMinaHTWorkItemHandler and now I am getting more detailed
logging. This is the log on the server when a process is started. And indeed it looks
like it is only inserting 2 rows in the I18NText table:
[java] Task service started correctly!
[java] Task service running ...
[java] Hibernate: select user0_.id as id6_0_ from OrganizationalEntity user0_ where
user0_.id=? and user0_.DTYPE='User'
[java] Hibernate: select user0_.id as id6_0_ from OrganizationalEntity user0_ where
user0_.id=? and user0_.DTYPE='User'
[java] Hibernate: select hibernate_sequence.nextval from dual
[java] Hibernate: select user_.id from OrganizationalEntity user_ where user_.id=?
[java] Hibernate: select I18NTEXT_ID_SEQ.nextval from dual
[java] Hibernate: select I18NTEXT_ID_SEQ.nextval from dual
[java] Hibernate: select CONTENT_ID_SEQ.nextval from dual
[java] Hibernate: insert into Task (archived, allowedToDelegate, taskInitiator_id,
priority, activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType,
documentContentId, docume
ntType, expirationTime, faultAccessType, faultContentId, faultName, faultType,
outputAccessType, outputContentId, outputType, parentId, previousStatus, processId,
processInstanceId, processSessionId,
skipable, status, workItemId, OPTLOCK, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[java] Hibernate: insert into I18NText (language, text, id) values (?, ?, ?)
[java] Hibernate: insert into I18NText (language, text, id) values (?, ?, ?)
[java] 52125 29/06 16:46:40,984[NioProcessor-2] ERROR
hibernate.util.JDBCExceptionReporter.logExceptions - ORA-00001: unique constraint
(JBPM_BOM_USR.SYS_C0020033) violated
[java]
[java] 52125 29/06 16:46:40,984[NioProcessor-2] ERROR
hibernate.util.JDBCExceptionReporter.logExceptions - ORA-00001: unique constraint
(JBPM_BOM_USR.SYS_C0020033) violated
[java]
[java] 52125 29/06 16:46:40,984[NioProcessor-2] ERROR
event.def.AbstractFlushingEventListener.performExecutions - Could not synchronize
database state with session
[java] org.hibernate.exception.ConstraintViolationException: Could not execute JDBC
batch update
[java] at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
[java] at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
[java] at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
[java] at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
[java] at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
[java] at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
[java] at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2242)
[java] at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678)
[java] at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
[java] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
[java] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
[java] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
[java] at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
[java] at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
[java] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
[java] at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)
[java] at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
[java] at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
[java] at
org.jbpm.task.service.persistence.TaskLocalTransactionManager.commit(TaskLocalTransactionManager.java:55)
[java] at
org.jbpm.task.service.persistence.TaskPersistenceManager.endTransaction(TaskPersistenceManager.java:86)
[java] at
org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:982)
[java] at
org.jbpm.task.service.TaskServiceSession.addTask(TaskServiceSession.java:186)
[java] at
org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:144)
[java] at
org.jbpm.task.service.mina.MinaTaskServerHandler.messageReceived(MinaTaskServerHandler.java:41)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
[java] at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427)
[java] at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
[java] at
org.apache.mina.filter.logging.LoggingFilter.messageReceived(LoggingFilter.java:177)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
[java] at
org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)
[java] at
org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:692)
[java] at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:645)
[java] at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:634)
[java] at
org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollingIoProcessor.java:66)
[java] at
org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1078)
[java] at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
[java] at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[java] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[java] at java.lang.Thread.run(Thread.java:662)
[java] Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint
(JBPM_BOM_USR.SYS_C0020033) violated
--------------------------------------------------------------
Reply to this message by going to Community
[
https://community.jboss.org/message/745166#745166]
Start a new discussion in jBPM at Community
[
https://community.jboss.org/choose-container!input.jspa?contentType=1&...]