The call to sqlldr failed; the return code = 256;

[pavankatra]

Hi we are facing problem when we are loading data into oracle table.stage used is oracle enterprise stage.error is below.

Oracle_Enterprise_3,1: The call to sqlldr failed; the return code = 256;
please see the loader logfile: C:/IBM/InformationServer/Server/Scratch/ora.6172.514000.1.log for details.


Datastage version :8.1
Oracle version: 9i

Please anyone help to sortout this issue.

Thanks in advance.

[priyadarshikunal]

Oracle enterprise stage calls the oracle sqlldr when the mode is 'Load'. Since its not native to Datastage the errors are stored in log files.

So, Please check the file C:/IBM/InformationServer/Server/Scratch/ora.6172.514000.1.log for errors.

[pavankatra]

Oracle enterprise stage calls the oracle sqlldr when the mode is 'Load'. Since its not native to Datastage the errors are stored in log files.

So, Please check the file C:/IBM/InformationServer/Server/Scratch/ora.6172.514000.1.log for errors.

thanks for your reply.

Oracle_Enterprise_20,0: SQL*Loader-350: Syntax error at line 1.
Oracle_Enterprise_20,0: Expecting keyword LOAD, found "True".
Oracle_Enterprise_20,0: True
Oracle_Enterprise_20,0: ^
Oracle_Enterprise_20,1: The call to sqlldr failed; the return code = 256;
please see the loader logfile: C:/IBM/InformationServer/Server/Scratch/ora.5208.144000.1.log for details.

below is the information in log
SQL*Loader: Release 10.2.0.1.0 - Production on Thu May 6 17:56:05 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL*Loader-350: Syntax error at line 1.
Expecting keyword LOAD, found "True".
True
^


Oracle_Enterprise_20,1: The runLocally() of the operator failed.

[Sainath.Srinivasan]

Check the corresponding ctl file.

[pavankatra]

Check the corresponding ctl file. ...

I am sorry, i didnt get what you are saying.Can you please ellobrate what is ctl file and how to check that ctl file.

thanks for your reply.

[priyadarshikunal]

just change extention from '.log' to '.ctl' in the file name mentioned. Thats the SQL Loader control file, check that file.

[pavankatra]

just change extention from '.log' to '.ctl' in the file name mentioned. Thats the SQL Loader control file, check that file.

Thanks for your help.

There we have two files one is with ".log" and secon one is ".ctl"

So what i need to do to resolve this issue,please suggest me.why because i was strucked.It is almost end of the project.

thanks in advance.

[chulett]

Post the contents of the "control" file, the one with the .ctl extension.

[Sainath.Srinivasan]

So what i need to do to resolve this issue,please suggest me.why because i was strucked.It is almost end of the project.

Is this the only table in your entire project ? You say it is the end of the project ?

Your inhouse Oracle person must be able to assist with the control file issue.

[pavankatra]

So what i need to do to resolve this issue,please suggest me.why because i was strucked.It is almost end of the project.

Is this the only table in your entire projec ...

no,i am loading the data into 3 tables.It is my last step thats why i asked you like that.

Thanks in advance.

[kumar_s]

But you havent posted the ctl file content yet.

[chulett]

Either that or involve someone who knows how sqlldr works, someone like your DBA for instance.

[dsfamily]

Please install fixpack1 and this issue will fade away