Home » Developer & Programmer » Data Integration » Flat File
Flat File [message #204267] Sun, 19 November 2006 22:42 Go to next message
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
Re: Flat File [message #204271 is a reply to message #204267] Sun, 19 November 2006 22:56 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 1996 times)
Re: Flat File [message #204474 is a reply to message #204469] Mon, 20 November 2006 23:01 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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

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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Problem deploying Connectors
Next Topic: How do you do to update a profile?
Goto Forum:
  


Current Time: Thu Mar 28 06:46:43 CDT 2024