Why Does All Automatic tasks Keep failing in Local Environment

Q&A
1

Hi

I am facing a strange scenario. I have a Process that I am testing in My Local Environment. The process Keeps failing at most of the automatic tasks that i have set up.
I feel this could be because these automatic task mark a change in Actor Groups.But I have configured the process to ignore and continue the process if connector fails. Still I am not sure why this is Happening.
Below is the error log .

onitasoft.engine.api.impl.transaction.flownode.ExecuteFlowNode org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=75 | HOSTNAME=INKOD2PC01149 | TENANT_ID=1 | The user <walter.bates> has executed the task [name = , display name = <1 : New test Request - Requirement Review Stakeholders>, id = <43>, parent activity instance = <42>, parent process instance = <1>, root process instance = <1>, process definition = <7683582991757822551>] with task inputs: {comments=test, approval=true}
2016-10-04 18:44:57.333 +0530 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
SEVERE: THREAD_ID=157 | HOSTNAME=INKOD2PC01149 | TENANT_ID=1 | The work [ExecuteFlowNodeWork: processInstanceId:1, flowNodeInstanceId: 45] failed. The failure will be handled.
2016-10-04 18:44:57.336 +0530 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
SEVERE: THREAD_ID=157 | HOSTNAME=INKOD2PC01149 | TENANT_ID=1 | org.bonitasoft.engine.transaction.STransactionCommitException : “PROCESS_DEFINITION_ID=7683582991757822551 | PROCESS_NAME=Demand Process | PROCESS_VERSION=1.6 | PROCESS_INSTANCE_ID=1 | ROOT_PROCESS_INSTANCE_ID=1 | FLOW_NODE_DEFINITION_ID=8838720789719047698 | FLOW_NODE_INSTANCE_ID=45 | FLOW_NODE_NAME=Update Status - Approval | bitronix.tm.internal.BitronixRollbackException: RuntimeException thrown during beforeCompletion cycle caused transaction rollback”
org.bonitasoft.engine.transaction.STransactionCommitException: PROCESS_DEFINITION_ID=7683582991757822551 | PROCESS_NAME=Demand Process | PROCESS_VERSION=1.6 | PROCESS_INSTANCE_ID=1 | ROOT_PROCESS_INSTANCE_ID=1 | FLOW_NODE_DEFINITION_ID=8838720789719047698 | FLOW_NODE_INSTANCE_ID=45 | FLOW_NODE_NAME=Update Status - Approval | bitronix.tm.internal.BitronixRollbackException: RuntimeException thrown during beforeCompletion cycle caused transaction rollback
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.commit(JTATransactionServiceImpl.java:229)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.complete(JTATransactionServiceImpl.java:197)
at com.bonitasoft.engine.transaction.JTATransactionServiceExt.executeInTransaction(JTATransactionServiceExt.java:68)
at org.bonitasoft.engine.execution.work.TxBonitaWork.work(TxBonitaWork.java:53)
at org.bonitasoft.engine.execution.work.LockProcessInstanceWork.work(LockProcessInstanceWork.java:79)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork.work(FailureHandlingBonitaWork.java:66)
at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:56)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: bitronix.tm.internal.BitronixRollbackException: RuntimeException thrown during beforeCompletion cycle caused transaction rollback
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:241)
at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:143)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.commit(JTATransactionServiceImpl.java:227)
… 12 more
Caused by: javax.persistence.OptimisticLockException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.vodafone.qa.model.DemandProcessMasterData#1]
at org.hibernate.ejb.AbstractEntityManagerImpl.wrapStaleStateException(AbstractEntityManagerImpl.java:1413)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1329)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316)
at org.hibernate.ejb.AbstractEntityManagerImpl$CallbackExceptionMapperImpl.mapManagedFlushFailure(AbstractEntityManagerImpl.java:1510)
at org.hibernate.engine.transaction.synchronization.internal.SynchronizationCallbackCoordinatorNonTrackingImpl.beforeCompletion(SynchronizationCallbackCoordinatorNonTrackingImpl.java:110)
at org.hibernate.engine.transaction.synchronization.internal.RegisteredSynchronization.beforeCompletion(RegisteredSynchronization.java:53)
at bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:532)
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:235)
… 14 more
Caused by: org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.vodafone.qa.model.DemandProcessMasterData#1]
at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:2521)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3240)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3138)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3468)
at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:140)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:304)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1159)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:404)
at org.hibernate.engine.transaction.synchronization.internal.SynchronizationCallbackCoordinatorNonTrackingImpl.beforeCompletion(SynchronizationCallbackCoordinatorNonTrackingImpl.java:105)
… 17 more

2

…I have a Process that I am testing in My Local Environment.…

When saying My Local Environment can you please say what My Local Environment is. We’re not mind readers and it will allow us to consider what/where you are running your solution.

Anyway your problem is caused by this:

Caused by: org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.vodafone.qa.model.DemandProcessMasterData#1]

It looks like another process is updating the BDM in question…

regards
Seán

PS: While I understand this may not be the answer you are looking for I believe it does answer your question, please mark as resolved by ticking the tick mark on the left of this reply so others now it is closed.

3

Comment 1

A Tip on displaying CODE/LOGS correctly in Posts:

Do not use the Supplied Buttons above, for some reason they refuse to work correctly, and despite bringing it to Bonitasofts attention, it’s low priority.

To Show Code/Logs correctly use

< code >
your code/log
< /code >

removing the spaces to allow the showing of code/logs correctly as here:

your code/log

Thanks and regards
Seán

4

Hi Sean

Thanks for your Observations.
I will keep your advice in mind next time i post a question.

The Local environment is using the Bonita Studio to directly launch the Portal and have the process installed in my system. I am not referring to any live server .

I update several field in my Database table through the Automatic tasks in question.
But there is no other database transaction apart from this.

Any suggestions as to why this is happening and how to bypass such failures .

Thanks for all your help.