[jboss-user] [jBPM] - BPM console not showing up the process instances

Ravi Evani [https://community.jboss.org/people/eravisankar1984] created the discussion "BPM console not showing up the process instances" To view the discussion, visit: https://community.jboss.org/message/771398#771398 -------------------------------------------------------------- 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 -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/771398#771398] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]