Datastage job failed

muralidwhds · Post by **muralidwhds** » Tue Sep 14, 2010 4:19 am

Hi,

Here one of my Datastage job getting the AS400 Data and referincing with sybase data then lods into files.

Here this hob has failed in production but uisng same data and job has passed in development environmennt.

Coould you suugest on thsi why this job failed in production?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Sep 14, 2010 5:34 am

Post the full unedited error you receive in your production environment.

muralidwhds · Post by **muralidwhds** » Tue Sep 14, 2010 8:26 am

Sainath.Srinivasan wrote:Post the full unedited error you receive in your production environment.

I am getting the below warning message:

Abnormal termination of stage JobName.U2.CodaDateFile.IDENT1 detected

kumar_s · Post by **kumar_s** » Tue Sep 14, 2010 8:55 am

What is you job design.
Reset your job. And lookup for "from previous run..." in your log and post the same.

muralidwhds · Post by **muralidwhds** » Tue Sep 14, 2010 9:07 am

kumar_s wrote:What is you job design.
Reset your job. And lookup for "from previous run..." in your log and post the same. ...

Please find the below error:

Message:: From previous run
DataStage Job 114 Phantom 21158
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program DSP.Open at address 574

My Job Design:

Sybase Stage(Source) ----Lkp(DB2 stage)--Transformer---files(output)

kumar_s · Post by **kumar_s** » Tue Sep 14, 2010 9:11 am

You never described your job desing.
Search for "Fault type is 11" you ll get similar issues been resolved.

muralidwhds · Post by **muralidwhds** » Tue Sep 14, 2010 9:14 am

kumar_s wrote:You never described your job desing.
Search for "Fault type is 11" you ll get similar issues been resolved. ...

Give me sample example please

kumar_s · Post by **kumar_s** » Tue Sep 14, 2010 9:16 am

Did you try searching??

Try this.

viewtopic.php?t=128292&postdays=0&posto ... 11&start=0

Just a random pick.

arunkumarmm · Post by **arunkumarmm** » Wed Sep 15, 2010 10:29 am

muralidwhds wrote:
Sainath.Srinivasan wrote:Post the full unedited error you receive in your production environment.
I am getting the below warning message:

Abnormal termination of stage JobName.U2.CodaDateFile.IDENT1 detected

Are you using any stage variable or constrain or expression in your transformer which has a IF..THEN..ELSE? If so can you post that?