Page 1 of 1
I got the Error when I was trying to load data to Oracle
Posted: Mon Apr 12, 2004 2:56 pm
by sck
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
Posted: Mon Apr 12, 2004 3:25 pm
by ray.wurlod
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.
Posted: Mon Jul 19, 2004 4:41 pm
by raj4756
I'm getting a similar error. Could you please tell me where are the log files located.
Thanks.
Raj
Posted: Tue Jul 20, 2004 8:50 am
by Eric
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)
Posted: Wed Jul 21, 2004 6:24 am
by ray.wurlod
Oracle logs are usually located in $ORACLE_HOME/logs. If not there, check out whether your Oracle configuration specifies an alternate location.
Posted: Wed Jul 21, 2004 10:46 am
by Eric
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.