Job abort code

[reddy]

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

[rasi]

Reddy

Do a search on "Access violation" it was covered before in this forum

[ray.wurlod]

... suddenly today ...

What's different today from other days? Track that down and you are well on your way to figuring it out.

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.