The call to sqlldr failed; the return code = 256;
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am
The call to sqlldr failed; the return code = 256;
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.
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.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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.
So, Please check the file C:/IBM/InformationServer/Server/Scratch/ora.6172.514000.1.log for errors.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am
thanks for your reply.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.
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.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am
Thanks for your help.priyadarshikunal wrote:just change extention from '.log' to '.ctl' in the file name mentioned. Thats the SQL Loader control file, check that file.
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.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Is this the only table in your entire project ? You say it is the end of the project ?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.
Your inhouse Oracle person must be able to assist with the control file issue.
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am
no,i am loading the data into 3 tables.It is my last step thats why i asked you like that.Sainath.Srinivasan wrote:Is this the only table in your entire projec ...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.
Thanks in advance.