Page 1 of 1
Abnormal termination of DataStage
Posted: Wed Jul 29, 2009 3:07 am
by karry450
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
Re: Abnormal termination of DataStage
Posted: Wed Jul 29, 2009 4:28 am
by ArndW
karry450 wrote:... DSP.Open at address 574...
What kind of stages are you opening?
Re: Abnormal termination of DataStage
Posted: Wed Jul 29, 2009 4:51 am
by karry450
ArndW wrote:karry450 wrote:... DSP.Open at address 574...
What kind of stages are you opening? ...
An Aggregrator stage and then a transformer stage and loading into ORACLE from ORACLE
Posted: Wed Jul 29, 2009 4:58 am
by ArndW
Does "View Data" function on both Oracle stages?
Posted: Wed Jul 29, 2009 4:46 pm
by ray.wurlod
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.
Posted: Sat Sep 05, 2009 10:48 am
by jacksamsula
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.
Posted: Tue Nov 17, 2009 5:29 am
by chanaka
Hi Guys,
My self also encountered the same error. In that case I was able to get over it by changing the NLS map to None on the immediate target stage after the last transformer.
Cheers!