how to restart a workflow in case of failure

[Aggregator]

I would like to restart a workflow in case of an failure in any task under that workflow.(i means if any task under that WF fails)
Please let me know if there is any way to do this in the same workflow...Informatica server is on Window.

 

[ArtieChoke]

Not automatically. You can user recover mode, but it's still a manual process. You will have to use the wf monitor to restart.

We wrote a program using the SDK to run the wf and restart it at any failed task so it was hands off.


"I think we're all Bozos on this bus!" - Firesign Theatre

 

[blom0344]

Should be doable by using event control. (version 7 and higher). You basically use logic between each component to validate if a session has succeeded. If so then proceed to the next step (session). If not then stop the current workflow run and restart.

The nitty-gritty is that you can only restart a workflow once it is aborted/stopped/ended. So you still need to kick in some logic outside the workflow for it to work.

The obvious other solution is to define the whole workflow as a worklet and create a higher-level workflow with 2 identical worklets and event control.
(in case you want to restart any failed run only once)

Ties Blom

 

[Aggregator]

Thanks for the suggestions
As you understood it correctly, the main issue over here is to trigger a workflow using a task within the same workflow. Because in order to retrigger a workflow, that workflow need to get completed but if this happens then there won't be any task in that workflow to retrigger it.
Using two worklets and event task is a good option, but i have many workflows like this and there is a possibility to run it more than once.
Any other suggestion...

 

[Aggregator]

thanks ArtieChock...could you please share that SDK code..if possible...

 

[blom0344]

You need to license the SDK (AFAIK) and then we are talking serious money..

Ties Blom

 

[ArtieChoke]

The SDK is free to download. My program is written in VB 6.0. Do you use that language?

Another way to do it would be to use the pmcmd program in a batch file to run the wf and capture the output. Then check to make sure it completed and if not, I think you can inquire what task it failed on and restart at that task.

"I think we're all Bozos on this bus!" - Firesign Theatre