Trying to work through getting everything working with the Sales RM in our environment. We’ve got everything working in our development environment (both initial and delta loads).
We’ve moved everything up to our QAS environment and the initial load works just fine. However I’m at a stuck point with the delta load.
For just one of the dataflows, I’m getting an error saying that it can’t transfer a file via FTP. However, this file IS THERE. I can FTP to the server with the same user name that DI is using and I can see the file.
And every other dataflow seems to work just fine. I’ve tried exporting the DF from our development environment and importing it into QAS and the same result.
The dataflow is DF_SalesOrderStageDelta_SAP and the ABAP dataflow that is creating the file is R3_SalesOrdStageDelta.
I’ve gone so far as to just remove this dataflow from the workflow and everything else in the delta works fine…it’s just this one!
It’s driving me crazy, I don’t know what to do next.
Any thoughts?
EDIT: Here is the full error from DI.
FTP could not transfer file </usr/sap/interface/bobj/DeltaSOFact.dat> from host <gqas.calportland.com>: .
Please 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.
I guess the file has a lock of some kind. Either the source file or the target file. Why not trying to delete the file on both sides to proof?
My guess: There is an al_engine process - a running job/dataflow - left over for some reasons on the jobserver machine locking this file. So kill all al_engine processes if no job is running at that time and try again.
Were you able to resolve this error. I have same error. File is created on SAP server. However FTP fails on the same file.
Dataservices error:
FTP could not transfer file </bodiftp/scooi.dat> from host : <>. Please 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.
The job has ABAP data flow with FTP as data transport.
Finally found the reason for failure with help from SAP support. Posting here for other users who may encounter the same issue:
FTP server root path on SAP server was still the default one: C:\Inetpub\ftproot.
FTP options in the SAP data store, the relative path start from this folder. When I copied the dat file and its folder under this folder(C:\Inetpub\ftproot\bodiftp\scooi.dat), the job ran successfully.
Next action: Since the FTP on this server was meant only for bobj, I will contact our SAP system admin to change the default path to the drive where all the dat files reside or gets created.
(BOB member since 2010-08-10)
(BOB member since 2004-12-17)