BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Aug 23.

Cannot open file, Please check path & permissions


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
arsheshadri
Forum Member
Forum Member



Joined: 30 Jun 2008

Posts: 4



PostPosted: Mon Jun 30, 2008 8:04 am 
Post subject: Cannot open file, Please check path & permissions

Hi,

I am trying to run a simple job which reads data from a flat file located on my client machine "C:\test.txt" and loads the data to an oracle table.

I am able to view the data on the design window. But If I try to Execute the job, I am getting an error message saying "Cannot open file <C:/test.txt>. Please check its path and permissions.".

Following is my Flat File Format which may be helpful.
Type - Fixed Width,
Location - Local
Root Directory - C:\
File Name - test.txt

BODI server is in Unix, and Client is in Windows.

Please let me know if I need to change anything?

Thanks & Regards
Sheshadri
Back to top
tSchmidt
Forum Member
Forum Member



Joined: 10 Apr 2007

Posts: 11


flag
PostPosted: Mon Jun 30, 2008 8:45 am 
Post subject: Re: Cannot open file, Please check path & permissions

Hi,

the jobserver can't find the file because he looks on his drive C:\. Use an UNC path or copy the file to the jobserver.

Regards
tS
Back to top
arsheshadri
Forum Member
Forum Member



Joined: 30 Jun 2008

Posts: 4



PostPosted: Mon Jun 30, 2008 8:57 am 
Post subject: Re: Cannot open file, Please check path & permissions

Thanks for the reply.
I do not have permission to copy the file to job server. So I have to keep the file on my local machine.

Actually I am new the BODI, Can you please tell me how to use the UNC path?

Thanks again
Shesha
Back to top
DI.net
Principal Member
Principal Member



Joined: 26 Jul 2007

Posts: 220



PostPosted: Mon Jun 30, 2008 10:58 am 
Post subject: Re: Cannot open file, Please check path & permissions

Hi,
can you atleast map your local network drive to Job server (unix).
and then give the path from there.If you give local on the file format window.

ps: chekc if the file is open some times when the file is open,it gives this error.

Thanks,
shawn
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10590
Location: Germany


flag
PostPosted: Tue Jul 01, 2008 8:54 am 
Post subject: Re: Cannot open file, Please check path & permissions

When you execute a job, it is executed by the jobserver - the Unix box in your case. How should the Unix server access the file on your computer? You need to enable that access somehow.
_________________
Werner Daehn
Product Manager Data Services
SAP AG
“The opinions expressed in this post are my own views and not those of SAP.”

PLEASE SUPPORT THIS: Run one ATL job and tell us the benchmark result. Details to be found here.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0302 seconds using 17 queries. (SQL 0.0028 Parse 0.0009 Other 0.0265)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo