SAP R/3 Extract Data - Flat Files

dataservices sap-erp-bw
1

Hi Team,

DS SP02 - For data transfer method, i am using shared directory.
ERP Server - Linux

Working directory on SAP Server : /usr/sap/sid/SYS/global/ftproot
Application path to the shared directory: /usr/sap/sid/SYS/global/ftproot
Generated ABAP Directory : E:/Temp

If i set the path like this, i am getting below permission error. The folder is fixed with 777 Permission.

13472 14080 FIL-080101 4/2/2013 11:35:49 AM |Data flow DF_ApplVersion_SAP|Reader R3_ApplVersionSAP
13472 14080 FIL-080101 4/2/2013 11:35:49 AM Cannot open file </usr/sap/SID/SYS/global/ftproot/SAPVersion.dat>. Check its path and permissions.
12900 1648 FIL-080101 4/2/2013 11:35:49 AM |Data flow DF_ApplVersion_SAP|Reader R3_ApplVersionSAP
12900 1648 FIL-080101 4/2/2013 11:35:49 AM Cannot open file </usr/sap/SID/SYS/global/ftproot/SAPVersion.dat>. Check its path and permissions.

Please someone correct my mistake. provide a correction solution.

Regards
Thillai

thillaimca (BOB member since 2013-04-02)

2

SAP system user is not authorized to write to that dir?

A general 777 is not considered to be safe in Unix lands…

Johannes Vink :netherlands: (BOB member since 2012-03-20)

3

Hi consultant,

So, where i should create my shared directory in ERP Server. And how it should be given at Data Transfer method properities.

Regards
Thillai

thillaimca (BOB member since 2013-04-02)

4

try this.

Can you access that folder with the user that runs the DS Service? I bet it is that user not having access.
Does your trace tells ABAP Flow Completed…?

If so, then it is the access issue for the user running the service.

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

5

Yes . Your are right Ganesh!

ABAP Flow is started. But not completed. Can you tell me where to check the DS User and Permission.

Regards
Thillai.

thillaimca (BOB member since 2013-04-02)

6

Normally you see something like this:

DATAFLOW: Data flow <DF> is started.
ABAP: ABAP flow <R3> is started.
ABAP: Batch job <AW 03/30/13 07:00:48> is submitted. Job number is <07013600>
ABAP: Batch job <AW_03/30/13 07:00:48> for ABAP program <D:/tmp/Get_KNA1_Tbl.aba> is finished.
ABAP: ABAP flow <R3> is completed.
FTP: Started FTP transfer of file: <Tbl.dat>.
FTP: Completed FTP transfer of file: <Tbl.dat>.
DATAFLOW: Data flow <DF> is completed successfully.

If the abap flow starts, but does not finish the problem is not with transferring the flat file to the BODS server. The problem is on the SAP side.

Johannes Vink :netherlands: (BOB member since 2012-03-20)

7

HI consultant,

I am not getting the completed message, after getting “ABAP Flow R3 is started”, i am getting Terminated message. “Check DAT file path or permission”.

DAT file will not move to BO Systems.

Regards
Thillai

thillaimca (BOB member since 2013-04-02)

8

So the ABAP program executed by SAP cannot write into the specified directory, the “working directory on SAP server” as it is called in the datastore.

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