[SOLVED] Talend tSAPTableInput DATA_BUFFER_EXCEEDED error rfc – check working solution in 2 mins!

When running a Job in Talend, where you use the tSAPTableInput component, you may encounter the following error: Talend tSAPTableInput DATA_BUFFER_EXCEEDED, which means that data buffer is exceed while retrieving SAP table.

Data Buffer Exceed Error While Retrieving SAP Table

This is the second interpretation of this error. Without extending it, let’s find out what the reason is!

Talend tSAPTableInput DATA_BUFFER_EXCEEDED

Firstly let’s look at the following error message.

[FATAL]: repository.job_dfkkop_0_1.job_DFKKOP - tSAPTableInput_1 DATA_BUFFER_EXCEEDED
SAPException@710b18a6 [
   errorCode=13
  ,errorGroup=126
  ,errorKey=DATA_BUFFER_EXCEEDED
  ,errorMessage=DATA_BUFFER_EXCEEDED
  ,errorMessageNumber=000
  ,errorMessageText=
  ,bapiName=RFC_READ_TABLE
  ,tableName=DFKKOP
]
  at org.talend.sap.exception.SAPException$Builder.<init>(SAPException.java:274)
  at org.talend.sap.exception.SAPException$Builder.<init>(SAPException.java:269)
  at org.talend.sap.exception.SAPException.newBuilder(SAPException.java:74)
  at org.talend.sap.impl.SAPUtil.createExceptionBuilder(SAPUtil.java:107)
  at org.talend.sap.impl.service.SAPTableDataService.getTableData(SAPTableDataService.java:234)
  at repository.job_dfkkop_0_1.job_DFKKOP.tSAPTableInput_1Process(job_DFKKOP.java:7628)
  at repository.job_dfkkop_0_1.job_DFKKOP.tHDFSConnection_1Process(job_DFKKOP.java:501)
  at repository.job_dfkkop_0_1.job_DFKKOP.runJobInTOS(job_DFKKOP.java:8354)
  at repository.job_dfkkop_0_1.job_DFKKOP.main(job_DFKKOP.java:8186)
[statistics] disconnected

Raason

When you try to read data that exceeds the buffer, you get an error called by RFC_READ_TABLE, which returns an exception: DATA_BUFFER_EXCEEDED.

Solution

It should (if possible) limit / reduce the number of columns (fields) that you want to download from the SAP system. In that, you will reduce the amount of memory allocated and do not exceed the same buffer which is set to 512 characters.

or

Add property “api.use_z_talend_read_table” = “true” in Advanced settings section in tSAPTableInput component.

About tSAPTableInput

These properties are used to configure tSAPTableInput running in the Standard Job framework. The Standard tSAPTableInput component belongs to the Business family. The component in this framework is available in all subscription-based Talend products.

https://help.talend.com/r/en-US/7.2/sap/tsaptableinput-standard-properties

If you enjoyed this post please add the comment below and share this post on your Facebook, Twitter, LinkedIn or another social media webpage.
Thanks in advanced!