A DATA_BUFFER_EXCEEDED viewing data on a large table

[Aisurya]

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

[former_member317557]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Aisurya]

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

[former_member198401]

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

[Aisurya]

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

[former_member198401]

Yes Aisurya,

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

Regards

Arun Sasi