DSXchange

Posted: **Wed Oct 28, 2009 3:36 am**

Hi,

Please find the error below.

Oracle_Enterprise_285,0: The call to sqlldr failed; the return code = 35072;
please see the loader logfile: /abc/ac/02/scratch/ora.20269.404983.0.log for details.

The job is inserting data to theoracle table using Load option, and is getting failed with the error mentioned above.

We have upgraded our DS version from 7.5.1 to 7.5.3. Previously the job use to run successfully with out anny issues, we are facing the issue after upgradation.

Help required.

Thanks

Posted: **Wed Oct 28, 2009 6:06 am**

did you try to open the log file /abc/ac/02/scratch/ora.20269.404983.0.log ,,

what did you have there ?

Posted: **Wed Oct 28, 2009 7:04 am**

mgendy wrote:did you try to open the log file /abc/ac/02/scratch/ora.20269.404983.0.log ,,

what did you have there ?

There is no such file created. The source for this job is Oracle Enterprise stage and target is also the same.

Posted: **Wed Oct 28, 2009 7:08 am**

You need to find the log file, no other clue to the error will exist. Also double-check you have permissions to that directory, that your user can actually create a file there.

DSXchange

DS job failed due to SQl Loader issue

DS job failed due to SQl Loader issue

DS job failed due to SQl Loader issue

Re: DS job failed due to SQl Loader issue