Exception while completing the user task

mtmanju · November 30, 2017, 10:16am

Hi Flowable Team,

Getting exception while completing the user task (Review Application User Task).
Can someone help me resolve this issue ?

Process Diagram:
demo

Process Def XML:

<?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:flowable="http://flowable.org/bpmn" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:omgdi="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.fico.com">
  <signal id="check_ut" name="Check_UT" flowable:scope="global"></signal>
  <process id="demo" name="Consumer Process" isExecutable="true">
    <dataObject id="input" name="input" itemSubjectRef="xsd:string">
      <extensionElements>
        <flowable:value></flowable:value>
      </extensionElements>
    </dataObject>
    <startEvent id="sid-123CB076-E02F-4491-ABD3-225A26F8BDC1"></startEvent>
    <serviceTask id="sid-0106DF3C-8F91-47BC-B2C8-C30EB5AE7830" flowable:delegateExpression="${applicationSubmission}"></serviceTask>
    <sequenceFlow id="sid-12F5884D-53D4-4142-BC7E-22D3D7FA7454" sourceRef="sid-123CB076-E02F-4491-ABD3-225A26F8BDC1" targetRef="sid-0106DF3C-8F91-47BC-B2C8-C30EB5AE7830"></sequenceFlow>
    <userTask id="sid-63C9E2D9-AB7C-41C9-8BC3-3DFE484D1AEC">
      <extensionElements>
        <flowable:taskListener event="complete" delegateExpression="${checkUT}"></flowable:taskListener>
      </extensionElements>
    </userTask>
    <sequenceFlow id="sid-910AE49B-FB96-483B-B157-D968D1328887" sourceRef="sid-0106DF3C-8F91-47BC-B2C8-C30EB5AE7830" targetRef="sid-63C9E2D9-AB7C-41C9-8BC3-3DFE484D1AEC"></sequenceFlow>
    <endEvent id="sid-534914EB-B5DC-4C0E-9D29-9C7CCA79D7F3"></endEvent>
    <sequenceFlow id="sid-38DDA7B0-2186-48B8-BC27-8356F69A9BC1" sourceRef="sid-63C9E2D9-AB7C-41C9-8BC3-3DFE484D1AEC" targetRef="sid-534914EB-B5DC-4C0E-9D29-9C7CCA79D7F3"></sequenceFlow>
    <subProcess id="sid-68F934C1-4FBB-49F9-98E1-CCE23038569F" name="subProcess" triggeredByEvent="true">
      <startEvent id="sid-6CCA373C-B58D-4C34-96DB-A65146B0BC16" isInterrupting="true">
        <signalEventDefinition signalRef="check_ut"></signalEventDefinition>
      </startEvent>
      <exclusiveGateway id="sid-39B33BC6-1BAA-4744-A5DC-4A34C26C6D6A"></exclusiveGateway>
      <scriptTask id="sid-FCE5773A-2E59-464C-9FF0-255F09E479B0" name="Display Approve" scriptFormat="groovy" flowable:autoStoreVariables="false">
        <script><![CDATA[out:println " Approved ";]]></script>
      </scriptTask>
      <endEvent id="sid-ADF7DA4E-63C8-422A-AD89-98ACF4B59FD6"></endEvent>
      <scriptTask id="sid-AB7D16AF-4A11-4BC4-8EBA-ED6521A16CFD" name="Display Declined" scriptFormat="groovy" flowable:autoStoreVariables="false">
        <script><![CDATA[out:println " Declined";]]></script>
      </scriptTask>
      <endEvent id="sid-405A7F90-CE23-4FFE-8B77-D1E7BDC39620"></endEvent>
      <sequenceFlow id="sid-E35E4B1F-428F-4BA2-BA1D-28C43967512E" sourceRef="sid-6CCA373C-B58D-4C34-96DB-A65146B0BC16" targetRef="sid-39B33BC6-1BAA-4744-A5DC-4A34C26C6D6A"></sequenceFlow>
      <sequenceFlow id="sid-35007C75-C1F9-489B-8255-60B6C31AACED" name="Approve" sourceRef="sid-39B33BC6-1BAA-4744-A5DC-4A34C26C6D6A" targetRef="sid-FCE5773A-2E59-464C-9FF0-255F09E479B0">
        <conditionExpression xsi:type="tFormalExpression"><![CDATA[${reviewDecision == 'Approve'}]]></conditionExpression>
      </sequenceFlow>
      <sequenceFlow id="sid-552C265D-FBAC-4EB4-986A-9211E0CA58B1" sourceRef="sid-FCE5773A-2E59-464C-9FF0-255F09E479B0" targetRef="sid-ADF7DA4E-63C8-422A-AD89-98ACF4B59FD6"></sequenceFlow>
      <sequenceFlow id="sid-959AA2E4-CFCB-407C-BDA5-5A873183DA49" name="Decline" sourceRef="sid-39B33BC6-1BAA-4744-A5DC-4A34C26C6D6A" targetRef="sid-AB7D16AF-4A11-4BC4-8EBA-ED6521A16CFD">
        <conditionExpression xsi:type="tFormalExpression"><![CDATA[${reviewDecision == 'Decline'}]]></conditionExpression>
      </sequenceFlow>
      <sequenceFlow id="sid-F1424EFE-DD27-4111-BF8C-30A283D938E5" sourceRef="sid-AB7D16AF-4A11-4BC4-8EBA-ED6521A16CFD" targetRef="sid-405A7F90-CE23-4FFE-8B77-D1E7BDC39620"></sequenceFlow>
    </subProcess>
  </process>
  <bpmndi:BPMNDiagram id="BPMNDiagram_consumerprocess-microflows">
    <bpmndi:BPMNPlane bpmnElement="consumerprocess-microflows" id="BPMNPlane_consumerprocess-microflows">
      <bpmndi:BPMNShape bpmnElement="sid-123CB076-E02F-4491-ABD3-225A26F8BDC1" id="BPMNShape_sid-123CB076-E02F-4491-ABD3-225A26F8BDC1">
        <omgdc:Bounds height="30.0" width="30.0" x="71.0" y="193.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-0106DF3C-8F91-47BC-B2C8-C30EB5AE7830" id="BPMNShape_sid-0106DF3C-8F91-47BC-B2C8-C30EB5AE7830">
        <omgdc:Bounds height="80.0" width="100.0" x="150.0" y="168.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-63C9E2D9-AB7C-41C9-8BC3-3DFE484D1AEC" id="BPMNShape_sid-63C9E2D9-AB7C-41C9-8BC3-3DFE484D1AEC">
        <omgdc:Bounds height="80.0" width="100.0" x="285.0" y="165.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-534914EB-B5DC-4C0E-9D29-9C7CCA79D7F3" id="BPMNShape_sid-534914EB-B5DC-4C0E-9D29-9C7CCA79D7F3">
        <omgdc:Bounds height="28.0" width="28.0" x="440.0" y="191.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-68F934C1-4FBB-49F9-98E1-CCE23038569F" id="BPMNShape_sid-68F934C1-4FBB-49F9-98E1-CCE23038569F">
        <omgdc:Bounds height="261.0" width="482.0" x="45.0" y="285.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-6CCA373C-B58D-4C34-96DB-A65146B0BC16" id="BPMNShape_sid-6CCA373C-B58D-4C34-96DB-A65146B0BC16">
        <omgdc:Bounds height="30.0" width="30.0" x="71.0" y="340.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-39B33BC6-1BAA-4744-A5DC-4A34C26C6D6A" id="BPMNShape_sid-39B33BC6-1BAA-4744-A5DC-4A34C26C6D6A">
        <omgdc:Bounds height="40.0" width="40.0" x="176.0" y="335.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-FCE5773A-2E59-464C-9FF0-255F09E479B0" id="BPMNShape_sid-FCE5773A-2E59-464C-9FF0-255F09E479B0">
        <omgdc:Bounds height="80.0" width="115.0" x="285.0" y="315.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-ADF7DA4E-63C8-422A-AD89-98ACF4B59FD6" id="BPMNShape_sid-ADF7DA4E-63C8-422A-AD89-98ACF4B59FD6">
        <omgdc:Bounds height="28.0" width="28.0" x="440.0" y="341.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-AB7D16AF-4A11-4BC4-8EBA-ED6521A16CFD" id="BPMNShape_sid-AB7D16AF-4A11-4BC4-8EBA-ED6521A16CFD">
        <omgdc:Bounds height="76.0" width="132.0" x="130.0" y="450.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape bpmnElement="sid-405A7F90-CE23-4FFE-8B77-D1E7BDC39620" id="BPMNShape_sid-405A7F90-CE23-4FFE-8B77-D1E7BDC39620">
        <omgdc:Bounds height="28.0" width="28.0" x="307.0" y="474.0"></omgdc:Bounds>
      </bpmndi:BPMNShape>
      <bpmndi:BPMNEdge bpmnElement="sid-552C265D-FBAC-4EB4-986A-9211E0CA58B1" id="BPMNEdge_sid-552C265D-FBAC-4EB4-986A-9211E0CA58B1">
        <omgdi:waypoint x="400.0" y="355.0"></omgdi:waypoint>
        <omgdi:waypoint x="440.0" y="355.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="sid-910AE49B-FB96-483B-B157-D968D1328887" id="BPMNEdge_sid-910AE49B-FB96-483B-B157-D968D1328887">
        <omgdi:waypoint x="250.0" y="206.88888888888889"></omgdi:waypoint>
        <omgdi:waypoint x="285.0" y="206.11111111111111"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="sid-38DDA7B0-2186-48B8-BC27-8356F69A9BC1" id="BPMNEdge_sid-38DDA7B0-2186-48B8-BC27-8356F69A9BC1">
        <omgdi:waypoint x="385.0" y="205.0"></omgdi:waypoint>
        <omgdi:waypoint x="440.0" y="205.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="sid-35007C75-C1F9-489B-8255-60B6C31AACED" id="BPMNEdge_sid-35007C75-C1F9-489B-8255-60B6C31AACED">
        <omgdi:waypoint x="215.56529209621993" y="355.43470790378007"></omgdi:waypoint>
        <omgdi:waypoint x="285.0" y="355.19691780821915"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="sid-959AA2E4-CFCB-407C-BDA5-5A873183DA49" id="BPMNEdge_sid-959AA2E4-CFCB-407C-BDA5-5A873183DA49">
        <omgdi:waypoint x="196.4280303030303" y="374.5719696969697"></omgdi:waypoint>
        <omgdi:waypoint x="196.1433962264151" y="450.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="sid-F1424EFE-DD27-4111-BF8C-30A283D938E5" id="BPMNEdge_sid-F1424EFE-DD27-4111-BF8C-30A283D938E5">
        <omgdi:waypoint x="262.0" y="488.0"></omgdi:waypoint>
        <omgdi:waypoint x="307.0" y="488.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="sid-12F5884D-53D4-4142-BC7E-22D3D7FA7454" id="BPMNEdge_sid-12F5884D-53D4-4142-BC7E-22D3D7FA7454">
        <omgdi:waypoint x="101.0" y="208.0"></omgdi:waypoint>
        <omgdi:waypoint x="150.0" y="208.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge bpmnElement="sid-E35E4B1F-428F-4BA2-BA1D-28C43967512E" id="BPMNEdge_sid-E35E4B1F-428F-4BA2-BA1D-28C43967512E">
        <omgdi:waypoint x="101.0" y="355.0"></omgdi:waypoint>
        <omgdi:waypoint x="176.0" y="355.0"></omgdi:waypoint>
      </bpmndi:BPMNEdge>
    </bpmndi:BPMNPlane>
  </bpmndi:BPMNDiagram>
</definitions>

Exception:

{
“timestamp”: 1512021214060,
“status”: 500,
“error”: “Internal Server Error”,
“exception”: “org.apache.ibatis.exceptions.PersistenceException”,
“message”: “\n### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (mylocaldb.ACT_RU_IDENTITYLINK, CONSTRAINT ACT_FK_IDL_PROCINST FOREIGN KEY (PROC_INST_ID_) REFERENCES ACT_RU_EXECUTION (ID_))\n### The error may involve org.flowable.engine.impl.persistence.entity.ExecutionEntityImpl.deleteExecution-Inline\n### The error occurred while setting parameters\n### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?\n### Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (mylocaldb.ACT_RU_IDENTITYLINK, CONSTRAINT ACT_FK_IDL_PROCINST FOREIGN KEY (PROC_INST_ID_) REFERENCES ACT_RU_EXECUTION (ID_))”,
“path”: “/runtime/tasks/92”
}

joram · December 13, 2017, 9:15am

When do you get this error? When firing a signal?

mtmanju · December 13, 2017, 11:11am

Yes. when trying to complete the user task.

Topic		Replies	Views
Error when used "Execution listeners" at Http-task Flowable Engine	1	226	September 22, 2022
How to handle exceptions and restart the process Flowable Engine	6	2194	February 17, 2020
Error starting new process instance (HTTP 500) Flowable Engine	12	1613	March 18, 2020
Problem with getting "startableByUser" processes Flowable Engine	3	661	January 28, 2019
Holiday-request.bpmn20.xml - org.flowable.bpmn.exceptions.XMLException: Error reading XML Flowable Engine	1	1146	July 30, 2018

Exception while completing the user task

Related topics