Records missing when extracting data from SAP to BODS

Dear all,

we are currently evaluating options for downloading data from an SAP-ECC system to BODS 3.2.

When using a simple ABAP Data Flow w/ transfer method ‘Direct Download’, the following problem occurs

  • ABAP program is properly generated
  • all data is selected from source table (according to SQL statement in generated ABAP and number of selected rows in SM50)
  • data packages (< 10 kB each) are written to temp file on BODS job server, BUT for each data package the file is overwritten (instead of the new records being appended)
  • the contents of the last data package are available for further processing in BODS…

Note that we have selected the ‘Append file’ option in the Data Transport’s properties.

Does anyone know, why the temp file on the BODS server is still being overwritten by each data package that is transferred from the SAP system? (…and how we can avoid this?)

Any help is appreciated!

Best Regards
Christian


cmeyer (BOB member since 2010-02-09)

Christian, could you please send me an email. It is the third time I am hearing this and would love to have a look at that for myself. We would need to make a couple of tests.

The others did simply use a different download method and I never had a chance to check where the actually problem comes from.


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

I am also encountering the same issue please let me know how did you resolved.


nybods (BOB member since 2010-03-27)

Werner,

Did you learn more about this? We may want to go down the same route for another project but I would like to know if this method is going to cause issues.


ErikR :new_zealand: (BOB member since 2007-01-10)

All I know is that we have one computer in-house where the same happens and we have no idea why. It has to be librfc related, asked our SAP colleges for help.

I haven’t checked the status recently.


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

I am having the same issue as well.

Windows 2008 R2
Data Services 12.2.2.3
ECC on Linux
Direct Download

We only commit the last few records in the file based on the batch commit size.

Did anyone ever find a solution to this problem?


jdh2n (BOB member since 2006-11-13)

I found the solution. The SAP GUI needed to be updated to version 7.10 Path 22. There was a bug utalizing the Download Method in the base version of the SAP GUI 7.10.


jdh2n (BOB member since 2006-11-13)

Thanks for figuring it out and letting us know!


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