topic Ignoring ActivitiOptimisticLockingException: deleting job in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/ignoring-activitioptimisticlockingexception-deleting-job/m-p/68674#M44058 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I have only script tasks in my workflow and am using multi-instance. I observed that the following exception is thrown many times after the script tasks have successfully executed. </SPAN><BR /><SPAN>Oct 25, 2011 1:18:47 AM org.activiti.engine.impl.interceptor.CommandContext close</SPAN><BR /><SPAN>SEVERE: Error while closing command context</SPAN><BR /><SPAN>org.activiti.engine.ActivitiOptimisticLockingException: ExecutionEntity[13] was updated by another transaction concurrently</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:435)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:348)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:147)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:103)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.dell.activiti.interceptors.RetryInterceptorImpl.execute(RetryInterceptorImpl.java:58)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:36)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:662)</SPAN><BR /><BR /><SPAN>Since my delegate script tasks are successfully completed, I would like to ignore this exception (do not want to retry which re-executes the script tasks). I inserted an interceptor,&nbsp; caught this exception? I tried to ignore it but found that i need to delete the job. Is there a way to delete a job that just threw ActivitiOptimisticLockingException?</SPAN><BR /><BR /><SPAN>// my interceptor</SPAN><BR /><SPAN> public &lt;T&gt; T execute(Command&lt;T&gt; command) {</SPAN><BR /><BR /><SPAN> try {</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // try to execute the command</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return next.execute(command);</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (ActivitiOptimisticLockingException e) {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; // here command has job id but there is no accessor method.</SPAN><BR /><SPAN>&nbsp;&nbsp; // if i could get jobid, i could delete the job</SPAN><BR /><SPAN>&nbsp;&nbsp; // next.execute(new DeleteJobsCmd(jobid);</SPAN><BR /><SPAN>&nbsp; }</SPAN><BR /><SPAN>}</SPAN></BODY></HTML> Tue, 25 Oct 2011 16:37:06 GMT workflowuser 2011-10-25T16:37:06Z Ignoring ActivitiOptimisticLockingException: deleting job https://connect.hyland.com/t5/alfresco-archive/ignoring-activitioptimisticlockingexception-deleting-job/m-p/68674#M44058 Hi,I have only script tasks in my workflow and am using multi-instance. I observed that the following exception is thrown many times after the script tasks have successfully executed. Oct 25, 2011 1:18:47 AM org.activiti.engine.impl.interceptor.CommandContext closeSEVERE: Error while closing command Tue, 25 Oct 2011 16:37:06 GMT https://connect.hyland.com/t5/alfresco-archive/ignoring-activitioptimisticlockingexception-deleting-job/m-p/68674#M44058 workflowuser 2011-10-25T16:37:06Z Re: Ignoring ActivitiOptimisticLockingException: deleting job https://connect.hyland.com/t5/alfresco-archive/ignoring-activitioptimisticlockingexception-deleting-job/m-p/68675#M44059 <HTML><HEAD></HEAD><BODY><SPAN>any help is appreciated.</SPAN></BODY></HTML> Wed, 26 Oct 2011 23:53:58 GMT https://connect.hyland.com/t5/alfresco-archive/ignoring-activitioptimisticlockingexception-deleting-job/m-p/68675#M44059 workflowuser 2011-10-26T23:53:58Z Re: Ignoring ActivitiOptimisticLockingException: deleting job https://connect.hyland.com/t5/alfresco-archive/ignoring-activitioptimisticlockingexception-deleting-job/m-p/68676#M44060 <HTML><HEAD></HEAD><BODY><SPAN>I have created a Jira : </SPAN><A href="http://jira.codehaus.org/browse/ACT-966" rel="nofollow noopener noreferrer">http://jira.codehaus.org/browse/ACT-966</A><BR /><SPAN>Please vote.</SPAN><BR /><BR /><SPAN>BR,</SPAN><BR /><SPAN>Meditel</SPAN></BODY></HTML> Thu, 27 Oct 2011 09:15:25 GMT https://connect.hyland.com/t5/alfresco-archive/ignoring-activitioptimisticlockingexception-deleting-job/m-p/68676#M44060 meditel 2011-10-27T09:15:25Z