# Exception while completing the user task

**URL:** <https://forum.flowable.org/t/exception-while-completing-the-user-task/1277>\
**Category:** Flowable Engine\
**Created:** [November 30, 2017, 10:16am UTC](https://forum.flowable.org/t/exception-while-completing-the-user-task/1277 "2017-11-30T10:16:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mtmanju](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/mtmanju/32/388_2.png) [@mtmanju](https://forum.flowable.org/u/mtmanju)\
**Post date:** [November 30, 2017, 10:16am UTC](https://forum.flowable.org/t/exception-while-completing-the-user-task/1277/1 "2017-11-30T10:16:47Z")

</div>

Hi Flowable Team,

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

**Process Diagram:**  
 ![demo](https://canada1.discourse-cdn.com/flex035/uploads/flowable/original/1X/c155905b7b465e20072d08fb85cfe5f83cf2ff17.png)

**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”  
> }

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [December 13, 2017, 9:15am UTC](https://forum.flowable.org/t/exception-while-completing-the-user-task/1277/2 "2017-12-13T09:15:18Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mtmanju](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/mtmanju/32/388_2.png) [@mtmanju](https://forum.flowable.org/u/mtmanju)\
**Post date:** [December 13, 2017, 11:11am UTC](https://forum.flowable.org/t/exception-while-completing-the-user-task/1277/3 "2017-12-13T11:11:12Z")

</div>

Yes. when trying to complete the user task.