Job aborted in sequence but did not trigger Exception

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
RodBarnes
Charter Member
Charter Member
Posts: 182
Joined: Fri Mar 18, 2005 2:10 pm

Job aborted in sequence but did not trigger Exception

Post by RodBarnes »

I have a sequence that has the "Automatically handle activities that fail" option set and includes an Exception stage to catch them. It has a couple job stages 'A' and 'B' with OK triggers feeding a sequencer (set to "All") and the sequencer feeds another job stage 'C' that ends the sequence.

This morning, job 'B' succeeded but job 'A' failed due to a connection error. Though 'A' failed, it did not fire the Exception stage. Just after logging the failure of 'A', the next entry in the log for the sequence is the "Sequencer ... was entered but never exited".

Is the fact that it was sitting in the sequencer, waiting for job 'A' to finish, the reason it didn't fire off the Exception stage? I would've expected the error from 'A' to fire the exception regardless of any other activity in the sequence.
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post by balajisr »

Try placing a execute command activity with a simple command like

Code: Select all

echo 'job aborted'
to verify whether the exception handler is called or not.[/quote]
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Each Sequence stage has a 'Logging Text' property. Use that to leave clues about which stages are actually getting executed.
-craig

"You can never have too many knives" -- Logan Nine Fingers
RodBarnes
Charter Member
Charter Member
Posts: 182
Joined: Fri Mar 18, 2005 2:10 pm

Post by RodBarnes »

When an exception stage is triggered, it is reported in the log as:

Code: Select all

"<controlling_stage>.JobControl (@<error_stage>): Will execute error activity: <exception_stage>"
For example:

Code: Select all

"seqUpdatePatches.JobControl (@ImportPatch): Will execute error activity: Exception"
On a typical run, if there is an error, I see this entry and can confirm that the exception was fired. In this instance, no log entry was present to confirm it happened.
RodBarnes
Charter Member
Charter Member
Posts: 182
Joined: Fri Mar 18, 2005 2:10 pm

Post by RodBarnes »

I have the "Log warnings after activities that finish with status other than OK" enabled on all my jobs for this purpose. I do use the "Logging text" ability in particular cases.
chulett wrote:Each Sequence stage has a 'Logging Text' property. Use that to leave clues about which stages are actually getting executed.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Does Job A have a specific Failure trigger? This would be used in preference to the Exception Handler in the event of an abort of job A.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
RodBarnes
Charter Member
Charter Member
Posts: 182
Joined: Fri Mar 18, 2005 2:10 pm

Post by RodBarnes »

No, all jobs in this sequence have only OK triggers. The exception stage is intended to catch everything else. From your responses, I gather that you agree the exception stage should have been triggered?
ray.wurlod wrote:Does Job A have a specific Failure trigger? This would be used in preference to the Exception Handler in the event of an abort of job A.
Post Reply