DSXchange

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

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.

Hello,
what if the enviroment variable seemed ok. could it have another cause ?

Regards,
Maria

If you have mentioned Truncate,try changing this to Replace and run the job.

Maria_VVM wrote:what if the enviroment variable seemed ok. could it have another cause ?

Well, 'not found' is not found so either that variable is wrong or no Oracle client is installed on the DataStage server.

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.

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

What is the oracle error in the log saying? This is the important bit!

/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?