How can I limit the number of retries of a FAILED Component in a Process Flow?

Document ID : KB000090180
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
How can I limit the number of retries of a FAILED Component in a Process Flow?
Resolution:

Question / Requirements

We want a Component of a Process Flow to restart itself a certain amount of times if it fails.  How can we accomplish this?


Solution

Create a Number subvar, #count_runs, with the following SQL:

     select nvl(substr('{jobid}',length(cast ({jobid} as int))+2),0) from dual

Ensure that the Component is not set to 'Restart on Abort' at the job level.  Then you will add one conditional to the Component in the Process Flow similar to this:

     1     AFTER     Continuous     {#count_runs}  LT  5     Restart on Abort

When you run the Process Flow if the Component Fails it is restarted 5 times and then it will stop.