topic Re: Unable to complete parallel task (foreign key violation) in Alfresco Archive

Unable to complete parallel task (foreign key violation)

risto45 — Fri, 24 Aug 2012 08:35:28 GMT

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

Re: Unable to complete parallel task (foreign key violation)

meyerd — Fri, 24 Aug 2012 12:28:22 GMT

Hi risto45,

sounds like a bug. Could you maybe open an issue in JIRA and include a testcase?

Re: Unable to complete parallel task (foreign key violation)

risto45 — Fri, 24 Aug 2012 12:50:06 GMT

Actually there is already an issue opened in JIRA with similar problem.
I simply updated it: https://jira.codehaus.org/browse/ACT-1054

Rgs,
Risto

Re: Unable to complete parallel task (foreign key violation)

risto45 — Mon, 27 Aug 2012 09:25:50 GMT

I described the FOREIGN KEY violation a little wrong earlier.

What really happens is:
When I have a parallel task that contains two separate tasks: T1 and T2.
When T1 an T2 are executed, T1 gets execution ID 01 and T2 gets execution ID 02.
Now, during the execution I set couple of local variables for both, T1 and T2.
And when I set for example that T2 is completed (taskService.complete(T2.getId()), Activiti for some reason tries to delete
both executions 01 and 02. Allthough I guess it should only delete execution 02.
And since there are still local variable for T1 in act_ru_variable table, then system throws error: FOREIGN KEY violation.
Can't delete execution that has a local variables in act_ru_variable.

When I have a parallel task and I want to set one of them completed, why it tries to delete both executions?
Seems like a very common requirement? Can there really be such a bug. Or maybe I'm just doing something wrong.

Rgs,
Risto

Re: Unable to complete parallel task (foreign key violation)

roig — Wed, 05 Sep 2012 09:41:07 GMT

Any news on this? Did anyone mange to find a work around? May be delete the foreign key var or something?
10x all