2 Replies Latest reply on Jul 11, 2011 5:03 PM by Maciej Swiderski

    JBPM 5.1 Final Release with jboss-5.1.0.GA - jbpm-console - startprocess

    priyakpandey Newbie

      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