Hi Friends
Im trying to run a job which is migrated from 7.5.2 to 8.1 but I face some issues
Abnormal termination of stage detected
and when I reset the job I see the below error.
DataStage Job 127 Phantom 13857
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program DSP.Open at address 574.
Can anyone help me on this please
Abnormal termination of DataStage
Moderators: chulett, rschirm, roy
Re: Abnormal termination of DataStage
What kind of stages are you opening?karry450 wrote:... DSP.Open at address 574...
</a>Re: Abnormal termination of DataStage
ArndW wrote:What kind of stages are you opening? ...karry450 wrote:... DSP.Open at address 574...
An Aggregrator stage and then a transformer stage and loading into ORACLE from ORACLE
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try re-entering the reference to the encrypted (password) parameter in the Oracle stage. I've found - admittedly in version 8.0.1 - that this (the reference to an encrypted parameter) is sometimes not migrated properly.
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.
-
jacksamsula
- Premium Member
- Posts: 29
- Joined: Tue Oct 21, 2008 9:26 am
- Location: Samsula, FL
- Contact:
We have found a crazy solution to the abnormal termination of stage message when nothing else works. In the transformer change all of the DATE formats to VARCHAR2 on the Oracle target side. Then change the SQL to USER DEFINED SQL and use the to_date function to convert the varchar to date format. For us this works on version 7.5.1 running on Windows 2003 server. No idea why.