RE:ERROR

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
m_siddu2000
Participant
Posts: 19
Joined: Tue Aug 01, 2006 1:37 am
Location: Hyderabad

RE:ERROR

Post by m_siddu2000 »

Hi,

Iam running a job using sequential file stage as source and oracle as target and modify stage is used.After running the job, the job is aborted and the error is as follows:

Error1: DRS_Comp_Names_Ora,0: The system(sqlldr drs_gms_data01@ukdev432 CONTROL=ora.25372.7976d.0.ctl LOG=ora.25372.7976d.0.log BAD=ora.25372.7976d.0.log.bad SILENT=header PARFILE=ora.25372.7976d.0.par) failed; see the log file for the Oracle specific message.
Error2: DRS_Comp_Names_Ora,0: Operator terminated abnormally: runLocally did not return APT_StatusOk

Could anyone provide solution for this.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

sqlldr failed. And it noted you should "see the log file for the Oracle specific message". What did it say when you looked in the log file? You'll even note it provided the LOG filename from the sqlldr command line for you.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply