OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » i have prob with sql *loader in oracle apps

Home » Applications » Oracle Fusion Apps & E-Business Suite » i have prob with sql *loader in oracle apps (11.5.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

i have prob with sql *loader in oracle apps [message #335600]

Tue, 22 July 2008 22:19

karunakar_adepu84
Messages: 43
Registered: January 2008

Member

I have one more problem with SQL * loader can U please solve this problem?

that is
I have created .ctl file & flat file when I am using from backend it is working which means by using sql * loader in cmd it is working.

But while using the concurrent program with sql* loader it is not working it is giving error status.
the error message in log file is
+-----------------------------
| Starting concurrent program execution...
+-----------------------------

SQL*Loader-524: partial record found at end of datafile (d:\oracle\visappl\po\11.5.0\bin\erptest.ctl)

SQL*Loader: Release 8.0.6.3.1 - Production on Wed Jul 23 08:32:07 2008

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SQL*Loader-524: partial record found at end of datafile (d:\oracle\visappl\po\11.5.0\bin\erptest.ctl)

Program exited with status 3

Cause: The program terminated, returning status code 3.

Action: Check your installation manual for the meaning of this code on this operating system.
Concurrent Manager encountered an error while running SQL*Loader for your concurrent request 2808538.

Review your concurrent request log file for more detailed information.

with regards....

Report message to a moderator

Re: i have prob with sql *loader in oracle apps [message #335803 is a reply to message #335600]

Wed, 23 July 2008 16:18

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

SQL*Loader-524: partial record found at end of datafile (d:\oracle\visappl\po\11.5.0\bin\erptest.ctl)

How does this partial record at the end of datafile (...erptest.ctl) look like? Should it be there? If not, remove it. Or, would you rather fill in the missing part? If possible, do so.

Report message to a moderator

Re: i have prob with sql *loader in oracle apps [message #336007 is a reply to message #335803]

Thu, 24 July 2008 07:03

kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India

Member

check if any null values present at the end of file
-Kittu

Report message to a moderator

Re: i have prob with sql *loader in oracle apps [message #336127 is a reply to message #336007]

Thu, 24 July 2008 23:06

karunakar_adepu84
Messages: 43
Registered: January 2008

Member

no I checked my flat file it is not containing any nulls.

while working with backend using sql*loader it is working that means the data transfering into the tables.

The error comming while executing with concurrent program only.

Report message to a moderator

Re: i have prob with sql *loader in oracle apps [message #336322 is a reply to message #335803]

Fri, 25 July 2008 12:17

karunakar_adepu84
Messages: 43
Registered: January 2008

Member

hi, thankq for reply,

but my problem is still there only,

my flat file is emp.txt
contains

1234,karna
1212,sathi

my ctl file is emptest.ctl

load data
infile 'D:\.......\emp.txt'
truncate into emp1234
fields terminated by ','
(empno,ename)

If I am using sql * loader the data transfering into the table.

but when I am using the concurrent program as executable as sql*loader it is displying the error, the error is

sql*loader -524 : partial data at the end of the flatfile.

with regards,
karunakar

Report message to a moderator

Re: i have prob with sql *loader in oracle apps [message #336382 is a reply to message #336322]

Sat, 26 July 2008 03:42

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why don't you post a WORKING example? Control file you posted is syntactically wrong (misses the TABLE keyword).

So, how do you expect us to reproduce your case if you post incorrect information?

However, you might check whether control file, datafile (and possibly parfile) contain LINEFEED after the end of the last line in each of these files.

How to do that? Open them in any text editor, go to the end of the last line and press <Return>.
If you need to use hex editor, append hex value "0A" to the end of the file.

Save the modified file(s) and start loading session once again.

Report message to a moderator

Re: i have prob with sql *loader in oracle apps [message #337982 is a reply to message #336382]

Sat, 02 August 2008 00:24

sivee
Messages: 6
Registered: August 2008

Junior Member

first move your control file and data file to application server custom_top/ bin direcorty, once u ftp your files to server. u can create concurrent program attaching your control in executable as sql loader.

make sure address of data file path specified in control file.
'/u02/oracle/VIS/apps/apps_st/appl/iappz/12.0.0/bin/BTEMP.csv'

regards,
sivee

Report message to a moderator

Previous Topic:	pdf output to Email?
Next Topic:	Order Management, iStore, iPayment,Procurement, OAF Interview Questions Needed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 11:56:21 CST 2025