cancel
Showing results for 
Search instead for 
Did you mean: 

RFC connection fails when selecting DSO's containing many columns

0 Kudos

Hi All

I apologize if this thread is not in the correct place.

I am facing a problem with sap data service and rfc connection towards sap BW.

I have successfully created a connection and can fetch all the DSO’s in my sap BW environment.

But I am dealing with some errors in the connection, when large DSO’s are chosen.

Error calling RFC function to get table data: <RFC_ABAP_RUNTIME_FAILURE-(Exception_Key: DATA_OFFSET_TOO_LARGE)- Invalid subfield access: Offset too large>.

Is there a natural limitation on how many columns which can be fetch without getting an error. Or what is causing this error?

Is there a rule of thumb on data size?

I am also currently facing an import, which previously was successful, but now is generating an error similar to above.

Error:

Error calling RFC function to get table data: <RFC_ABAP_EXCEPTION-(Exception_Key: DATA_BUFFER_EXCEEDED, SY-MSGTY: E, SY-MSGID: FL, SY-MSGNO: 046, SY-MSGV1: /BODS/RFC_READ_TABLE)>.

I find it very odd that it was successful previously, and now is failing.

In general should this kind of connection only be used for small table, or small amount of records? I am using this in relation to CRM service data, which is a fairly large datasets.

Thx for you reply.

BR

Lasse

Accepted Solutions (1)

Accepted Solutions (1)

Ulrich_Schmidt
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Lasse,

it's not a problem with the RFC connection: the RFC connection seems to be fine. These error messages are created by the ABAP side (and only transported back to the RFC client via the existing connection). So you should contact the support team responsible for the ABAP code on backend side for help on how to avoid the errors.

The first error looks like the ABAP Function Module dumped because of a programming error (accessing a field with invalid offset). Unfortunately the name of the FM cannot be seen in the error, but there should be more details about the dump in ST22.

In the second case the FM "/BODS/RFC_READ_TABLE" gets called and returns the ABAP Exception "DATA_BUFFER_EXCEEDED". The responsible OSS component for that FM is BW-SYS. This, however, does not look like a programming error. Problem could simply be that the ABAP side runs out of memory?! That would explain, why it sometimes works and sometimes fails: it could depend on what other workload is going on on the App Server at the same time. If the system is pretty much idle, the call goes through, but if other memory intensive reports are running at the same time, it does not get enough memory and returns the above error?!

Best Regards, Ulrich

Answers (0)