topic PersistenceException when CallActivity containing ServiceTask is last item in process in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/persistenceexception-when-callactivity-containing-servicetask-is/m-p/180825#M133955 <HTML><HEAD></HEAD><BODY><SPAN>I have a simple process that has a startEvent, userTask, callActivity, and endEvent.&nbsp; </SPAN><BR /><BR /><SPAN>The callActivity calls a simple process that has a startEvent, serviceTask, and endEvent.&nbsp; The serviceTask is a Java Service Task that references a bean that implements the JavaDelegate interface.&nbsp; </SPAN><BR /><BR /><SPAN>If I activate the process and complete the userTask, it kicks off the callActivity, and executes the Java Service Task (the code in the execute() method of the JavaDelegate) without error, but I ultimately get the PersistenceException below.&nbsp; I do not get this exception if the callActivity is not the last item in the process.&nbsp;&nbsp; Is this a known problem?&nbsp; Is there a workaround?&nbsp;&nbsp; </SPAN><BR /><BR /><SPAN>We are using Activiti 5.1.7.&nbsp; Please let me know if you need more information.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Sarah </SPAN><BR /><BR /><SPAN>org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error updating database.&nbsp; Cause: com.xythos.common.SqlExceptionWithParameters: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?</SPAN><BR /><SPAN>[01 (String{2}):52]</SPAN><BR /><SPAN>[02 (int):1]</SPAN><BR /><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?</SPAN><BR /><SPAN>### Cause: com.xythos.common.SqlExceptionWithParameters: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?</SPAN><BR /><SPAN>[01 (String{2}):52]</SPAN><BR /><SPAN>[02 (int):1]</SPAN><BR /><BR /><SPAN>Below are the bpmn snippets for the main process and the callActivity process.</SPAN><BR /><BR /><SPAN>Main:</SPAN><BR /><SPAN>&nbsp; &lt;bpmn2<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />rocess id="NotificationTask" name="Notification Task" isExecutable="true"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bpmn2:callActivity id="CallActivity_Notification_SystemTaskFirst" name="Notification" calledElement="_SAS_NOTIFY_"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmn2:incoming&gt;SequenceFlow_6&lt;/bpmn2:incoming&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmn2<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />utgoing&gt;SequenceFlow_4&lt;/bpmn2<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />utgoing&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/bpmn2:callActivity&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bpmn2:sequenceFlow id="SequenceFlow_4" name="" sourceRef="CallActivity_Notification_SystemTaskFirst" targetRef="EndEvent_1"/&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bpmn2:endEvent id="EndEvent_1"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmn2:incoming&gt;SequenceFlow_4&lt;/bpmn2:incoming&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/bpmn2:endEvent&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bpmn2:startEvent id="StartEvent_1"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmn2<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />utgoing&gt;SequenceFlow_5&lt;/bpmn2<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />utgoing&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/bpmn2:startEvent&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bpmn2:userTask id="UserTask_1" name="UserTask"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmn2:incoming&gt;SequenceFlow_5&lt;/bpmn2:incoming&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmn2<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />utgoing&gt;SequenceFlow_6&lt;/bpmn2<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />utgoing&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/bpmn2:userTask&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bpmn2:sequenceFlow id="SequenceFlow_5" name="" sourceRef="StartEvent_1" targetRef="UserTask_1"/&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bpmn2:sequenceFlow id="SequenceFlow_6" name="" sourceRef="UserTask_1" targetRef="CallActivity_Notification_SystemTaskFirst"/&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/bpmn2<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />rocess&gt;</SPAN><BR /><BR /><BR /><SPAN>CallActivity: </SPAN><BR /><BR /><SPAN>&nbsp; &lt;bpmn2<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />rocess id="_SAS_NOTIFY_" name="Notify" isExecutable="true"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bpmn2:serviceTask id="ServiceTask_notify" activiti:delegateExpression="${sasSystemTaskNotifyBean}" name="Notify"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmn2:incoming&gt;SequenceFlow_1&lt;/bpmn2:incoming&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmn2<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />utgoing&gt;SequenceFlow_2&lt;/bpmn2<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />utgoing&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/bpmn2:serviceTask&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bpmn2:sequenceFlow id="SequenceFlow_2" name="" sourceRef="ServiceTask_notify" targetRef="EndEvent_1"/&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bpmn2:startEvent id="StartEvent_1"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmn2<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />utgoing&gt;SequenceFlow_1&lt;/bpmn2<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />utgoing&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/bpmn2:startEvent&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bpmn2:sequenceFlow id="SequenceFlow_1" name="" sourceRef="StartEvent_1" targetRef="ServiceTask_notify"/&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bpmn2:endEvent id="EndEvent_1"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;bpmn2:incoming&gt;SequenceFlow_2&lt;/bpmn2:incoming&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/bpmn2:endEvent&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/bpmn2<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />rocess&gt;</SPAN></BODY></HTML> Fri, 13 Mar 2015 21:01:42 GMT sarahh 2015-03-13T21:01:42Z PersistenceException when CallActivity containing ServiceTask is last item in process https://connect.hyland.com/t5/alfresco-archive/persistenceexception-when-callactivity-containing-servicetask-is/m-p/180825#M133955 I have a simple process that has a startEvent, userTask, callActivity, and endEvent.&nbsp; The callActivity calls a simple process that has a startEvent, serviceTask, and endEvent.&nbsp; The serviceTask is a Java Service Task that references a bean that implements the JavaDelegate interface.&nbsp; If I activate th Fri, 13 Mar 2015 21:01:42 GMT https://connect.hyland.com/t5/alfresco-archive/persistenceexception-when-callactivity-containing-servicetask-is/m-p/180825#M133955 sarahh 2015-03-13T21:01:42Z Re: PersistenceException when CallActivity containing ServiceTask is last item in process https://connect.hyland.com/t5/alfresco-archive/persistenceexception-when-callactivity-containing-servicetask-is/m-p/180826#M133956 <HTML><HEAD></HEAD><BODY><SPAN>Do you have any JUnit test for this scenario?</SPAN></BODY></HTML> Mon, 16 Mar 2015 23:06:14 GMT https://connect.hyland.com/t5/alfresco-archive/persistenceexception-when-callactivity-containing-servicetask-is/m-p/180826#M133956 vasile_dirla 2015-03-16T23:06:14Z