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.
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?