DSXchange

Posted: **Thu May 06, 2010 6:53 am**

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.

Posted: **Thu May 06, 2010 6:58 am**

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.

Posted: **Thu May 06, 2010 7:22 am**

priyadarshikunal wrote: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.

Posted: **Thu May 06, 2010 7:25 am**

Check the corresponding ctl file.

Posted: **Thu May 06, 2010 7:28 am**

Sainath.Srinivasan wrote: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.

Posted: **Thu May 06, 2010 8:00 am**

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

Posted: **Thu May 06, 2010 9:14 am**

priyadarshikunal wrote: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.

Posted: **Thu May 06, 2010 9:40 am**

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

Posted: **Fri May 07, 2010 4:01 am**

pavankatra wrote: 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.

Posted: **Sun May 09, 2010 10:25 pm**

Sainath.Srinivasan wrote:
pavankatra wrote: 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.

Posted: **Mon May 10, 2010 3:04 am**

But you havent posted the ctl file content yet.

Posted: **Mon May 10, 2010 5:53 am**

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

Posted: **Fri Aug 06, 2010 10:22 am**

Please install fixpack1 and this issue will fade away