Oracle Load Error(DSEE7.5.1A, HP-UNX)
Posted: Thu Jul 20, 2006 12:16 pm
I've met two problems when using oracle load (parallel=true,direct=true,remote server,dataset to oracle or transformer to oracle)
1, there are a lot error mixed warning messages in logs, it overflow the rows count that can show in director. how can easy to get all the logs from the starting of job?
2, error message repeats:
....
---The call to sqlldr faild; the return code=35072;()
---Unable to access the log file.
---The runLocally() of the operator failed.
---Input 0 consumed 1 records.
---Operator terminated abnormally: runLocally did not return APT_StatusOK
---/usr/lib/pa20_64/dld.sl:'opt/datastage/Ascential/DataStage/DSEngine/java/jre/lib/PA_RISC2.0/hostpot/...
---sh:3254 killed
......
has some met this error before? any help is appreciated
Lynn
1, there are a lot error mixed warning messages in logs, it overflow the rows count that can show in director. how can easy to get all the logs from the starting of job?
2, error message repeats:
....
---The call to sqlldr faild; the return code=35072;()
---Unable to access the log file.
---The runLocally() of the operator failed.
---Input 0 consumed 1 records.
---Operator terminated abnormally: runLocally did not return APT_StatusOK
---/usr/lib/pa20_64/dld.sl:'opt/datastage/Ascential/DataStage/DSEngine/java/jre/lib/PA_RISC2.0/hostpot/...
---sh:3254 killed
......
has some met this error before? any help is appreciated
Lynn