Phantom Aborting with @ABORT.CODE = 1

JPalatianos · Post by **JPalatianos** » Thu Jul 30, 2009 9:31 am

Hi,
We have a sequence job that call a MS Sql Server Proc that creates Cognos reports for us. When the sequence runs and only one execution of the job is hit we are fine. When we have 2 or more reports queued up we get the following error for the 2nd execution of the job.

Thanks - - John

Project:FORM5500 (PAERSCBBLA0293)
Job name:ProduceSchC
Event #:26
Timestamp:7/30/2009 11:06:50 AM
Event type:Warning
User:PRUDENTIAL\X090842
Message:
DataStage Job 99 Phantom 9920
Aborting after 1 Rows written to ProduceSchC.xfmCognosCall.outCognosError
Program "JOB.9809447.DT.1502744529.TRANS1": Line 95, Abort.
Attempting to Cleanup after ABORT raised in stage ProduceSchC..xfmCognosCall
DataStage Phantom Aborting with @ABORT.CODE = 1

ArndW · Post by **ArndW** » Thu Jul 30, 2009 9:42 am

Do a "reset" of the job and see what the "from previous run..." entry in the log file states.

JPalatianos · Post by **JPalatianos** » Thu Jul 30, 2009 9:47 am

I did a reset of the job and do not see any "from previous" entries in the log.

ArndW · Post by **ArndW** » Thu Jul 30, 2009 9:50 am

The message you posted looks like it came from a sequence, you should reset the actual job that aborted to get the abort cause in the "from previous run..." entry.

JPalatianos · Post by **JPalatianos** » Thu Jul 30, 2009 9:54 am

It is a job which has schedule in it's name beacuse it is creating Schedule C reports and makes it look like a sequence but it is a server job.

chulett · Post by **chulett** » Thu Jul 30, 2009 9:55 am

Job design?

ArndW · Post by **ArndW** » Thu Jul 30, 2009 9:59 am

What does TRANS1 do? You could look at the source file around line 95, located in your project directory under RT_BP99/JOB.9809447.DT.1502744529.TRANS1

JPalatianos · Post by **JPalatianos** » Thu Jul 30, 2009 10:22 am

The job design is simple and ODBC1 stage to a transformer to two ODBC STAGES(2 and 3). The first ODBC stage calls the sql server proc and the 2 post transformer only have update statement in them.

I tried looking at the file (DT.1502744529.TRANS1 ) but it is mostly hex code(unreadable)

ArndW · Post by **ArndW** » Thu Jul 30, 2009 10:25 am

You went into the BP.O subdirectory, not the BP one. The "O" stands for Object

JPalatianos · Post by **JPalatianos** » Thu Jul 30, 2009 10:30 am

I figured as much but when I went into the RT_BP99 folder I only see the file .uvnlsmap

ArndW · Post by **ArndW** » Thu Jul 30, 2009 10:55 am

Can you do a recompile and see if the source appears?

JPalatianos · Post by **JPalatianos** » Thu Jul 30, 2009 11:16 am

That did the trick.....I guess I need to have the developer look at this sinc I have no idea what it means.
Starting at line 95:

IF STAGECOM.NUM.ROWS(3) GE 1 THEN ABORT 'Aborting after ':STAGECOM.NUM.ROWS(3):' Rows written to ProduceSchC.xfmCognosCall.outCognosError'
IF NOT(Pin%%V0S2P7.REJECTEDCODE) THEN
REJECTED = @FALSE
END ELSE
Pin%%V0S2P7.REJECTED = @TRUE
END
END

chulett · Post by **chulett** » Thu Jul 30, 2009 1:33 pm

It looks like you've got a reject link coded to abort the job after 1 row is sent down it.