nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Unable to complete parallel task (foreign key violation)

risto45

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 using
taskService.setVariableLocal(taskId, variable, value). And now when I call taskService.complete(taskId)
on one of the tasks, I get the following error:

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".
‍‍‍

Table act_ru_variable has a FOREIGN_KEY that references to act_ru_execution (id_).
And it seems that when I set the task to be complete(), then Activity tries to delete the execution from act_ru_execution before it deletes the task variables from act_ru_variables.

Is this a bug? Or has anyone ideas how to solve this.
Can I remove the foreign key - or does it mess up other things?

Many thanks,
Risto

Find more posts tagged with

Comments

meyerd

Hi risto45,

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

risto45

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

risto45

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

roig

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