fatal error

sirisha · Post by **sirisha** » Mon Sep 17, 2007 4:42 am

The call to sqlldr failed; the return code = 256;
please see the loader logfile: /opt/product/Ascential/DataStage/OnePercent/Scratch/ora.8497.14949d.2.log for details.,

parag.s.27 · Post by **parag.s.27** » Mon Sep 17, 2007 4:52 am

sirisha wrote:The call to sqlldr failed; the return code = 256;
please see the loader logfile: /opt/product/Ascential/DataStage/OnePercent/Scratch/ora.8497.14949d.2.log for details.,

Please post full problem description.

there might be a possibility that You are loading some record in SQL, in which a field has a foreign key relationship and you are loading something which is not present in the master table...just chack

ray.wurlod · Post by **ray.wurlod** » Mon Sep 17, 2007 3:41 pm

Welcome aboard.

What's in /opt/product/Ascential/DataStage/OnePercent/Scratch/ora.8497.14949d.2.log ?

DS_FocusGroup · Post by **DS_FocusGroup** » Tue Jan 08, 2008 3:12 am

i am having the same problem now . the log file ... it says it does not exist ? any general reason as to why we get this error ?

i am loading about 4 m records.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 08, 2008 4:08 am

What says what doesn't exist?

Preserve the data and control files and run the bulk loader with your DBA looking on. Perhaps there are some trace tools available (to the DBA) that would help.

The bulk load is initiated by DataStage, but once it's running DataStage has no more control. You have to diagnose any failure using database diagnostic utilities.

DS_FocusGroup · Post by **DS_FocusGroup** » Tue Jan 08, 2008 10:25 am

when i try to view the file in the folder which it is being created it says the file does not exist.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 08, 2008 4:01 pm

Use find to search for the log file. Look first on all scratch disks defined in the configuration file used to run the job.

DS_FocusGroup · Post by **DS_FocusGroup** » Thu Jan 10, 2008 3:47 am

ive seen the config file and they point to the same directory. the control file is there but the log file is not.
the next 2 errors in the job log are

1. unable to acces the log file
2. the run locally opertaor failed.

I hope this is not one of the bugs again in DS ?

DS_FocusGroup · Post by **DS_FocusGroup** » Thu Jan 10, 2008 3:49 am

p.s do we need to set any user defined variables and set them for oracle ?
like for home etc ?

DSXchange

fatal error

fatal error

Re: fatal error