1 Reply Latest reply on Nov 21, 2012 9:06 AM by nandeesh.ln

BPM console not showing up the process instances

eravisankar1984 Oct 22, 2012 2:42 AM

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)