OraFAQ Forum: Data Integration » Create Mapping As a Flat File Source

Home » Developer & Programmer » Data Integration » Create Mapping As a Flat File Source (Oracle Warehouse Builder 11.2.0.1)

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

Create Mapping As a Flat File Source [message #597398]

Fri, 04 October 2013 07:05

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Create Mapping As a Flat File Source [message #597578 is a reply to message #597494]

Mon, 07 October 2013 00:39

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.

Report message to a moderator

Re: Create Mapping As a Flat File Source [message #597579 is a reply to message #597578]

Mon, 07 October 2013 00:45

Littlefoot
Messages: 21823
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

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

Report message to a moderator

Re: Create Mapping As a Flat File Source [message #597631 is a reply to message #597585]

Mon, 07 October 2013 04:23

Littlefoot
Messages: 21823
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

Report message to a moderator

Re: Create Mapping As a Flat File Source [message #597636 is a reply to message #597631]

Mon, 07 October 2013 04:41

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.

Report message to a moderator

Re: Create Mapping As a Flat File Source [message #597692 is a reply to message #597636]

Mon, 07 October 2013 11:21

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	OWB not considering the constant whil execution
Next Topic:	Record Delimiter not appearing in the Flat file generated from OWB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 14 04:11:18 CST 2025