[Solved] Talend: tSAPTableInput DATA_BUFFER_EXCEEDED error

When running a Job in Talend, where you use the tSAPTableInput component, you may encounter the following error.

Problem

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

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

Please follow and like us:
error

Leave a Reply

Close Menu
Social media & sharing icons powered by UltimatelySocial
error

Enjoy this blog? Please spread the word :)