topic Re: activity make duplicate entries in to act_ru_job table for circular execution of workflow in Alfresco Forum

activity make duplicate entries in to act_ru_job table for circular execution of workflow

nprajapatiasite — Tue, 05 Jun 2018 06:54:43 GMT

Hi,i have created one workflow cyclic flow.one user task is with boundary timer and timer is connected to service task and that service task output is as input to user task (i have uploaded image for this).issue is, when boundary timer execute than another job is created for same after service task

Re: activity make duplicate entries in to act_ru_job table for circular execution of workflow

bassam_al-saror — Wed, 06 Jun 2018 11:54:39 GMT

I guess thats normal. Every time the execution completes the service task it will create a new user task and a boundary job. You might need to add an exclusive gateway after the service task to decide whether to continue to user task or do something else.

Re: activity make duplicate entries in to act_ru_job table for circular execution of workflow

nprajapatiasite — Thu, 07 Jun 2018 04:41:13 GMT

Hi Bassam,

Thank you so much for your response ans i appreciate your answer.

one more thing that, is there any way to stop timer job to create new job in "act_ru_job" table?

Re: activity make duplicate entries in to act_ru_job table for circular execution of workflow

bassam_al-saror — Thu, 07 Jun 2018 12:17:33 GMT

As long as a new user task with a timer boundary is created it will continue to create new jobs and insert new rows in "act_ru_job" table.

How many times do you want this to run? From the "timercycledefinition" I guess you want it to run for 10 times. Why did you choose to return back to the user task after completing the service task? If you want to run it for only 10 times then add end event after the service task.

Re: activity make duplicate entries in to act_ru_job table for circular execution of workflow

nprajapatiasite — Fri, 08 Jun 2018 05:03:21 GMT

Thanks for your answer,

it is created by mistakes in QA Environment, so is there any way to stop such types of recursion if client create such types of workflow?

Re: activity make duplicate entries in to act_ru_job table for circular execution of workflow

bassam_al-saror — Fri, 08 Jun 2018 09:15:55 GMT

You can suspend the process instances RuntimeService (Activiti - Engine 5.22.0 API) and also suspend the whole process definition RepositoryService (Activiti - Engine 5.22.0 API)