Abnormal termination of stage

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
Rajendran
Participant
Posts: 16
Joined: Wed Jul 28, 2004 7:56 am
Location: Dubai

Abnormal termination of stage

Post by Rajendran »

Hi!!

I am transfering the data from source to stage.
The above stages are resided in Oracle 9i database. When i am using direct mapping oracle(Source) -> Transfoemer -> Oracle(Stage) getting the below error.

Abnormal termination of stage JSTG01B2C602.. detected.

Source volume of data 158000.

Kindly let me know how to solve this problem??.


By,
RAJa
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Not enough information.

What happens when, after the job aborts, you reset it? Note, this is not recompile, it is the 'Reset' option available in the Director, the two backwards facing arrows like 'rewind' on a VCR. Let us know if, when you do so, any entries labelled 'From previous run...' appear in the log and what their contents are.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rajendran
Participant
Posts: 16
Joined: Wed Jul 28, 2004 7:56 am
Location: Dubai

Abnormal termination of stage

Post by Rajendran »

Hi,

I am transferring 150000 thousand rows from source to stage, using direct map (Both Oracle DataBase on HP-UNIX).
Data was transferred, but job was aborted.


When check with Director getting the below error.

Abnormal termination of stage JSTG05TRNEBL1…. Detected

Let me know why this error occurs!! How can we rectify???

Regards,
RAJa
rasi
Participant
Posts: 464
Joined: Fri Oct 25, 2002 1:33 am
Location: Australia, Sydney

Post by rasi »

Open your director for the aborted job. Use the reset button in the menu. This will give bring more logs to your director. Read those information and post it. We can help you.

Thanks
Rasi
Post Reply