Sequencer logic

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

Sequencer logic

Post by dnat »

Hi,

I have to run a sequencer for a set of files in a loop. So, i have the sequencer like this:-

Main sequencer:-
Start loop-->Job activity 1-->Job activity 2-->End loop

This sequencer loops for every file until all the files are processed.

Job activity 1 is a Job sequence which processes the data. Hence if this aborts while processing the file, it should trigger the Job Activity(which updates the table about the job status) and end loop until all the files are processed.

In Job activity 1, i have given the trigger as unconditional.

But, the problem is, if Job activity 1 aborts while processing the file, the whole sequencer aborts. Hence all the other files would not be processed until this error is rectified.My requirement is that the Job activity 2 should run after Job activity 1 even if it is aborted.

Can anyone help me in resolving this issue.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Sequencer logic is easy. The output fires if "Any" of its inputs fires, or if "All" of its inputs fire.

What you have there is a job sequence, not a sequencer.

Your problem is that the job sequence is doing exactly what you have asked it to do, by checking "automatically handle failure" and not including explicit failure handling for Job Activity 1 or an Exception Handler.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Re: Sequencer logic

Post by JoshGeorge »

And what all are the error handling options you have set / checked in your job parameter tab?
dnat wrote: In Job activity 1, i have given the trigger as unconditional.

But, the problem is, if Job activity 1 aborts while processing the file, the whole sequencer aborts.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

Post by dnat »

I have unchecked the option "Automatically handle activities that fail" and now the job is running even if the job activity fails and goes into the next loop.
Post Reply