List Info

Thread: Workflow HA recovery problem




Workflow HA recovery problem
country flaguser name
United States
2008-06-09 07:05:26

Hello,

There is a strange behaviour of workflow recovery when
"Enable HA Recovery" property is enabled in PowerCenter 8.5.

Enabling this option one should be able to recover a workflow
even if Integration service was restarted or workflow was
stopped/aborted.

However, recoverying such workflow does not start tasks that depend
on tasks already succeeded in previous run. For example Task_A and
Task_B run in parallel and both are linked to Task_C that should run
if Task_A and Task_B succeed. Task_A succeeds and Task_B is aborted.
When you recover the workflow then the Task_B is recovered and
succeeds but Task_C is not started even if both previous tasks
suceeded (but each in different run).

Does anybody come across this situation too? Is there any workaround?

Thank you
Kind regards
Martin

__._,_.___
.

__,_._,___
Re: Workflow HA recovery problem
country flaguser name
United States
2008-06-12 20:45:13


Do yourself a favor and don't embed the and or logic within Informatica. We only create
workflows that have one session associated with it. The logic is all contained within the
scheduler or the executed script that executes the workflow

--- In informaticadevelopment%40yahoogroups.com">informaticadevelopmentyahoogroups.com, mschiller11 <no_reply...> wrote:
&gt;
> Hello,
&gt;
> There is a strange behaviour of workflow recovery when
>; "Enable HA Recovery&quot; property is enabled in PowerCenter 8.5.
>;
> Enabling this option one should be able to recover a workflow
> even if Integration service was restarted or workflow was
> stopped/aborted.
&gt;
> However, recoverying such workflow does not start tasks that depend
> on tasks already succeeded in previous run. For example Task_A and
> Task_B run in parallel and both are linked to Task_C that should run
> if Task_A and Task_B succeed. Task_A succeeds and Task_B is aborted.
> When you recover the workflow then the Task_B is recovered and
> succeeds but Task_C is not started even if both previous tasks
> suceeded (but each in different run).
&gt;
> Does anybody come across this situation too? Is there any workaround?
>
> Thank you
> Kind regards
> Martin
&gt;

__._,_.___
.

__,_._,___
[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )