Access Vioaltion Error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kab123
Participant
Posts: 92
Joined: Tue May 18, 2004 4:05 pm

Access Vioaltion Error

Post 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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kab123
Participant
Posts: 92
Joined: Tue May 18, 2004 4:05 pm

Post by kab123 »

any advise, How can I fix it ?
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

ray.wurlod wrote:...Can you find call(s) to DSP.Close in the Transformer code?
Post Reply