Hi,
I have a simple parallel job which reads from a sequential file and loads into a oracle table.
The job is aborting with following errors.
Project:cvid (etlprd2)
Job name:CvBT0002Job5SsaStageLoad_parllel.2
Event #:433
Timestamp:3/8/2006 1:00:10 PM
Event type:Warning
User:cvid
Message:
Oracle_Enterprise_2,4: sh: sqlldr: not found.
Project:cvid (etlprd2)
Job name:CvBT0002Job5SsaStageLoad_parllel.2
Event #:434
Timestamp:3/8/2006 1:00:10 PM
Event type:Fatal
User:cvid
Message:
Oracle_Enterprise_2,2: The call to sqlldr failed; the return code = 32,512;
please see the loader logfile: /landing01/dataint/Ascential/DataStage/Scratch/ora.439236.21827.2.log for details.
Also i do not see the log file (ora.439236.21827.2.log) mentioned in the error above.
by the way, my oracle 10g is sitting on a remote server. I am not sure if this is causing any problem.
Please let me know if you have any inputs.
Thanks,
Parimi
Error:sqlldr not found.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The DataStage user ID can not find the executable for sqlldr, the Oracle bulk loader. This in turn means that the PATH environment variable does not include the directory (usually $ORACLE_HOME/bin) in which this executable resides. Check in the dsenv file in the $DSHOME folder.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Well, 'not found' is not found so either that variable is wrong or no Oracle client is installed on the DataStage server.Maria_VVM wrote:what if the enviroment variable seemed ok. could it have another cause ?
Parimi - did this work for you in the past but is now failing, or this is your first attempt and it's not working?
ps. That log file was not created because it never got that far... that's where it was planning on putting it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 7
- Joined: Thu May 28, 2009 5:10 am
- Location: Plymouth
- Contact:
Re: Error:sqlldr not found.
What is the oracle error in the log saying? This is the important bit!parimi123 wrote:Hi,
I have a simple parallel job which reads from a sequential file and loads into a oracle table.
The job is aborting with following errors.
Project:cvid (etlprd2)
Job name:CvBT0002Job5SsaStageLoad_parllel.2
Event #:433
Timestamp:3/8/2006 1:00:10 PM
Event type:Warning
User:cvid
Message:
Oracle_Enterprise_2,4: sh: sqlldr: not found.
Project:cvid (etlprd2)
Job name:CvBT0002Job5SsaStageLoad_parllel.2
Event #:434
Timestamp:3/8/2006 1:00:10 PM
Event type:Fatal
User:cvid
Message:
Oracle_Enterprise_2,2: The call to sqlldr failed; the return code = 32,512;
please see the loader logfile: /landing01/dataint/Ascential/DataStage/Scratch/ora.439236.21827.2.log for details.
Also i do not see the log file (ora.439236.21827.2.log) mentioned in the error above.
by the way, my oracle 10g is sitting on a remote server. I am not sure if this is causing any problem.
Please let me know if you have any inputs.
Thanks,
Parimi
/Scratch/ora.439236.21827.2.log
This will give you the actual oracle error. Looks to me like sqlldr is returing the error 'not found' not that sqlldr cannot be found?
Oh, and for your information the error code above (assuming its an oracle one) means
ORA-32512: type "string" is unknown
Might be the data/records SQL loader is working with?
I'm lovin it!!