Hi,
I am using oracle DB instead of H2. I am also using DB authetication for jbpm-console login.
My users are present in DB for ibpm-console authentication. Organizationalentity also has entry of user(s) and group(s). For roles i make sure i form correct roles for the user. User role includes user and the group names.
I start process which has human task. This process is started from jbpm-console. I am not able to get the humen task in the personal list of the user as task creation fails with the following error on human task service console. The actorId of the task is the user id.
This is very important and i am blocked because of this. Can someone please help on this. Many Thanks in advance..
[java] javax.persistence.RollbackException: Error while commiting the transaction
[java] at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
[java] at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSess
ion.java:820)
[java] at org.jbpm.task.service.TaskServiceSession.addTask(TaskServiceSession.java:134)
[java] at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:10
9)
[java] at org.jbpm.task.service.mina.MinaTaskServerHandler.messageReceived(MinaTaskServerHa
ndler.java:41)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(
DefaultIoFilterChain.java:713)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(Def
aultIoFilterChain.java:434)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilter
Chain.java:46)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived
(DefaultIoFilterChain.java:793)
[java] at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(
ProtocolCodecFilter.java:375)
[java] at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFil
ter.java:229)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(Def
aultIoFilterChain.java:434)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilter
Chain.java:46)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived
(DefaultIoFilterChain.java:793)
[java] at org.apache.mina.filter.logging.LoggingFilter.messageReceived(LoggingFilter.java:1
76)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(Def
aultIoFilterChain.java:434)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilter
Chain.java:46)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived
(DefaultIoFilterChain.java:793)
[java] at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.
java:119)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(Def
aultIoFilterChain.java:434)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(Default
IoFilterChain.java:426)
[java] at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoPro
cessor.java:638)
[java] at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIo
Processor.java:598)
[java] at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIo
Processor.java:587)
[java] at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollin
gIoProcessor.java:61)
[java] at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPol
lingIoProcessor.java:969)
[java] at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
[java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:88
6)
[java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[java] at java.lang.Thread.run(Thread.java:662)
[java] Caused by: 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.collection.AbstractCollectionPersister.recreate(AbstractC
ollectionPersister.java:1141)
[java] at org.hibernate.action.CollectionRecreateAction.execute(CollectionRecreateAction.ja
va:58)
[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:171)
[java] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractF
lushingEventListener.java:321)
[java] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListen
er.java:50)
[java] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
[java] at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
[java] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
[java] at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
[java] ... 29 more
[java] Caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (NVE.FK9D8CF4E
C2C122ED2) violated - parent key not found
[java]
[java] at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343
)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.j
ava:10768)
[java] at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
[java] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
[java] ... 43 more