Dear All,
Thanks for supporting so far all my ds issues
We are trying to insert records from flat file to oracle table using oracle enterprise stage with load option. Basically when we use load option it calls sqlldr, for some reason it was not working and throwing following error. Please advice us how to resolve the below problem. We do not have log file too.
Oracle_Enterprise_9,6: The call to sqlldr failed; the return code = 32,512;
please see the loader logfile: /apps/opt/IBM/InformationServer/Server/Scratch/ora.2430.764692.6.log for details.
Oracle_Enterprise_9,6: Unable to access the log file.
Oracle_Enterprise_9,6: The runLocally() of the operator failed.
Oracle_Enterprise_9,6: Input 0 consumed 1 records.
Oracle_Enterprise_9,6: Operator terminated abnormally: runLocally did not return APT_StatusOk
Oracle_Enterprise_9,5: sh: sqlldr: command not found
We have created a job which contains following stages to load the records,
Sequential stage -- Transformer Stage -- Oracle Enterprise Stage
SW/HW details:
ETL Tool: IBM Information Server 8.0.1
Database : Oracle 10g
O/S : RED HAT LINUX
Regards
JSK
Sqlldr error when we use oracle enterprise stage with load
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: