AnsweredAssumed Answered

Process steps being run multiple times concurrently

Question asked by fabricio.de.marchi on Jul 7, 2010
Latest reply on Jul 8, 2010 by fabricio.de.marchi
Hi All,

I have a process configured in production that have the following Flow:

Start-->Step1-->Step2-->Step3-->Step4-->Finish

Step1 has an action that runs a JOB. The JOB runs a procedure. That procedure creates a line inside a custom log table saying "Step1 - Running".

Step 2 has an action that runs a JOB. The JOB runs a Java code.

Step3 has an action that runs a JOB. The JOB Runs a procedure. That procedure creates a line inside a custom log table saying "Step3 - Running".

Step3 has an action that runs a custom script. The custom script runs a procedure. That procedure creates a line inside a custom log table saying "Step4 - Running".

All actions are configured with:
Mark step complete when job finishes (synchronous)
OR
Mark step action complete when script finishes (synchronous)

After a few months with that process running in production, checking the custom log table, there are some entries that indicates there were multiple runs of some steps and also concurrent runs of some steps.

Observe the rows we found in the custom log table:
START_DATE_TIME | STEP
6/13/2010 6:06:03 PM | Step4 - Running
6/13/2010 6:05:21 PM | Step4 - Running
6/13/2010 6:05:18 PM | Step4 - Running
6/13/2010 6:05:17 PM | Step3 - Running
6/13/2010 6:05:16 PM | Step3 - Running
6/13/2010 6:05:15 PM | Step3 - Running
6/13/2010 6:00:06 PM | Step1 - Running

It seems clear that the steps "Step3" and "Step4" were ran 3 times each and concurrently.

This is causing issues since "Step4" does a SUM in a specific table and that procedure is generating wrong numbers for our systems.

Has anyone faced something like this before? Any suggestions of how to get more information/troubleshoot this?

Thanks,

Fabricio

Outcomes