RFC connection issue while extracting SAP data from BODS

[#1]

Hi,

We are extracting data from SAP source into BODS. SAP source is created in BODS data store. We use the SAP source as source in BODS and creating BODS mapping. When we execute the mapping it is failing with following error:

Error calling RFC function to get table data<Data buffer exceeded>. The operation attempts to extract more than the 512 bytes per row. ( PFA screenshot below)

We are splitting SAP sources in mapping into multiple sources which is time consuming and problamatic approach. Can you please advise how we can avoid this? Do we need to do any configuration in BODS?, please advise.

[Former Member]

Hi Rahul,

Which version of BODS are you using? If it's 4.1, try using the RFC transport method. It's fast and easy. I did not use any ABAP df.

Thanks, Arun J.

[Former Member]

Hi Rahul,

I completly agree with Abdul's advice in adding an ABAP Data flow as that will surely improve the performance. And as per SAP Suggenstion if we are extracting more than 10000 records from ECC better use SAP ABAP Data flow.

But in this case the volume of the Data you are trying to extract exceed the limt of your Buffer.

Try to increase the buffer Size ( done by BASIS).

Also try switching the Data Transfer methods and ABAP Execution Options in your SAP Data Store.

This might help!

Thanks

Rakesh

[Former Member]

Hi Rahul,

What is the extract method you are using and are you using all SAP source tables directly inside the Data Flow? then you should change it and go for 'ABAP Data Flow' method. You will be able to extract all columns in this method. 

Regards,

Abdulrasheed.