oracle loading error

India2000 · Post by **India2000** » Mon Sep 08, 2014 10:18 pm

I have a scenario to load data from dataset to an oracle. Load fails immediately without even attempting to read data set. The director log stops with

main_program:
without generating any error for failure. Can any one please let me know what could go wrong with the code or Datastage? Any input is really appreciated. Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Sep 08, 2014 10:29 pm

The "orch..." modules you mentioned have nothing to do with Oracle - they have to do with Orchestrate (the parallel execution engine of DataStage).

Are you really sure there are no other entries in the job log, and yet the Oracle table gets created? Possibly your logging system has become full or corrupted, though I'd expect you'd be seeing something from the logging service in the WAS log (SystemOut.log) if that were the case.

India2000 · Post by **India2000** » Tue Sep 09, 2014 12:00 am

Ray,I didn't get what you are saying..

Has any one came across such scenario before? I'm able to view the dataset.

is it because of lock on the table? or is this an DS configuration issue?

qt_ky · Post by **qt_ky** » Tue Sep 09, 2014 6:38 am

Post the entire job log with full details.

India2000 · Post by **India2000** » Tue Sep 09, 2014 8:01 am

qt_ky,

The director log stops with

main_program:
orchgeneral: loaded
orchsort: loaded
orchstats: loaded
No other error messages.

chulett · Post by **chulett** » Tue Sep 09, 2014 9:28 am

Unfortunately, with so little information posted there's not much anyone here can do for you. You either need another set of eyes or to enlist support for help.