error while writing to Oracle

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
naveenpatil
Participant
Posts: 2
Joined: Thu Nov 30, 2006 3:32 am

error while writing to Oracle

Post by naveenpatil »

oesW_CUSTOMER,0: The system(sqlldr scott@orcl CONTROL=ora.2441402.693572.0.ctl LOG=ora.2441402.693572.0.log BAD=ora.2441402.693572.0.log.bad SILENT=header PARFILE=ora.2441402.693572.0.par) failed; see the log file for the Oracle specific message
Top
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Is it a message from DS or custom produced error message. What is the desing of the job? When was this error appearing?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Look in the Oracle "bad" file and "log" file for additional diagnostic information. This message has been reported by the Oracle bulk loader (sqlldr), not by DataStage. DataStage has simply logged it when it was received.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
ajith
Participant
Posts: 86
Joined: Thu Nov 10, 2005 11:10 pm

Post by ajith »

Post the error from the Log files mentioned in the Datastage error, as Ray mentioned ...
Top
Post Reply

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