system
October 14, 2009, 3:53pm
1
Hi everybody,
My files are located on a server which is not the DI server.
I have connected a network drive on the directory where they are located with the DI services account system (“X:” <–> “\myserver\mydirectory”)
My job uses these files and when I launch my job, I have an error when I specify path file like “X:” and it runs successfully when I specify UNC path (\myserver\mydirectory) …
Is it normal ?
Is it possible to use path file like “X:” ?
Toons (BOB member since 2009-04-14)
system
October 15, 2009, 3:39am
2
This is a usual case!!!
You say you try to use a map network drive option. Right?
Please try configuring the same Map Network Drive on the Job Server Machine, with the Login with which the DS Service runs up. I have not tried this out.
ganeshxp (BOB member since 2008-07-17)
system
October 15, 2009, 3:45am
3
you will have to add the mapped drive info in DSConfig.txt file on the Job Server machine
check the following post
I have a datastore which is pointing to the .mdb file on the mapped network drive using ODBC connection. I can import the tables into the datastore. But when i run my job with the import table as the source, I get the follwoing error:
“ODBC call for data source <A7H - 138> failed: <[Microsoft][ODBC Microsoft Access Driver] ‘(unknown)’ is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides>”
I have 100 m…
manoj_d (BOB member since 2009-01-02)
system
October 15, 2009, 7:59am
4
Thanks manoj_d but it seems that is not working …
not related to UNC path issue that you are having but you colud try mapped drive
you can give the mapped network drive information in DSConfig.txt where the Job Server is running (this is only for windows) as below
restart the DI Service
[MappedNetworkDrives]
LocalDrive1=X:\shared
RemoteDrive1=\\machine_name_or_ip\temp
My remote drive is \myserver\DataStore and I want to map X: on it.
Is that syntax is correct :
[MappedNetworkDrives]
LocalDrive1=X:\
RemoteDrive1=\\myserver\DataStore
If my file “test.txt” is located on “\myserver\DataStore”, I can then use X:\test.txt in my job to access it ?
Toons (BOB member since 2009-04-14)
system
October 15, 2009, 9:02am
5
you also need to ensure the user the DI service on the Job Server is running as has access to that network drive
speed12 (BOB member since 2004-09-27)
system
October 15, 2009, 9:57am
6
Yes, it is what I have done …
Any idea ?
Toons (BOB member since 2009-04-14)
system
October 15, 2009, 2:25pm
7
I contacted the SAP/BO support and they said me that we have to use UNC paths (\myserver\mydirectory) and that we can’t use network mappings (like “X:\mydirectory”) …
Toons (BOB member since 2009-04-14)
system
October 15, 2009, 6:22pm
8
this is strange this did worked in the following case
I realize that you have many posts on this topic, and I seem to think I might have read each of them. We’re running in a WIndows environment, and similar to some of the previous postings I am having some trouble accessing an Excel file posted on a network drive via the Jobserver, and I’m receiving the usual msg “2108 1076 FIL-080101 9/3/2009 5:14:43 PM Cannot open file \Server\Share\Dir\Test_File.xls>. Please check its path and permissions.”
Per your advice from some of the earlier postings, I …
did you restart DI Services ?
manoj_d (BOB member since 2009-01-02)
system
October 15, 2009, 7:15pm
9
Yes, I restart DI services but it didn’t work …
Perhaps, I did not set it properly …
I try this, is it correct ?
[MappedNetworkDrives]
LocalDrive1=X:\
RemoteDrive1=\\myserver\mydirectory
(“mydirectory” is a shared directory and the user that launch DI services has access to it)
Toons (BOB member since 2009-04-14)
system
October 15, 2009, 7:52pm
10
check what is the error that is logged in %LINK_DIR%\log\service_eventlog.txt
search for Error mapping localDrive
manoj_d (BOB member since 2009-01-02)
system
October 15, 2009, 8:39pm
11
Thanks manoj_d !!!
There was an error on this file. So I tried to modify the mapping in DSConfig.txt like this :
[MappedNetworkDrives]
LocalDrive1=X:
RemoteDrive1=\myserver\mydirectory
And now, it works !
Thank you very much !
Toons (BOB member since 2009-04-14)
system
October 16, 2009, 3:09pm
12
I open a new case with support to know if this solution is supported.
I wait for their reply and tell you more soon. :?
Toons (BOB member since 2009-04-14)
system
October 16, 2009, 4:34pm
13
I don’t see a reason why its not supported, its documented in technical Manual, check for “To use mapped drive names in a path” in manual
in the documentation steps are provided to update the DSConfig.txt from Designer, you directly modified the DSConfig.txt, I don’t see any issue with that
manoj_d (BOB member since 2009-01-02)
system
October 16, 2009, 5:31pm
14
I don’t see a reason why its not supported, its documented in technical Manual, check for “To use mapped drive names in a path” in manual
in the documentation steps are provided to update the DSConfig.txt from Designer, you directly modified the DSConfig.txt, I don’t see any issue with that
Exact ! I didn’t see that in documentation. Thanks for your help manoj_d !
Well, it’s curious that BO support didn’t guide me to this example …
Toons (BOB member since 2009-04-14)