Abnormal Termination
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 90
- Joined: Mon Dec 08, 2003 4:48 am
- Location: Chennai
Abnormal Termination
Hi,
I get the following message
"Abnormal termination of stage IWD5B010ClmMedTransPart1..MTF_BROK_GRGR_Hfs.IDENT3 detected"
I get this kind of message quite often.Wat's this all about.I'm unable to figure it out.While browsing thru the form i found that it could be a disk space problem also.If so how to solve this.
I get the following message
"Abnormal termination of stage IWD5B010ClmMedTransPart1..MTF_BROK_GRGR_Hfs.IDENT3 detected"
I get this kind of message quite often.Wat's this all about.I'm unable to figure it out.While browsing thru the form i found that it could be a disk space problem also.If so how to solve this.
Think Ahead,
Raj.D
Raj.D
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Delete anything you don't need from the disk?
In particular, clean up the file system referred to by the UVTEMP configuration parameters, anything old in &PH&, any scratch space your routines use. Purging log files of old entries can help, too.
![Razz :P](./images/smilies/icon_razz.gif)
In particular, clean up the file system referred to by the UVTEMP configuration parameters, anything old in &PH&, any scratch space your routines use. Purging log files of old entries can help, too.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Another common cause for abnormal termination of stage is that the stage is handling NULL values where it isn't expecting to.
Beware that the Sequential File stage, unless you change the Format, will map "" to NULL when reading the text file. This can introduce NULLs that you weren't expecting.
Beware that the Sequential File stage, unless you change the Format, will map "" to NULL when reading the text file. This can introduce NULLs that you weren't expecting.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I just recently worked with DataStage support on an issue I was having much like this. What it turned out to be was a job level setting. IBM advised me at that in the Job Parameters option to look on the performance tab. Once there they had me un-check the 'use poject defaults' and select the 'enable row buffer' and then 'inter process'.
They basically said that the job was intermittently failing while trying to get enough system resources.
They basically said that the job was intermittently failing while trying to get enough system resources.
lkthoma
Abnormal Termination of Stage ..."IDENT3 detected"
I am currenly working on DataStage 5.1 and one of the job is aborting with the same message "Abnormal Termination of Stage ....."IDENT3 detected" while writing the data from SQL server table to a Hash file.
However, I am not able to find the "Job Parameters" option to look on the performance tab. Is that in Designer or Director and where exactly I can find this.
Please advise me.
Thanks,
However, I am not able to find the "Job Parameters" option to look on the performance tab. Is that in Designer or Director and where exactly I can find this.
Please advise me.
Thanks,
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA