1 Reply Latest reply on Nov 21, 2012 9:06 AM by Nandeesh Narayana

    BPM console not showing up the process instances

    Ravi Evani Newbie

      Hi,

       

      I have installed SOA-P 5.3 with jBPM5 and configured to PostgreSql db.

       

      I am able to invoke the jBPM5 process from ESB and view the tasks and comeplte from bpm console.

       

      But i am  facing the below issues

       

      1. Unable to view the process instances in bpm console (business-central).

       

      2. when i restart the server I am getting the below error while starting a new process instance

       

      2012-10-04 15:47:11,295 ERROR [org.hibernate.util.JDBCExceptionReporter] (pool-31-thread-1) Batch entry 0 insert into ProcessInstanceInfo (OPTLOCK, processId, startDate, lastReadDate, lastModificationDate, state, processInstanceByteArray, InstanceId) values ('0', 'com.sample.evaluation', '2012-10-04 15:47:11.124000 +05:30:00', NULL, NULL, '0', NULL, '2') was aborted.  Call getNextException to see the cause.

      2012-10-04 15:47:11,295 WARN  [org.hibernate.util.JDBCExceptionReporter] (pool-31-thread-1) SQL Error: 0, SQLState: 23505

      2012-10-04 15:47:11,295 ERROR [org.hibernate.util.JDBCExceptionReporter] (pool-31-thread-1) ERROR: duplicate key value violates unique constraint "processinstanceinfo_pkey"

      2012-10-04 15:47:11,313 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] (pool-31-thread-1) Could not synchronize database state with session

      org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

                at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)

                at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

                at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)

                at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)

                at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)

                at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)

                at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2242)

                at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678)

                at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)

                at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:278)

                at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:262)

                at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:166)

                at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

                at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)

                at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1030)

                at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:367)

                at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)

                at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)

                at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:272)

                at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)

                at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:160)

                at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1433)

                at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)

                at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

                at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:162)

                at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:179)

                at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:359)

                at org.drools.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:223)

                at org.jboss.soa.esb.services.jbpm5.actions.Bpm5Processor.process(Bpm5Processor.java:115)

                at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.processPipeline(ActionProcessingPipeline.java:665)

                at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.processPipeline(ActionProcessingPipeline.java:612)

                at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.process(ActionProcessingPipeline.java:442)

                at org.jboss.soa.esb.listeners.message.MessageAwareListener$TransactionalRunner.run(MessageAwareListener.java:587)

                at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

                at java.lang.Thread.run(Unknown Source)

      Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into ProcessInstanceInfo (OPTLOCK, processId, startDate, lastReadDate, lastModificationDate, state, processInstanceByteArray, InstanceId) values ('0', 'com.sample.evaluation', '2012-10-04 15:47:11.124000 +05:30:00', NULL, NULL, '0', NULL, '2') was aborted.  Call getNextException to see the cause.

                at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)

                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)

                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)

                at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)

                at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

                at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

                ... 33 more

      2012-10-04 15:47:11,315 WARN  [com.arjuna.ats.arjuna.logging.arjLoggerI18N] (pool-31-thread-1) [com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator_2] TwoPhaseCoordinator.beforeCompletion - failed for com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple@bcda51 Drive beforeCompletion participants.

      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 com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)

                at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:272)

                at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)

                at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:160)

                at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1433)

                at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)

                at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

                at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:162)

                at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:179)

                at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:359)

                at org.drools.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:223)

                at org.jboss.soa.esb.services.jbpm5.actions.Bpm5Processor.process(Bpm5Processor.java:115)

                at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.processPipeline(ActionProcessingPipeline.java:665)

                at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.processPipeline(ActionProcessingPipeline.java:612)

                at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.process(ActionProcessingPipeline.java:442)

                at org.jboss.soa.esb.listeners.message.MessageAwareListener$TransactionalRunner.run(MessageAwareListener.java:587)

                at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

                at java.lang.Thread.run(Unknown Source)

      Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

                at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)

                at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

                at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)

                at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)

                at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)

                at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)

                at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2242)

                at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678)

                at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)

                at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:278)

                at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:262)

                at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:166)

                at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

                at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)

                at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1030)

                at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:367)

                at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)

                ... 19 more

      Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into ProcessInstanceInfo (OPTLOCK, processId, startDate, lastReadDate, lastModificationDate, state, processInstanceByteArray, InstanceId) values ('0', 'com.sample.evaluation', '2012-10-04 15:47:11.124000 +05:30:00', NULL, NULL, '0', NULL, '2') was aborted.  Call getNextException to see the cause.

                at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)

                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)

                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)

                at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)

                at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

                at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

                ... 33 more

      2012-10-04 15:47:11,317 WARN  [org.drools.persistence.jta.JtaTransactionManager] (pool-31-thread-1) Unable to commit transaction

      javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] Could not commit transaction.

       

       

      the process works fine only after deleting the entries from the tables 'processinstanceinfo' and 'variableinstancelog'.

       

      3. when a process completes the entry is getting deleted from the db. Is there any way to get the completed process instance details?

       

      4. Is there any option to resubmit the failed process instances?

       

      5. How to invoke a web service from the JBPM5 process?

       

      Kindly help me.

       

      Thanks,

      Ravi

        • 1. Re: BPM console not showing up the process instances
          Nandeesh Narayana Newbie

          Hi Ravi,

          I am having same kind of issue. I am using soa-p5.3 server and trying to make a call between jboss esb and jbpm5. I tried quickstart example i,e bpm5processor and it is working.

          But this example won't tell how to deploy sample.bpmn process in soa-p5.3 server. I am not able to deploy through jbpm-console because it will look only for process-definition.xml. 

          Can you please let me know how did you deployed the process, so it came up in jbpm-console.

          Appreciate your quick help in this regard.

           

          Thanks

          Nandeesh