DS job failed due to SQl Loader issue

Nareshkurra · Post by **Nareshkurra** » 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

mgendy · Post by **mgendy** » 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 ?

Nareshkurra · Post by **Nareshkurra** » 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.

chulett · Post by **chulett** » 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