Activiti 6: Cannot Cancel Process

chrisx_212 — Mon, 14 Mar 2016 07:58:34 GMT

Everytime I try to cancel a process in Activiti 6, I get this message:### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`activiti6`.`act_ru_execution`, CONSTRAINT `ACT

Re: Activiti 6: Cannot Cancel Process

jbarrez — Tue, 15 Mar 2016 10:25:21 GMT

Can you post the process XML and also what method calls you're doing exactly?

Re: Activiti 6: Cannot Cancel Process

chrisx_212 — Wed, 16 Mar 2016 05:49:29 GMT

The BPMN is as follows:

<code><?xml version="1.0" encoding="UTF-8"?>
<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:activiti="http://activiti.org/bpmn" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlnsmgdc="http://www.omg.org/spec/DD/20100524/DC" xmlnsmgdi="http://www.omg.org/spec/DD/20100524/DI" typeLanguage="http://www.w3.org/2001/XMLSchema" expressionLanguage="http://www.w3.org/1999/XPath" targetNamespace="http://www.activiti.org/processdef">
<process id="two-step-process" name="two-step-process" isExecutable="true">
    <startEvent id="startEvent1" activiti:isInterrupting="false"></startEvent>
    <userTask id="sid-A6F7F796-BE6B-45B9-A994-0BEFD52ADEF3" name="who?
" activiti:formKey="1032">
      <extensionElements>
        <modeler:form-reference-id xmlns:modeler="http://activiti.com/modeler">1032</modeler:form-reference-id>
        <modeler:form-reference-name xmlns:modeler="http://activiti.com/modeler">first-step</modeler:form-reference-name>
      </extensionElements>
    </userTask>
    <sequenceFlow id="sid-333C5162-5526-4183-A651-ADE28CE41507" sourceRef="startEvent1" targetRef="sid-A6F7F796-BE6B-45B9-A994-0BEFD52ADEF3"></sequenceFlow>
    <userTask id="sid-352279E1-34BE-4707-8FF2-B424E6916088" name="yes
" activiti:assignee="1" activiti:formKey="1033">
      <extensionElements>
        <modeler:form-reference-id xmlns:modeler="http://activiti.com/modeler">1033</modeler:form-reference-id>
        <modeler:form-reference-name xmlns:modeler="http://activiti.com/modeler">second-step</modeler:form-reference-name>
        <modeler:activiti-idm-assignee xmlns:modeler="http://activiti.com/modeler">true</modeler:activiti-idm-assignee>
        <modeler:assignee-info-email xmlns:modeler="http://activiti.com/modeler">admin@app.activiti.com</modeler:assignee-info-email>
        <modeler:assignee-info-lastname xmlns:modeler="http://activiti.com/modeler">Administrator</modeler:assignee-info-lastname>
        <modeler:initiator-can-complete xmlns:modeler="http://activiti.com/modeler">false</modeler:initiator-can-complete>
      </extensionElements>
    </userTask>
    <sequenceFlow id="sid-D33C7161-48BF-40C1-A1B7-B3F91C7F1722" sourceRef="sid-A6F7F796-BE6B-45B9-A994-0BEFD52ADEF3" targetRef="sid-352279E1-34BE-4707-8FF2-B424E6916088"></sequenceFlow>
    <endEvent id="sid-21A65A32-B840-4B0A-844A-43977612A240"></endEvent>
    <sequenceFlow id="sid-953A9505-BB1C-4CB8-85D5-2AA8B3395A5C" sourceRef="sid-352279E1-34BE-4707-8FF2-B424E6916088" targetRef="sid-21A65A32-B840-4B0A-844A-43977612A240"></sequenceFlow>
</process>
<bpmndi:BPMNDiagram id="BPMNDiagram_two-step-process">
    <bpmndi:BPMNPlane bpmnElement="two-step-process" id="BPMNPlane_two-step-process">
      <bpmndi:BPMNShape bpmnElement="startEvent1" id="BPMNShape_startEvent1">
        <omgdc:Bounds height="30.0" width="30.0" x="100.0" y="163.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-A6F7F796-BE6B-45B9-A994-0BEFD52ADEF3" id="BPMNShape_sid-A6F7F796-BE6B-45B9-A994-0BEFD52ADEF3">
        <omgdc:Bounds height="80.0" width="100.0" x="175.0" y="138.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-352279E1-34BE-4707-8FF2-B424E6916088" id="BPMNShape_sid-352279E1-34BE-4707-8FF2-B424E6916088">
        <omgdc:Bounds height="80.0" width="100.0" x="320.0" y="138.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-21A65A32-B840-4B0A-844A-43977612A240" id="BPMNShape_sid-21A65A32-B840-4B0A-844A-43977612A240">
        <omgdc:Bounds height="28.0" width="28.0" x="465.0" y="164.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNEdge bpmnElement="sid-333C5162-5526-4183-A651-ADE28CE41507" id="BPMNEdge_sid-333C5162-5526-4183-A651-ADE28CE41507">
        <omgdi:waypoint x="130.0" y="178.0"></omgdi:waypoint>
        <omgdi:waypoint x="175.0" y="178.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="sid-953A9505-BB1C-4CB8-85D5-2AA8B3395A5C" id="BPMNEdge_sid-953A9505-BB1C-4CB8-85D5-2AA8B3395A5C">
        <omgdi:waypoint x="420.0" y="178.0"></omgdi:waypoint>
        <omgdi:waypoint x="465.0" y="178.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="sid-D33C7161-48BF-40C1-A1B7-B3F91C7F1722" id="BPMNEdge_sid-D33C7161-48BF-40C1-A1B7-B3F91C7F1722">
        <omgdi:waypoint x="275.0" y="178.0"></omgdi:waypoint>
        <omgdi:waypoint x="320.0" y="178.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
    </bpmndi:BPMNPlane>
</bpmndi:BPMNDiagram>
</definitions></code>

The method I'm calling is the Runtime Service's Delete Process Instance.

Re: Activiti 6: Cannot Cancel Process

jbarrez — Fri, 18 Mar 2016 15:58:19 GMT

I've tried the following test on the v6 master:

<code>
public class MyUnitTest extends PluggableActivitiTestCase {

@Test
@Deployment(resources = { "org/activiti/test/test.bpmn20.xml" })
public void test() throws Exception {
org.h2.tools.Server.createWebServer("-web").start();

ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("two-step-process");
assertNotNull(processInstance);

runtimeService.deleteProcessInstance(processInstance.getId(), null);
assertEquals(0, runtimeService.createExecutionQuery().count());
}

}
</code>

And that succeeds.

Is that also what you tried to do?

Re: Activiti 6: Cannot Cancel Process

chrisx_212 — Fri, 29 Apr 2016 09:19:42 GMT

Sorry for not replying for long. I came across to another problem based on this.

I ended up modifying the bulkDeleteStatement in DbSqlSession by creating new queries and deleting all child elements first before deleting the parent one. It worked… except that when the command was instead 'Complete Task' instead of 'Cancel Process', things got deleted as well (they flushed the delete commands even as I tried 'Complete Task').

How do we differentiate the command so it's Cancel Process, not Complete Task?

Re: Activiti 6: Cannot Cancel Process

jbarrez — Tue, 03 May 2016 12:13:31 GMT

Not sure I'm following? How are using triggering complete task instead of cancel … ?

topic Activiti 6: Cannot Cancel Process in Alfresco Archive

Activiti 6: Cannot Cancel Process

Re: Activiti 6: Cannot Cancel Process

Re: Activiti 6: Cannot Cancel Process

Re: Activiti 6: Cannot Cancel Process

Re: Activiti 6: Cannot Cancel Process

Re: Activiti 6: Cannot Cancel Process