Hi Guys,
While i am running my job suddenly today we got this message and job aborts after writing some records,can you guys please help me out.
DataStage Job 696 Phantom 3924
Program "JOB.1904744032.DT.1394070058.TRANS1": Line 42, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage Day1Manager_temp1..Transformer_17
DataStage Phantom Aborting with @ABORT.CODE = 3
I cleared RT_LOG696 file and when i looked at RT_BP696 i have this code
* Tokens were replaced below as follows:
* Pin%%V0S17P1.Column%%1 <= DSLink18.EMPLID
* Pin%%V0S17P1.Column%%2 <= DSLink18.REHIRE_DT
* Pin%%V0S17P1.Column%%3 <= DSLink18.TERMINATION_DT
* GET.Pin%%V0S17P1 <= GET.DSLink18
* Pin%%V0S17P1.REJECTEDCODE <= DSLink18.REJECTEDCODE
* Pin%%V0S17P2.Column%%1 <= DSLink19.EMPLID
* Pin%%V0S17P2.Column%%2 <= DSLink19.REHIRE_DT
* Pin%%V0S17P2.Column%%3 <= DSLink19.TERMINATION_DT
* PUT.Pin%%V0S17P2 <= PUT.DSLink19
* Pin%%V0S17P2.REJECTED <= DSLink19.REJECTED
* Pin%%V0S17P2.REJECTEDCODE <= DSLink19.REJECTEDCODE
*
* Subroutine for active stage Day1Manager_temp1.Transformer_17 generated at 19:41:45 01 MAR 2006
*
SUBROUTINE DSTransformerStage(HANDLES,ERROR)
$INCLUDE DSINCLUDE DSD_RTCONFIG.H
$INCLUDE DSINCLUDE DSD_STAGE.H
$INCLUDE DSINCLUDE DSD_BCI.H
$INCLUDE DSINCLUDE JOBCONTROL.H
DEFFUN DSRLoadString(Num,Text,Args) CALLING '*DataStage*DSR_LOADSTRING'
$DEFINE Pin%%V0S17P1.Column%%1 STAGECOM.ARR(1)
$DEFINE Pin%%V0S17P1.Column%%2 STAGECOM.ARR(2)
$DEFINE Pin%%V0S17P1.Column%%3 STAGECOM.ARR(3)
$DEFINE GET.Pin%%V0S17P1 CALL $DSP.GetNext(1,Pin%%V0S17P1.REJECTEDCODE)
IF STAGECOM.TRACE.STATS THEN CALL $PERF.NAME(-2,'DSLink19.Derivation')
$DEFINE Pin%%V0S17P2.Column%%1 STAGECOM.ARR(1)
$DEFINE Pin%%V0S17P2.Column%%2 STAGECOM.ARR(2)
$DEFINE Pin%%V0S17P2.Column%%3 STAGECOM.ARR(3)
$DEFINE PUT.Pin%%V0S17P2 CALL $DS.SEQPUT(2, Pin%%V0S17P2.REJECTEDCODE)
UPDATE.COUNT = STAGECOM.RATE
LOOP
REJECTED = @TRUE
* Get next row from primary input pin DSLink18
STAGECOM.PINNO = 1
GET.Pin%%V0S17P1
ERROR = Pin%%V0S17P1.REJECTEDCODE
WHILE NOT(ERROR)
STAGECOM.PINNO = 2
IF STAGECOM.TRACE.STATS THEN CALL $PERF.BEGIN(-2)
IF @TRUE THEN
* Column derivation code for pin DSLink19
Pin%%V0S17P2.REJECTED = @FALSE
IF STAGECOM.TRACE.STATS THEN CALL $PERF.END(-2)
PUT.Pin%%V0S17P2
IF NOT(Pin%%V0S17P2.REJECTEDCODE) THEN
REJECTED = @FALSE
END ELSE
Pin%%V0S17P2.REJECTED = @TRUE
END
END
ELSE
Pin%%V0S17P2.REJECTED = @TRUE
Pin%%V0S17P2.REJECTEDCODE = 0
END
UPDATE.COUNT -= 1
IF UPDATE.COUNT LE 0 THEN CALL DSD.Update(HANDLES);UPDATE.COUNT = STAGECOM.RATE
REPEAT
RETURN
END
Thanks
reddy
Job abort code
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Job abort code
What's different today from other days? Track that down and you are well on your way to figuring it out.reddy wrote:... suddenly today ...
What kind of stage is on the other end of DSLink18? (Why don't you give your links meaningful names?) Line 42 performs a "get next row" from link DSLink18. This is where the problem has occurred. You have to figure out why.
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.