Question Re: A DATA_BUFFER_EXCEEDED viewing data on a large table in Technology Q&A

A DATA_BUFFER_EXCEEDED viewing data on a large table

Aisurya — Tue, 31 Mar 2015 17:53:39 GMT

Hello,

Am getting error below while fetching data in DS designer from SAP ECC Tables.

Error calling RFC function to get table data: <RFC_ABAP_EXCEPTION-(Exception_Key: DATA_BUFFER_EXCEEDED, SY-MSGTY: E, SY-MSGID:

I followed the KBA : 1752954 - DATA_BUFFER_EXCEEDED error - Data Services and found the RFC: Z_AW_RFC_READ_TABLE is available in SAP ECC .

Please help , how do i resolve this kind of error.

Aisurya

Re: A DATA_BUFFER_EXCEEDED viewing data on a large table

Former Member — Wed, 01 Apr 2015 03:01:12 GMT

How many records in the source table that you are trying to extract ? Is table too wide ( too many fields ) ?

Re: A DATA_BUFFER_EXCEEDED viewing data on a large table

Aisurya — Wed, 01 Apr 2015 03:11:51 GMT

Hello Mayank,

Yes the source table is a having more than 10k of Records , and there are 169 fields . Am fetching data from KNA1 table from SAP ECC.

Aisurya

Re: A DATA_BUFFER_EXCEEDED viewing data on a large table

Former Member — Wed, 01 Apr 2015 03:41:11 GMT

Count of records is OK but table might be too wide for DS to extract directly. Wait for other experts' response.

Re: A DATA_BUFFER_EXCEEDED viewing data on a large table

Former Member — Wed, 01 Apr 2015 05:44:34 GMT

Hi Aisurya,

The cause of the exception is a combination of factors:

The data extracted for a row in an SAP application table source is larger than 512 bytes.
The Data Services Remote Function Call (RFC) /BODS/RFC_STREAM_READ_TABLE is not installed on the SAP application server.

If the function /BODS/RFC_STREAM_READ_TABLE is not loaded to the SAP application server, Data Services extracts data using the SAP-supplied function, RFC_READ_TABLE. This function call limits extracted data to 512 bytes per row.

Also you can try using the enhanced version of RFC_READ_TABLE called /BODS/RFC_READ_TABLE2.

Regards

Arun Sasi

Re: A DATA_BUFFER_EXCEEDED viewing data on a large table

Aisurya — Wed, 01 Apr 2015 05:50:16 GMT

Hello Arun,

How to try using /BODS/RFC_READ_TABLE2 . When i drag the KNA1 table from DS and click on view data getting the Buffer Exceed error .

Or you mean to say , the FM /BODS/RFC_READ_TABLE2 to be installed in SAP AS ?

Aisurya

Re: A DATA_BUFFER_EXCEEDED viewing data on a large table

Former Member — Wed, 01 Apr 2015 05:54:47 GMT

Yes Aisurya,

You need to install the function /BODS/RFC_READ_TABLE2 on the SAP App Server.

Regards

Arun Sasi

Re: A DATA_BUFFER_EXCEEDED viewing data on a large table

Former Member — Thu, 02 Apr 2015 15:32:35 GMT

Before you connect to any SAP application (ECC, BW, MDG, etc), it is advisable to install all the SAP DS functions. Check page 11 of the SAP supplement (for DS 4.2) provided in the link below. You should get ypur BASIS team to install all the functions.

https://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_sap_en.pdf

-Chaitanya

Re: A DATA_BUFFER_EXCEEDED viewing data on a large table

former_member317557 — Thu, 09 Apr 2015 18:20:06 GMT

Hi Aisurya,

You can use the ABAP DataFlow, however the environment has to be open, or you can with the help of an ABAP, create the similar process with the ABAP DataFlow (generate a txt file in a common folder to DS and ECC), this so will have no problems.

Fernando