09-02-2024 06:03 AM
I need help with my Activity workflow in Alfresco CE 7.4. I have approving user task with set multi instance. Task is very simple - users chooses from approve or reject. What I need is if one user choose reject, whole task and workflow ends. I tried to use completion condition to end user task and it works. But only for setting sequential=true (next user task via multi instance is not created). If i set sequential=false (so all users tasks are created at start of task) it don't work.
I get PSQL error that gets ACS into infinite loop.
org.postgresql.util.PSQLException: ERROR: update or delete on table "act_ru_execution" violates foreign key constraint "act_fk_exe_parent" on table "act_ru_execution" Detail: Key (id_)=(4575) is still referenced from table "act_ru_execution".
I found that problem is in terminate other users tasks, but for me is strange this ACS cant handle this. I work with alfresco for few years and never get PSQLException from application logic. I tried similar workaround throw signals and setting cancel activity = true and get same error. I even tried to do it via java lisiners and workflowService.endTask() and still getting same error.
Is this bug or im doing something wrong? How to handle my case?
Explore our Alfresco products with the links below. Use labels to filter content by product module.