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 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 Member]

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 Member]

Yes Aisurya,

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

Regards

Arun Sasi