sequencer error

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
Tej
Participant
Posts: 30
Joined: Tue May 20, 2008 11:44 pm
Location: hyderabad

sequencer error

Post by Tej »

Hi All,

below error is displayed
please do the need ful

SEQUENCER NAME..JobControl (fatal error from UtilityAbortToLog): USER INFO: Job Aborted. Please refer log for details JOB=> SEQUENCER NAME STAGE=> JobControl LINK=> -8

please help...
Thanks in adavance.....
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What caused your job sequence (note, it's not "sequencer") to execute a routine activity that invoked UtilityAbortToLog?

Only you can determine this, as none of us can see your job sequence design.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Tej
Participant
Posts: 30
Joined: Tue May 20, 2008 11:44 pm
Location: hyderabad

Post by Tej »

ray.wurlod wrote:What caused your job sequence (note, it's not "sequencer") to execute a routine activity that invoked UtilityAbortToLog?

Only you can determine this, as none of us can see your job sequence design. ...
thanks ray,
can u please give me the clear discripition
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I don't know. You will have to wait until next time U logs in. And even then, U may not be able to give a clear description.

The problem is in how your job sequence is executing. You must determine what caused the Routine activity that invokes UtilityAbortToLog() to be executed - presumably a trigger upstream of the activity.

There is no clearer explanation that we can give, because we can not see your job sequence design.

Premium membership is not expensive, at less than 30c (Rs12) per day.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Tej
Participant
Posts: 30
Joined: Tue May 20, 2008 11:44 pm
Location: hyderabad

Post by Tej »

the sequencer is failed due to the above error and it can describe as
in the sequencer abort acitvity and job acitivty and routine acitvity
in the job activity it trigger as job that generates sequncer number and the job is amultiple instance.
belowis the some more discription
Exception Handler is triggered whenever a job fails. The Update Sakey job is called so the max sakey is updated just in case the load job aborts. The Routine Activity calls UtilityAbortToLog to abort the sequencer.
singhald
Participant
Posts: 180
Joined: Tue Aug 23, 2005 2:50 am
Location: Bangalore
Contact:

Post by singhald »

Hello Tej,

can you please write down a flow diagram of your sequecer activities in sequece,

Based on your previous post,

you are aborting your sequecer incase of failure of your job activity.

what actully you want if your ur job abort.

Regards,
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The Exception Handler has its own activity variables which you could include in the logged message. But you should be able to identify the culprit - that it, the activity that failed and thereby caused the Exception Handler to be triggered - from the job sequence's job log.

Exception Handler activity variables are:
  • $ErrSource - name (label) of the activity that raised the exception

    $ErrNumber - indicates whether the activity actually ran (1 = activity ran, aborted and had no specific handler set up, -1 = job failed to run for some reason)

    $ErrMessage = text of message that would be logged as a warning when the exception is raised
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply