Job aborted

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
kkumardatastage
Participant
Posts: 84
Joined: Sat Jul 19, 2008 8:50 am

Job aborted

Post by kkumardatastage »

Hi

Please can any one help me with this issue i got the following error message in Director log for a job.

job i am loading a data set to a table by creating a new table, the data is loading perfectly but the job log show the following error.

----: The system(sqlldr CONTROL=ora.10194.96295.0.ctl LOG=ora.10194.96295.0.log BAD=ora.10194.96295.0.log.bad SILENT=header PARFILE=ora.10194.96295.0.par) failed; see the log file for the Oracle specific message.

----: The runLocally() of the operator failed.

----: Operator terminated abnormally: runLocally did not return APT_StatusOk

----: main_program: Step execution finished with status = FAILED.

Please help me

Thanks
k
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

-craig

"You can never have too many knives" -- Logan Nine Fingers
kkumardatastage
Participant
Posts: 84
Joined: Sat Jul 19, 2008 8:50 am

path to check oracle log error

Post by kkumardatastage »

Hi
Following is the path to check the oracle errors but we need to have admin access to enter into this path.

/opt/IBM/InformationServer/Server/Scratch

Thanks
K
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That may very well be your path but it's not necessarily "the" path. FYI.
-craig

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