Call to Sqlldr Failed
Posted: Tue Feb 01, 2011 10:30 am
Our development DataStage environment has stopped running any parallel job that has an Oracle stage. Below is the error log we are receiving. I have checked the permissions on the server for Scratch and the dsadm user has administrator access.
Occurred: 10:24:01 AM On date: 2/1/2011 Type: Fatal
Event: AssetFact,1: The call to sqlldr failed; the return code = 852; (...)
Occurred: 10:24:01 AM On date: 2/1/2011 Type: Fatal
Event: AssetFact,1: Unable to access the log file.
Occurred: 10:24:01 AM On date: 2/1/2011 Type: Fatal
Event: AssetFact,1: The runLocally() of the operator failed.
Occurred: 10:24:01 AM On date: 2/1/2011 Type: Info
Event: AssetFact,1: Input 0 consumed 1 records.
Occurred: 10:24:09 AM On date: 2/1/2011 Type: Fatal
Event: AssetFact,1: Operator terminated abnormally: runLocally did not return APT_StatusOk
Occurred: 10:24:09 AM On date: 2/1/2011 Type: Fatal
Event: main_program: Step execution finished with status = FAILED.
Occurred: 10:24:09 AM On date: 2/1/2011 Type: Info
Event: main_program: Startup time, 0:16; production run time, 5:23.
Occurred: 10:24:14 AM On date: 2/1/2011 Type: Control
Event: Job AssetFactParallel aborted.
Occurred: 10:24:01 AM On date: 2/1/2011 Type: Fatal
Event: AssetFact,1: The call to sqlldr failed; the return code = 852; (...)
Occurred: 10:24:01 AM On date: 2/1/2011 Type: Fatal
Event: AssetFact,1: Unable to access the log file.
Occurred: 10:24:01 AM On date: 2/1/2011 Type: Fatal
Event: AssetFact,1: The runLocally() of the operator failed.
Occurred: 10:24:01 AM On date: 2/1/2011 Type: Info
Event: AssetFact,1: Input 0 consumed 1 records.
Occurred: 10:24:09 AM On date: 2/1/2011 Type: Fatal
Event: AssetFact,1: Operator terminated abnormally: runLocally did not return APT_StatusOk
Occurred: 10:24:09 AM On date: 2/1/2011 Type: Fatal
Event: main_program: Step execution finished with status = FAILED.
Occurred: 10:24:09 AM On date: 2/1/2011 Type: Info
Event: main_program: Startup time, 0:16; production run time, 5:23.
Occurred: 10:24:14 AM On date: 2/1/2011 Type: Control
Event: Job AssetFactParallel aborted.