OraFAQ Forum: Data Integration

Home » Developer & Programmer » Data Integration » Flat File

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

Flat File [message #204267]

Sun, 19 November 2006 22:42

mamata08
Messages: 30
Registered: December 2005
Location: Banaglore

Member

Hi All ,

I am trying to load data from a flat file to a table using OWB10g . Every thing like mapping validation , deployemnt are success but during execution I am getting Following message

Starting Execution MAP_FILE
Starting Task MAP_FILE
RPE-01013: SQL Loader reported error condition, number 1.
Completing Task MAP_FILE
Completing Execution MAP_FILE

Copletion Status Completed with error .

No data is loaded can any body help me what is the error here .
How to solve that .

Hope for quick response

Thanks

Report message to a moderator

Re: Flat File [message #204271 is a reply to message #204267]

Sun, 19 November 2006 22:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Post Deleted.

[Updated on: Sun, 19 November 2006 22:57]

Report message to a moderator

Re: Flat File [message #204469 is a reply to message #204271]

Mon, 20 November 2006 22:34

mamata08
Messages: 30
Registered: December 2005
Location: Banaglore

Member

Hi Taj,

I am doing this mappin OWB10g and I am new to this so I do not know how to find the control file from this . Its a simple mapping where I am trying to deploy data from flat file to a table . Attached is the data file pls .. find it . Tell me how can I find the Control file so that I will be able to send you

Thanks

Attachment: data.csv
(Size: 0.76KB, Downloaded 2651 times)

Report message to a moderator

Re: Flat File [message #204474 is a reply to message #204469]

Mon, 20 November 2006 23:01

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi mamata,

I am not very familiar with OWB. but go through below link it will help you.

http://forums.oracle.com/forums/thread.jspa?threadID=269699

Solution:
This error is mostly because of the log file location. In my case the apparently after moving to production environment from test env, the log file location and the log file name was missing from the mapping configuration. So to solve it:
(a) go to configure the mapping by right click.
(b) in config give the right log file location where the user (who executed the mapping) has the write permissions. This file location will be a drop down selection out of the file locations that you have created in OWB (under which the flat file has been sampled).
(c) similarly give a log file name there.
(d) re-deploy your mapping.

Hope this helps
Taj.

Report message to a moderator

How to increate the buffer size for big files in external tables [message #218406 is a reply to message #204267]

Thu, 08 February 2007 01:40

kingvasu
Messages: 4
Registered: February 2007
Location: Mumbai

Junior Member

Hi,

Im new to the OWB, Please can any one help from the following error,

ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04020: found record longer than buffer size supported, 524288, in F:\MIDT\ext_arv.txt
ORA-06512: at "SYS.ORACLE_LOADER", line 52

the flat file is afixed formate and big , when i try to view the data in external i got the following error, so how can i increate the buffer size ?

Rgds
king

Report message to a moderator

Re: How to increate the buffer size for big files in external tables [message #218419 is a reply to message #218406]

Thu, 08 February 2007 02:43

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

HI,

Actual what you did so far. ? please post here.
[pre]
first create DIRECTORY
AND grant read or write privs to user.
MAKE SURE ".DAT" FILE EXISTS IN WRITE DIRECTORY PATH.

REGARDS
Taj

Report message to a moderator

Re: How to increate the buffer size for big files in external tables [message #218428 is a reply to message #218419]

Thu, 08 February 2007 03:21

kingvasu
Messages: 4
Registered: February 2007
Location: Mumbai

Junior Member

Hi Taj,
these are the steps i did while loading

1 first created the file module and imported the flat file, in the sample, i choose fixed formate and positioned the falt file.
2 Next created external table module and assigned the flat file to the external table, configured, validated and generated.

3 Right clicked the external table and i clicked on data option , i got this error

ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04020: found record longer than buffer size supported, 524288, in F:\MIDT\ext_arv.txt
ORA-06512: at "SYS.ORACLE_LOADER", line 52

so, please help out from this error and kindly give the steps how to increase the size, is there any option in owb or at the data base level..
i try out this READ SIZE 52428800 at the data base level..

Rgds

King

[Updated on: Thu, 08 February 2007 03:24]

Report message to a moderator

Re: How to increate the buffer size for big files in external tables [message #362701 is a reply to message #218428]

Wed, 03 December 2008 16:01

farrider
Messages: 1
Registered: December 2008

Junior Member

The problem is usually caused when the newlines in the text file are only "\n" and not "\r\n". For some reason, on Windows, Oracle expects "\r\n", and when it does not find it, it reads the whole file as if it were one line.

So the solution is to fix you newline character in the text file. Better yet, make the record delimiter a normal character, if possible.

Report message to a moderator

Previous Topic:	Problem deploying Connectors
Next Topic:	How do you do to update a profile?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 13 20:11:49 CST 2025