topic Unable to complete parallel task (foreign key violation) in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/unable-to-complete-parallel-task-foreign-key-violation/m-p/99032#M68374 <HTML><HEAD></HEAD><BODY><SPAN>I have a problem that seems like a bug, but I'm not sure - maybe I'm doing something wrong.</SPAN><BR /><BR /><SPAN>I have two parallel tasks. During the execution some variables are added to the tasks using</SPAN><BR /><STRONG>taskService.setVariableLocal(taskId, variable, value)</STRONG><SPAN>. And now when I call </SPAN><STRONG>taskService.complete(taskId)</STRONG><SPAN> </SPAN><BR /><SPAN>on one of the tasks, I get the following error:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: update or delete on table "act_ru_execution" violates foreign key constraint "act_fk_var_exe" on table "act_ru_variable" Detail: Key (id_)=(17126) is still referenced from table "act_ru_variable". ### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline ### The error occurred while setting parameters ### SQL: delete from ACT_RU_EXECUTION where ID_ = ? ### Cause: org.postgresql.util.PSQLException: ERROR: update or delete on table "act_ru_execution" violates foreign key constraint "act_fk_var_exe" on table "act_ru_variable" Detail: Key (id_)=(17126) is still referenced from table "act_ru_variable".<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Table </SPAN><STRONG>act_ru_variable</STRONG><SPAN> has a FOREIGN_KEY that references to </SPAN><STRONG>act_ru_execution</STRONG><SPAN> (id_).</SPAN><BR /><SPAN>And it seems that when I set the task to be complete(), then Activity tries to delete the execution from </SPAN><STRONG>act_ru_execution</STRONG><SPAN> before it deletes the task variables from </SPAN><STRONG>act_ru_variables</STRONG><SPAN>.</SPAN><BR /><BR /><SPAN>Is this a bug? Or has anyone ideas how to solve this.</SPAN><BR /><SPAN>Can I remove the foreign key - or does it mess up other things?</SPAN><BR /><BR /><SPAN>Many thanks,</SPAN><BR /><SPAN>Risto</SPAN></BODY></HTML> Fri, 24 Aug 2012 08:35:28 GMT risto45 2012-08-24T08:35:28Z Unable to complete parallel task (foreign key violation) https://connect.hyland.com/t5/alfresco-archive/unable-to-complete-parallel-task-foreign-key-violation/m-p/99032#M68374 I have a problem that seems like a bug, but I'm not sure - maybe I'm doing something wrong.I have two parallel tasks. During the execution some variables are added to the tasks usingtaskService.setVariableLocal(taskId, variable, value). And now when I call taskService.complete(taskId) on one of the Fri, 24 Aug 2012 08:35:28 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-complete-parallel-task-foreign-key-violation/m-p/99032#M68374 risto45 2012-08-24T08:35:28Z Re: Unable to complete parallel task (foreign key violation) https://connect.hyland.com/t5/alfresco-archive/unable-to-complete-parallel-task-foreign-key-violation/m-p/99033#M68375 <HTML><HEAD></HEAD><BODY><SPAN>Hi risto45,</SPAN><BR /><BR /><SPAN>sounds like a bug. Could you maybe open an issue in JIRA and include a testcase?</SPAN></BODY></HTML> Fri, 24 Aug 2012 12:28:22 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-complete-parallel-task-foreign-key-violation/m-p/99033#M68375 meyerd 2012-08-24T12:28:22Z Re: Unable to complete parallel task (foreign key violation) https://connect.hyland.com/t5/alfresco-archive/unable-to-complete-parallel-task-foreign-key-violation/m-p/99034#M68376 <HTML><HEAD></HEAD><BODY><SPAN>Actually there is already an issue opened in JIRA with similar problem.</SPAN><BR /><SPAN>I simply updated it: </SPAN><A href="https://jira.codehaus.org/browse/ACT-1054" rel="nofollow noopener noreferrer">https://jira.codehaus.org/browse/ACT-1054</A><BR /><BR /><SPAN>Rgs,</SPAN><BR /><SPAN>Risto</SPAN></BODY></HTML> Fri, 24 Aug 2012 12:50:06 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-complete-parallel-task-foreign-key-violation/m-p/99034#M68376 risto45 2012-08-24T12:50:06Z Re: Unable to complete parallel task (foreign key violation) https://connect.hyland.com/t5/alfresco-archive/unable-to-complete-parallel-task-foreign-key-violation/m-p/99035#M68377 <HTML><HEAD></HEAD><BODY><SPAN>I described the FOREIGN KEY violation a little wrong earlier.</SPAN><BR /><BR /><SPAN>What really happens is:</SPAN><BR /><SPAN>When I have a parallel task that contains two separate tasks: T1 and T2.</SPAN><BR /><SPAN>When T1 an T2 are executed, T1 gets execution ID 01 and T2 gets execution ID 02.</SPAN><BR /><SPAN>Now, during the execution I set couple of local variables for both, T1 and T2.</SPAN><BR /><SPAN>And when I set for example that T2 is completed (taskService.complete(T2.getId()), Activiti for some reason tries to delete </SPAN><BR /><SPAN>both executions 01 and 02. Allthough I guess it should only delete execution 02.</SPAN><BR /><SPAN>And since there are still local variable for T1 in </SPAN><STRONG>act_ru_variable</STRONG><SPAN> table, then system throws error: FOREIGN KEY violation.</SPAN><BR /><SPAN>Can't delete execution that has a local variables in </SPAN><STRONG>act_ru_variable</STRONG><SPAN>.</SPAN><BR /><BR /><SPAN>When I have a parallel task and I want to set one of them completed, why it tries to delete both executions?</SPAN><BR /><SPAN>Seems like a very common requirement? Can there really be such a bug. Or maybe I'm just doing something wrong.</SPAN><BR /><BR /><SPAN>Rgs,</SPAN><BR /><SPAN>Risto</SPAN></BODY></HTML> Mon, 27 Aug 2012 09:25:50 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-complete-parallel-task-foreign-key-violation/m-p/99035#M68377 risto45 2012-08-27T09:25:50Z Re: Unable to complete parallel task (foreign key violation) https://connect.hyland.com/t5/alfresco-archive/unable-to-complete-parallel-task-foreign-key-violation/m-p/99036#M68378 <HTML><HEAD></HEAD><BODY><SPAN>Any news on this? Did anyone mange to find a work around? May be delete the foreign key var or something?</SPAN><BR /><SPAN>10x all</SPAN></BODY></HTML> Wed, 05 Sep 2012 09:41:07 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-complete-parallel-task-foreign-key-violation/m-p/99036#M68378 roig 2012-09-05T09:41:07Z