Oracle OCI 9i stage error

[Saravana]

Hi

I am getting following error when created a server job with oracle oci 9i /8i stage as input with transformer and seq file as output

Oracle OCI --> Transformer --> seq file

From previous run
DataStage Job 1 Phantom 5228
Program "JOB.1072369215.DT.1385956975.TRANS1": Line 62, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage Orcl_test..Transformer_10
Program "DSP.Close": Line 87, Exception raised in GCI subroutine:
Access violation.

I tried connecting to the DS server box as Adminstrator

I get the same error for both Oracle9i and 10g database and Oracle9i and 10g client

I appreciate your help in this regard.

Thanks,
Saravana

[kcbland]

It the message indicates that the job had an "Access violation. ", probably with the sequential text file. Any chance you had it open in Notepad or something? Even just have Windoze Explorer focused on a file induces a operating system lock on the file, which will cause an access violation with DataStage since DS requires exclusive access to the file.

If this file is somehow permanently locked, try a different output filename to prove this.