We are extracting data from R3 and we have an problem with this error message
Cannot open file </data_work/shuttle/ab.dat>. Please check its path and permissions.This problem occurs everyday but with different jobs. One day the job runs fine and sometimes fails with this message. All permissions to the file are fine its so intermittent with these jobs that we unable to source the problem. Also after the problem occurs when you re run the job it runs fine.
Its also hard to re create the issue. BUt happens pretty much every day during our production schedule
Does the job server fails to read it??
We are using DS 12.2.0.
Hopefully I've explained it properly
Appreciate your thoughts on this
I assume this file is generated by the SAP application (automatically). Possibly the file sometimes is not ready when the DS data flow is trying to access it.
If this is the case, either of the following might will be the solution:
- Manually generate the file and then run the job.
- Add script in the job to check if the file exists, if yes continue processing, if not loop to wait for the upcoming file or message alert or simply quit the job or ...
How are you tranfering the file? Shared directory? What about trying with the FTP server method?
(You need an FTP server on your SAP machine.., IIS for Windows, ftpd for Unix)
This way the FTP protocol would take care of the transport to your DS machine.
An advantage is that with the FTP method you can put retries into the DSConfig.txt file.
1571986 - Error: Data Services FTP transfer for ABAP integration is giving error "Data flow <data flow name> FTP could not transfer file" while running an ABAP - Data Services