What we want to achieve:
Load data from Excel into BI using BOBJ DS.
System landscape
BI system is on the NW 7.3 stack
The BOBJ Data Server runs on a Win 2k8 R2 Server
External file server on Windows 7 (Also running the IIS FTP Server).
With the DS Designer, we are able to load the schema into the BOBJ DS Server. FTP data access is enabled for data load into the job server. When we run the job, we get the following error.
FTP could not transfer file <XXX/YYY/store_regions.xls> from host <XX.XX.XX.XX>: <>. Ensure that the FTP relative path for the SAP server working directory is set correctly such that the data file is accessible to the FTP program. Also, ensure that the target path, where the transferred file is written to, is correct.
We simulated the FTP transfer on the command prompt and this works (no authorization issues).
When we run the job, we observe that the store_regions.xls files disappear from the source (Windows 7) machine. We assume that the error is occuring on the target system folder to which the file is written. Unfortunately, I have no clue where the target folder is and how this is customized. Can you help us?
Check the on which account data services is running in services.msc. IF it is local account, make sure the user logged into that machine has permissions to access file.IF running on specific account , check permissions for that user.
The system in which BOBJ DS has been installed, the services run on the local user account. The account logged in during fetching the file has administrator privileges on the requesting system and the system to which the file is requested.
As mentioned before, we see that the file is fetched from the source (the file gets deleted after the fetch), but never reaches the target. Any other suggestions?
Hello ganeshxp,
There is no SAP sysetms in the scenario. I am talking about a .XLS file fetch from a local system for a Excel file master data load.
Can you test with running services with specific account instead of local account?
We also faced the same problem working from command prompt and not working from DS designer.I have designed in the following way to get File from FTP location.
Running Data services with specific account and granting permissions to that account to get that file from FTP machine to local data services machine(Source location) .
To Get file from FTP Location to local data services installed machine.
exec(‘cmd’,'move \\<MACHINE_NAME><FOLDER_NAME>\<FILENAME*.csv > D:\<SOURCE_LOCATION_ONDS_INSTALLED>,8);
To read file from local source location on DS Installed machine(I have used this as per my requirement and configured Flat filesettings in Format-Flatfiles area of designer)
$GV_FILEPATH =’ ‘;
print($GV_FILEPATH);
wait_for_file(‘D:\SOURCE_LOCATION_ONDS_INSTALLED<FILENAME*.csv >,0,0,1,$filename);
$filename =replace_substr($filename,’/’,’\’);
(BOB member since 2011-05-04)
(BOB member since 2008-07-17)