Abnormal Termination of Stage Detected

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
pradkumar
Charter Member
Charter Member
Posts: 393
Joined: Wed Oct 18, 2006 1:09 pm

Abnormal Termination of Stage Detected

Post by pradkumar »

Hi

I got the following warning in one of my jobs run and my job got aborted.
"Abnormal termination of stage Load_Status..Xfm_Stg detected"

I had reset the job and found the following information from job log.
"From previous run
DataStage Job 324 Phantom 22349
jobnotify: Unknown error 911
DataStage Phantom Finished.
[22354] DSD.StageRun Load_Status. Load_Status.Xfm_Stg 371 0/50/1 - terminated. "

I searched the forum but did not see any similar scenario. Could you please help me out in understanding the error and what can be done to fix this
Pradeep Kumar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

My car won't go. What's wrong with it?

You have not provided enough information. What are the stage types in the job, and what are they trying to accomplish (and how)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pradkumar
Charter Member
Charter Member
Posts: 393
Joined: Wed Oct 18, 2006 1:09 pm

Post by pradkumar »

Its having just two transformers and STP stage.
Pradeep Kumar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Reset the job in Director - what do you see in the "from previous run" message in the job log?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pradkumar
Charter Member
Charter Member
Posts: 393
Joined: Wed Oct 18, 2006 1:09 pm

Post by pradkumar »

Hi Ray

This is what i got
"had reset the job and found the following information from job log.
"From previous run
DataStage Job 324 Phantom 22349
jobnotify: Unknown error 911
DataStage Phantom Finished.
[22354] DSD.StageRun Load_Status. Load_Status.Xfm_Stg 371 0/50/1 - terminated. "
"
Pradeep Kumar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Sorry, you did post that originally.

Unknown error 911. Unknown - unknowable? Maybe a Porsche was involved?

Seriously, though, these are the most difficult and recalcitrant problems to diagnose. Is it reproducible? If so, please describe in detail what each of the stages is doing.
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