Abnormal Termination of Stage

U · Post by U » Fri Mar 20, 2009 12:42 am

One of our jobs threw "Abnormal termination of stage transformer_name detected" error in production. The job works in dev/test environments but threw only this error in production - there was no extra information logged and no other errors/warnings logged. Job design is OCI --> Transformer --> SeqFile and it is a direct pass through the Transformer - no transformations. View Data on the OCI stage works successfully.

We have checked everything we can think of on the two machines. There are minor differences in versions only of glibc and some IBM DB2 patches, but these should not affect server jobs.

Because it's a production environment (and for a bank at that) we are really limited in our scope for experimentation. We would really appreciate any suggestions about what things to look for.

It may be an issue that the job was run from a Batch, but we checked the Batch and the job's logs, and all the parameter values were passed correctly (obviously we couldn't check the encrypted Oracle password, but there was no error from the OCI stage so we think that that's OK).

jeyarajnjd · Post by **jeyarajnjd** » Fri Mar 20, 2009 3:46 am

Just check your database driver version installed in the datastage server against the database. This might be one of the reasons for abnormal termination. Probably you need to upgrade the driver.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Mar 20, 2009 4:04 am

I doubt whether it is due to connectivity.

Can you try routing the data traffic through your dev or test database? There could be some special chars or derivation having issues.

chulett · Post by **chulett** » Fri Mar 20, 2009 9:18 am

Couldn't tell from your post, but did you Reset the aborted job? Sometimes that logs a 'From previous run...' message with more diagnostic information in it.

U · Post by U » Sat Mar 21, 2009 1:20 am

My apology for not mentioning this. Yes we did reset the job; the only message from previous run was the one-line [Done] message from the phantom process DSD.StageRun, which I understand is the Transformer stage's process.

Keshav007 · Post by **Keshav007** » Thu Jun 09, 2011 9:52 am

some times it happens if IDOCS to be processed are more than the limit

ray.wurlod · Post by **ray.wurlod** » Thu Jun 09, 2011 4:34 pm

Interesting addition to a thread that's more than two years old. Which of the stages in U's design do you believe would handle IDOCs?

esivaprasad · Post by **esivaprasad** » Tue Jun 14, 2011 10:03 am

ray.wurlod wrote:Interesting addition to a thread that's more than two years old. Which of the stages in U's design do you believe would handle IDOCs? ...

hi ,
this similar type of problem i also faced last month.
only you need to do is clear your phantom file from adminstrator.
1.log on to adminstrator , select your project and click command option, then
"CLEAR.FILE &PH&" and execute this commasnd.
2.do the shmtest in datastage enginee bin folder like
"./shmtest". according to the test result update your uvconfig file.
3.must restart your datastage server.
hope this may resolve your problem.

chulett · Post by **chulett** » Tue Jun 14, 2011 10:33 am

OK peoples... I'm two steps away from locking this thread. We do not need to keep piling in here with every possible reason for the rather generic "abnormal ternination of stage" error one gets with Server jobs.