[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.

What is SAP?

SAP software solutions are some of the most popular and widely used enterprise resource planning (ERP) solutions in the world. They are used by businesses of all sizes, in a variety of industries, to streamline and optimize their operations.

SAP solutions are known for their flexibility and scalability, and can be customized to fit the specific needs of any organization. They offer a comprehensive suite of modules that cover all aspects of business management, from financials and accounting to human resources and supply chain management.

SAP software solutions are constantly evolving, with new features and functionality being added on a regular basis. This helps to ensure that businesses can keep up with the latest trends and technologies, and stay ahead of the competition.

If you’re looking for an ERP solution that can help your business run more efficiently and effectively, then SAP software solutions are definitely worth considering.

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

Could You Please Share This Post? 
I appreciate It And Thank YOU! :)
Have A Nice Day!