Home » Developer & Programmer » Data Integration » Create Mapping As a Flat File Source (Oracle Warehouse Builder 11.2.0.1)
Create Mapping As a Flat File Source [message #597398] Fri, 04 October 2013 07:05 Go to next message
Nice123
Messages: 4
Registered: October 2013
Location: Karachi, Pakistan
Junior Member
Hi,

I'm new to OWB, my first project is to load data through flat file to oracle.
step i follow is,
=>Create Flat File Module
=>Create Location Directory
=>Create Flat File
=>Create External Table (Synch with my Flat File)
=>Create Mapping (Simple External Table mapped to table operator)
=>Create and bind table Operator

Mapping successfully deployed and but when i want to run it gives me following Error

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file IPDirectory.txt in FLAT_FILE_MOD_LOC_0 not found


When I directly mapped flat file to Table in mapping it gives another error

RPE-01013: SQL Loader reported error condition, number 4.
SQL*Loader-522: lfiopn failed for file (\\sfs\Analytics\Reference\SIMPLE_MAP.log)

I mention here that im working on my pc with OWB Client not on server and want to load data through flat file which is on my pc or on our sharing drive.

Please help me on this issue

Regards

[Updated on: Fri, 04 October 2013 07:06]

Report message to a moderator

Re: Create Mapping As a Flat File Source [message #597494 is a reply to message #597398] Sat, 05 October 2013 02:43 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In order to use an external table, a file that is its source must be located in a (file system) directory that resides on the database server (not your local PC, unless you installed database on your PC for your own amusement). Furthermore, an (Oracle object) directory must point to previously mentioned (file system) directory, and you need to grant READ and/or WRITE privileges on that directory to an Oracle user which is supposed to operate with that input file/external table.

Check whether you've done what I described. If not, you should fix it.
Re: Create Mapping As a Flat File Source [message #597578 is a reply to message #597494] Mon, 07 October 2013 00:39 Go to previous messageGo to next message
Nice123
Messages: 4
Registered: October 2013
Location: Karachi, Pakistan
Junior Member
Thanks for you reply,

is there any solution to upload file as a source which exist in the shared drive (Not on database server),this is because we can not create any file on database server that's why we create an shared folder which is accessible from server very easily and create directory based on that shared folder and read write privileges granted to oracle database user but still have same error.
Re: Create Mapping As a Flat File Source [message #597579 is a reply to message #597578] Mon, 07 October 2013 00:45 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try UNC (Universal Naming Convention); see what I did here.

[Updated on: Mon, 07 October 2013 00:46]

Report message to a moderator

Re: Create Mapping As a Flat File Source [message #597585 is a reply to message #597579] Mon, 07 October 2013 01:17 Go to previous messageGo to next message
Nice123
Messages: 4
Registered: October 2013
Location: Karachi, Pakistan
Junior Member
Please excuse me for my bad.

I dont understand that post "http://www.orafaq.com/forum/mv/msg/182161/558212/#msg_558212".
Could you please give any doc or reference about UNC.

Thanks in advance
Re: Create Mapping As a Flat File Source [message #597631 is a reply to message #597585] Mon, 07 October 2013 04:23 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do you use Google? It knows a lot about UNC.

This is what I was talking about (see red coloured line, which displays UNC):
SQL> select * from all_directories;

OWNER DIRECTORY_NAME DIRECTORY_PATH
------- ------------------------------ -----------------------------------
SYS SLIKE_4005_UPLOAD d:\gis\slike_4005_upload --> on a database server
SYS SLIKE_4005 \\my-ias\d$\home\gis\slike_4005 --> on an application server
Re: Create Mapping As a Flat File Source [message #597636 is a reply to message #597631] Mon, 07 October 2013 04:41 Go to previous messageGo to next message
Nice123
Messages: 4
Registered: October 2013
Location: Karachi, Pakistan
Junior Member
I already use use this if you see my given error after map directly to flat file

RPE-01013: SQL Loader reported error condition, number 4.
SQL*Loader-522: lfiopn failed for file (\\sfs\Analytics\Reference\SIMPLE_MAP.log)

"\\sfs\Analytics\Reference\"

But it Doesn't work.
Re: Create Mapping As a Flat File Source [message #597692 is a reply to message #597636] Mon, 07 October 2013 11:21 Go to previous message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right; I didn't spot that in your first message.

Unfortunately, there's nothing I could add to my previous messages. Hopefully, someone else will be able to assist.
Previous Topic: OWB not considering the constant whil execution
Next Topic: Record Delimiter not appearing in the Flat file generated from OWB
Goto Forum:
  


Current Time: Tue Mar 19 02:47:08 CDT 2024