Page 1 of 1
oracle loading error
Posted: Mon Sep 08, 2014 10:18 pm
by India2000
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
Posted: Mon Sep 08, 2014 10:29 pm
by ray.wurlod
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.
Posted: Tue Sep 09, 2014 12:00 am
by India2000
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?
Posted: Tue Sep 09, 2014 6:38 am
by qt_ky
Post the entire job log with full details.
Posted: Tue Sep 09, 2014 8:01 am
by India2000
qt_ky,
The director log stops with
main_program:
orchgeneral: loaded
orchsort: loaded
orchstats: loaded
No other error messages.
Posted: Tue Sep 09, 2014 9:28 am
by chulett
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.