Error in Reject Table loading

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
ravij
Premium Member
Premium Member
Posts: 170
Joined: Mon Oct 10, 2005 7:04 am
Location: India

Error in Reject Table loading

Post by ravij »

Hi,

My job is having the stages like this:
DS -> Trf -> DS
|
ora stage(Rej Link)

when i execute the job, getting the following error.
oraCdmDefectRej,0: The system(sqlldr CONTROL=ora.29332.526144.0.ctl LOG=ora.29332.526144.0.log BAD=ora.29332.526144.0.log.bad SILENT=header PARFILE=ora.29332.526144.0.par) failed; see the log file for the Oracle specific message.
i could not find any solution in the forum. Could any one help me in resolving this issue.
Thanks in advance.
Ravi
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

"see the log file for the Oracle specific message"
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The Oracle log file may be on the scratch disk defined in your configuration file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply