I got the Error when I was trying to load data to Oracle

sck · Post by **sck** » Mon Apr 12, 2004 2:56 pm

Hi All,

Could anyone let me know what this error could be.

This occured when I was trying to load data into Oracle.
Oracle_Enterprise_2,0: system(sqlldr legacy_user@prepdev1.world CONTROL=ora.61034.798698.0.ctl LOG=ora.61034.798698.0.log BAD=ora.61034.798698.0.log.bad SILENT=header PARFILE=ora.61034.798698.0.par ) failed. See log file for Oracle specfic message.

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Apr 12, 2004 3:25 pm

Show us what's in the Oracle log (ora.61034.798698.0.log). It looks like Oracle has had a problem with what you've asked sqlldr to do. That is, DataStage has successfully generated the data file(s) and control file, but Oracle has not liked some or all of the rows in the data file. These rows will be in the "bad" file (ora.61034.798698.0.log.bad), possibly with additional diagnostic information.

raj4756 · Post by **raj4756** » Mon Jul 19, 2004 4:41 pm

I'm getting a similar error. Could you please tell me where are the log files located.

Thanks.

Raj

Eric · Post by **Eric** » Tue Jul 20, 2004 8:50 am

For problems with sqlldr, I expect the job cannot see $ORACLE_HOME/bin in the PATH variable. (Look in the Env in the Director Log)

(Also try looking for the ora* logs in /DataStage/Scratch)

ray.wurlod · Post by **ray.wurlod** » Wed Jul 21, 2004 6:24 am

Oracle logs are usually located in $ORACLE_HOME/logs. If not there, check out whether your Oracle configuration specifies an alternate location.

Eric · Post by **Eric** » Wed Jul 21, 2004 10:46 am

I had understood (although I could be wrong) that when the job goes wrong that DataStage re-directs these logs into it's own file system rather than the oracle install file system.