Page 1 of 1

ported jobs from 7.5x2 to 8.01.x;getting a strang error

Posted: Tue Jul 24, 2007 9:08 am
by muascdev
i am getting the following error;DataStage Job 138 Phantom 9612

Program "DSP.Open": Line 122, Exception raised in GCI subroutine:

Access violation.

Attempting to Cleanup after ABORT raised in stage J07_INSERT_INTO_MDM_NODE_M..Copy_of_DUAL

DataStage Phantom Aborting with @ABORT.CODE = 3


All i am doing is getting the seq number from dual; i am using link partioner and link collector in this job; any help is appreciated

Posted: Tue Jul 24, 2007 10:07 am
by muascdev
this issue is resolved; problem was in 7.5.2 sql used to be where num=:num in 8.x it needs to be ?

Posted: Tue Jul 24, 2007 10:33 am
by muascdev
the problem was actually table name not being specified