Error while loading data

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
reddy12
Participant
Posts: 99
Joined: Tue Aug 08, 2006 9:34 pm

Error while loading data

Post by reddy12 »

Hi i am geting the follwoing error.Just i am loading the data from flat file to oracle table.

Oracle_Enterprise_19,1: The system(sqlldr shrhlth/shared1@orcdbt CONTROL=ora.921628.154959.1.ctl LOG=ora.921628.154959.1.log BAD=ora.921628.154959.1.log.bad SILENT=header PARFILE=ora.921628.154959.1.par) failed; see the log file for the Oracle specific message.

can you please any one have Idea about this?

Thanks.
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

And what does the Oracle error log file contain? That will tell you exactly what happened.
Top
kris
Participant
Posts: 160
Joined: Tue Dec 09, 2003 2:45 pm
Location: virginia, usa

Re: Error while loading data

Post by kris »

reddy12 wrote:Oracle_Enterprise_19,1: The system(sqlldr shrhlth/shared1@orcdbt CONTROL=ora.921628.154959.1.ctl LOG=ora.921628.154959.1.log BAD=ora.921628.154959.1.log.bad SILENT=header PARFILE=ora.921628.154959.1.par) failed; see the log file for the Oracle specific message.
Were you able to see the log file "ora.921628.154959.1.log" contents?
You should see what caused it.


Best ragards,
~Kris
Top
reddy12
Participant
Posts: 99
Joined: Tue Aug 08, 2006 9:34 pm

Post by reddy12 »

Thanks for your reply
I don't know where can i find this oracle log..

Please let me know if you have any idea..

Thanks.

ArndW wrote:And what does the Oracle error log file contain? That will tell you exactly what happened. ...
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

I can't recall where the location defaults to, it will be either in the project directory or under the Oracle dir. I'd simply use the UNIX find command to locate it.
Top
Yuan_Edward
Participant
Posts: 73
Joined: Tue May 10, 2005 6:21 pm
Location: Sydney

Post by Yuan_Edward »

Check the APT configuration file of your job and the scratch disk should be the location for Oracle sqlldr logs.
reddy12 wrote:Thanks for your reply
I don't know where can i find this oracle log..

Please let me know if you have any idea..

Thanks.

ArndW wrote:And what does the Oracle error log file contain? That will tell you exactly what happened. ...
Edward Yuan
Top
bkumar103
Participant
Posts: 214
Joined: Wed Jul 25, 2007 2:29 am
Location: Chennai

Post by bkumar103 »

Hi
Oracle log file will be created in the directory, where the control file is placed. It will be good practice instead of just specifying the log file name give the compete path for the log file where it can be stored.

like
sqlldr shrhlth/shared1@orcdbt CONTROL=ora.921628.154959.1.ctl LOG=<log file dir>/ora.921628.154959.1.log BAD=<bad file dir>/ora.921628.154959.1.log.bad SILENT=header PARFILE=ora.921628.154959.1.par
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”