topic Re: Cancel boundary event leads to violates foreign key constraint 'act_fk_task_exe' on table 'act_ru_task' for async user tasks in Alfresco Archive

Cancel boundary event leads to violates foreign key constraint 'act_fk_task_exe' on table 'act_ru_task' for async user tasks

michael_wray — Wed, 09 Mar 2016 09:57:17 GMT

We're using 5.19 and we noticed that when we have a cancel boundary event on an embedded subprocess that includes user tasks which have activiti:async="true", when the boundary event fires, we get the following exception in the log:2016-03-09 09:31:14.011 ERROR 6188 — [SimpleAsyncTaskExecutor-14] o.

Re: Cancel boundary event leads to violates foreign key constraint 'act_fk_task_exe' on table 'act_ru_task' for async user tasks

martin_grofcik — Wed, 09 Mar 2016 12:39:06 GMT

Hi,

Could you create jUnit test please?
https://forums.activiti.org/content/sticky-how-write-unit-test

Regards
Martin

Re: Cancel boundary event leads to violates foreign key constraint 'act_fk_task_exe' on table 'act_ru_task' for async user tasks

jim1 — Tue, 15 Mar 2016 15:33:39 GMT

Hi,
I work with Mike and have created a unit test to recreate the issue: https://goo.gl/AO5E7W

The test fails as the timer doesn't complete in the allowed time due to the error we are seeing, you can see the exception mentioned above in the logs.

Thanks,
Jim.

Re: Cancel boundary event leads to violates foreign key constraint 'act_fk_task_exe' on table 'act_ru_task' for async user tasks

jbarrez — Fri, 18 Mar 2016 15:30:57 GMT

Tested this on the latest version (5.19.0.2) and there it works. It indeed fails on 5.19.0, so I'd advise to upgrade 🙂

it also works on v6 (of course 😉 )

Re: Cancel boundary event leads to violates foreign key constraint 'act_fk_task_exe' on table 'act_ru_task' for async user tasks

jim1 — Tue, 22 Mar 2016 13:32:32 GMT

Ah, excellent. Thanks for the quick response, we'll look into upgrading.