Phantom Access violation

lote11 · Post by **lote11** » Wed Jan 25, 2012 5:05 pm

Hi guys,
Does anyone solved this problem. I read about it but never a solution to this.

"Oracle_OCI_0
DataStage Phantom Aborting with @ABORT.CODE = 3"

Im passing a Oracle query to a sequential file (TXT). The query works fine, if i view the data it shows normally.

Any idea?

Thanks

chulett · Post by **chulett** » Wed Jan 25, 2012 6:29 pm

Post the entire, unedited error message. Also include anything "From previous run..." if that log entry shows up when you Reset the aborted job.

lote11 · Post by **lote11** » Thu Jan 26, 2012 5:49 am

DataStage Job 234 Phantom 10560
Access violation.
Attempting to Cleanup after ABORT was raised in stage DW_DIM_SELL_IN_OBJETIVOS_MJG..Oracle_OCI_0
DataStage Phantom Aborting with @ABORT.CODE = 3

This is from the previous run

From previous run
DataStage Job 234 Phantom 10992
DataStage Phantom Finished.

chulett · Post by **chulett** » Thu Jan 26, 2012 6:47 am

So nothing really helpful, unfortunately.

Please post details of your job design and I'd also be curious what exactly you are doing in the OCI stage... is the stage generating the SQL or are you using something "user generated"? The more details you can provide the better and it might help if you posted the SQL involved as well.