Phantom Aborting with @ABORT.CODE = 1
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
Phantom Aborting with @ABORT.CODE = 1
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
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
Do a "reset" of the job and see what the "from previous run..." entry in the log file states.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 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
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
You went into the BP.O subdirectory, not the BP one. The "O" stands for Object
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
Can you do a recompile and see if the source appears?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 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
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