Abnormal Termination of Stage
Moderators: chulett, rschirm, roy
Abnormal Termination of Stage
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).
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).
-
- Participant
- Posts: 2
- Joined: Mon Jul 21, 2008 8:51 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 135
- Joined: Tue Dec 09, 2008 10:35 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.
Siva