load method giving fatal error

bi_fujitsu · Post by **bi_fujitsu** » Fri Apr 06, 2007 6:19 am

Hi

I am trying to load records from a dataset into an oracle table using load method. But when i run the job it fails giving the following error

ORA_PS_AZERITY_INVENTORY_ITEM_CDC,1: The system(sqlldr ETLLOADER@CORACDEVL66 CONTROL=ora.5451.353168.1.ctl LOG=ora.5451.353168.1.log BAD=ora.5451.353168.1.log.bad SILENT=header PARFILE=ora.5451.353168.1.par) failed; see the log file for the Oracle specific message.

I could not make out what this error is. Can anybody help me out on this.

ArndW · Post by **ArndW** » Fri Apr 06, 2007 6:44 am

Check your "ora.5451.353168.1.log" log file to see the detailed error message.

DSguru2B · Post by **DSguru2B** » Fri Apr 06, 2007 6:45 am

you need to look in the .bad file for more log messages.

ivannavi · Post by **ivannavi** » Mon Apr 09, 2007 3:50 am

To see the files mentioned above go to the scratch directory. On my site it's location is "/asc/Ascential/DataStage/Scratch". It contains more than 40000 files. Maybe your destination table has a field named TIMESTAMP or some other word that is a keyword to sqlldr.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 09, 2007 2:49 pm

The location of your scratch disk is unlikely to help anyone other than your co-workers on the same server.

Location of scratch disk is specified by the configuration file selected when the job is run - it can differ day to day.

Also, you need to check all the scratch disks for the node from which the error was reported - in the original post this was node #1, which is the second node mentioned in the configuration file.