Page 1 of 1

Access Vioaltion Error

Posted: Tue Feb 09, 2010 3:32 pm
by kab123
I am getting following error: Can somebody please shed some light as to what is this error about..

The Job reads data from Oracle(ODBC), does a lookup at transformer 1 and another lookup at tarnsformer2 and writes to SQLServer.

DataStage Job 1424 Phantom 4504
Program "JOB.1148172060.DT.1537057797.TRANS2": Line 148, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT was raised in stage lodinsFpaCommLoanNote1AcctDly..xfm2
Program "DSP.Close": Line 87, Exception raised in GCI subroutine:
Access violation.

The TRANS2 file hasthe following @ 148 line.

PUT.Pin%%V0S70P2
IF NOT(Pin%%V0S70P2.REJECTEDCODE) THEN
REJECTED = @FALSE
END ELSE
Pin%%V0S70P2.REJECTED = @TRUE
END

Posted: Tue Feb 09, 2010 3:48 pm
by ray.wurlod
The problem has occurred slightly after line 148 (line numbers can be out by a few particularly if INCLUDE directives appear in the code). It has occurred while trying to close the connection to the database (DSP.Close is an internal routine used by stage types that employ ODBC protocols.)

There's not enough information about which link closure is causing the problem. Can you find call(s) to DSP.Close in the Transformer code?

Posted: Tue Feb 09, 2010 4:04 pm
by kab123
any advise, How can I fix it ?

Posted: Wed Feb 10, 2010 4:01 am
by ArndW
ray.wurlod wrote:...Can you find call(s) to DSP.Close in the Transformer code?