Cannot open file

dataservices job design
1

Hi,

Cannot open file <E://sandee_Integration/user_test_ERR.txt>. Please check its path and permissions.

What does it mean exactly. since i have already given the correct path which is on job server machine (and location = Job server for Job server manchine case
)

Provided i havenot created any file in the given folder… thought that DI will automatically create at the specified location.

isit…?
I have also tried with the designer machine’s path with the correct credentials like location = local for designer machine case

sjain :india: (BOB member since 2009-04-17)

2

https://wiki.sdn.sap.com/wiki/display/BOBJ/Shared+Directory+access

Werner Daehn :de: (BOB member since 2004-12-17)

3

Hi,

even, iam not able to access my Desktop files too.

{I think there may be an architecture behind… Job server is on some different windows server and we are using another windows server remotely for accesing designer. }

So what do you thin it maybe the problem…?

exec(‘cmd’, ‘net use \\server\share/USER:my_domain\user password’, 0);

Is it possible to use this in a testing environement, since we are already using remote machine via VPN and again will try to access a remote server…
:roll_eyes:

sjain :india: (BOB member since 2009-04-17)

4

Does the User on which the Service (Data Services Service)runs has access to these folders?

ganeshxp :us: (BOB member since 2008-07-17)

5

How can we determine whether user has got the access or not?

exec('cmd', 'net use \\\\server\\share/USER:my_domain\\user password', 0);

where Share = ?

can we give the path of the folder?

sjain :india: (BOB member since 2009-04-17)

6

Hi If I understand your problem correctly, just Login the Machine with which the Service runs and go to the mentioned server path and try creating a simple text file. If that does works fine, then for sure, Data Services/Data Integrator should be able to do the same.

If you are not sure of Administrator information, ask the Data Integrator Administrator.

One trick way, when you run a job, in the trace, a statement will be arriving as below

basically, the above mentioned user should have access to that folder.

ganeshxp :us: (BOB member since 2008-07-17)

7

Following is the Statement that i get in trace logs

JOB: Job
<TEST_USER_JOB> of runid <2009111402013924527140> is
initiated by user <[b]busobj[/b]>

So busobj is the system user(windows user) which is used to install Data Services

See, here 3 Developers using the same Job Server. Using Same Designer machine via Remote machine but user ID is different for each user.

then…

sjain :india: (BOB member since 2009-04-17)

8

that is not the problem bozz. See for all the 3 users, the job will run with this ‘busobj’ id only.

So basically, if ‘busobj’ windows user has the privilege, then all 3 is considered having the access.

Am I confusing you so much??? :?

ganeshxp :us: (BOB member since 2008-07-17)

9

Ok. thats great!!

So busobj(a windows user which is executing the Job) must have privilege to write a file… is it?

If we create a share folder and assign privileges to the user then it would be ok…right?
and how can be enable FTP ?

sjain :india: (BOB member since 2009-04-17)

10

Yeah fine what you say now is exactly the way it works!!! :slight_smile:

And about FTP, it works quite different.
You could probably, put up the FTP site, username,pwd, etc., etc., in a text file and execute it using the cmd.exe using the exec command.

ganeshxp :us: (BOB member since 2008-07-17)