Exception Handler and warnings

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
danddmrs
Premium Member
Premium Member
Posts: 86
Joined: Fri Apr 20, 2007 12:55 pm

Exception Handler and warnings

Post by danddmrs »

A parent sequence executes 3 child sequences with triggers of 'Okay' between them. Sequence 1 finished Okay and triggered Seq2. Seq2 finished with warnings - did not trigger Seq3, did not trigger the Exception Handler stage and the Parent sequence finished with a Status of 'Finished'.

In the parent Job Properties selected options are:
> Add checkpoints so sequence is restartable on failure
> Automatically handle activities that fail
> Log report messages after each job run

What is required is for child sequences to execute as each predecessor finishes with Okay. Since only the Okay trigger is handled explicitly shouldn't the EH stage get invoked for Failed or Warning?

Here are the last 3 log entries for the parent sequence:
10:54:02: Audit (JOB Audit) finished, status=1 [Finished OK]
11:57:39: SQ_LIVES_PREMIUM_DIM_LOAD (JOB SQ_LIVES_PREMIUM_DIM_LOAD) finished, status=2 [Finished with warnings]
11:57:40: Sequence finished OK
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Exception handler is only invoked for Failure.

It is not invoked for Warnings.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You can join a Warning trigger into the exception handling activities through a Sequencer.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
danddmrs
Premium Member
Premium Member
Posts: 86
Joined: Fri Apr 20, 2007 12:55 pm

Post by danddmrs »

Thank you. Will add triggers for Warnings and handle appropriately.
Post Reply