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
oracle loading error
Moderators: chulett, rschirm, roy
oracle loading error
Last edited by India2000 on Tue Sep 09, 2014 8:10 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.