Abnormal Termination

raj_cipher · Post by **raj_cipher** » Thu May 20, 2004 2:27 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu May 20, 2004 4:40 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu May 20, 2004 4:40 pm

If you reset the job after it's aborted, you sometimes get an event logged "from previous run...". This can contain additional diagnostic information.

ray.wurlod · Post by **ray.wurlod** » Thu May 20, 2004 4:42 pm

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.

Latha1919 · Post by **Latha1919** » Fri Sep 15, 2006 10:33 am

Would you please elaborate the following:

"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 ... "

Thanks,

ray.wurlod · Post by **ray.wurlod** » Fri Sep 15, 2006 5:46 pm

Tell me which parts of it aren't clear.

lkthoma · Post by **lkthoma** » Thu Sep 28, 2006 7:55 am

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.

kumar_s · Post by **kumar_s** » Thu Sep 28, 2006 8:38 am

This will be one of the reason for this error. if diognised well, and found out noting else could be the reason, you can increase this factor.

Latha1919 · Post by **Latha1919** » Wed Feb 28, 2007 11:09 am

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,

us1aslam1us · Post by **us1aslam1us** » Wed Feb 28, 2007 11:52 am

In Designer>>Job Properties>>Performance Tab

Latha1919 · Post by **Latha1919** » Wed Feb 28, 2007 12:05 pm

In the job properties, I could see only 4 tabes namely: General, Parameter, Job Control, Dependencies. No performance tab here. Is that DataStage 5.1 V?

us1aslam1us · Post by **us1aslam1us** » Wed Feb 28, 2007 12:10 pm

Latha1919 wrote:Is that DataStage 5.1 V?

Sorry i missed that part. Never worked with that, maybe someone else can help you with that.

DSXchange

Abnormal Termination

Abnormal Termination

Abnormal Termination of Stage ..."IDENT3 detected"