topic Re: Error while fetching data from SAP using Talend Open Studio DI 5.4.1 in Talend Studio

Error while fetching data from SAP using Talend Open Studio DI 5.4.1

_AnonymousUser — Tue, 07 Jun 2016 15:10:15 GMT

Hi Team,
I have to fetch data from SAP. Using Talend Open Studio DI 5.4.1
Suppose SAP "MARA" Table which has 100+ columns
I have used tPLSAPSimpleInput component to fetch the data from SAP.
Used the function "RFC_READ_TABLE" to read from SAP.
I am able to read data from the above SAP table "MARA" only when I use few columns.
But if I use all the columns 100+ from the table & fetch data using "RFC_READ_TABLE" the component shows error as below.
Exception in component tPLSAPSimpleInput_2
java.lang.RuntimeException: com.sap.conn.jco.AbapException: (126) DATA_BUFFER_EXCEEDED: DATA_BUFFER_EXCEEDED
    at move_it_pilot.sapinput_plsap_conn_0_1.SapInput_PLSAP_Conn.tPLSAPSimpleInput_2Process(SapInput_PLSAP_Conn.java:15106)
    at move_it_pilot.sapinput_plsap_conn_0_1.SapInput_PLSAP_Conn.tSAPConnection_2Process(SapInput_PLSAP_Conn.java:15326)
    at move_it_pilot.sapinput_plsap_conn_0_1.SapInput_PLSAP_Conn.runJobInTOS(SapInput_PLSAP_Conn.java:15544)
    at move_it_pilot.sapinput_plsap_conn_0_1.SapInput_PLSAP_Conn.main(SapInput_PLSAP_Conn.java:15409)
Caused by: com.sap.conn.jco.AbapException: (126) DATA_BUFFER_EXCEEDED: DATA_BUFFER_EXCEEDED
    at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcClient.execute(MiddlewareJavaRfc.java:1875)
    at com.sap.conn.jco.rt.ClientConnection.execute(ClientConnection.java:1120)
    at com.sap.conn.jco.rt.ClientConnection.execute(ClientConnection.java:953)
    at com.sap.conn.jco.rt.RfcDestination.execute(RfcDestination.java:1465)
    at com.sap.conn.jco.rt.RfcDestination.execute(RfcDestination.java:1435)
    at com.sap.conn.jco.rt.AbapFunction.execute(AbapFunction.java:300)
    at move_it_pilot.sapinput_plsap_conn_0_1.SapInput_PLSAP_Conn.tPLSAPSimpleInput_2Process(SapInput_PLSAP_Conn.java:13625)
    ... 3 more
disconnected
1) Is there any limitation in accessing data using "RFC_READ_TABLE" function 128 Bytes as such ? If yes, how to overcome this limit?
2)Is the above limitation is from SAP side with respect to function "RFC_READ_TABLE" or it is from Talend component side limitation
2)Can creating custom BAPI will help us to fetch the all the data having all the columns 100+ .Any specific configuration to be performed?
3)Does Talend open studio DI support this ?If yes Which version & How?
4)Will tSAPInput Component helps us to fetch all the 100+ columns data from SAP "MARA" table without error Is there any limitations with respect to fetching data from SAP?
Please support.
Thanks Raj.

Re: Error while fetching data from SAP using Talend Open Studio DI 5.4.1

Anonymous — Wed, 08 Jun 2016 04:21:43 GMT

You seems to be using the a component from http://www.plsapconnector.com/ not a component shipped by Talend out of the box. You could contact that vendor.
Regarding your questions: this is a limitation imposed by SAP and you would have to write a custom function module to overcome it.
We, Talend, have done this for you though already. Starting from Talend 5.6.1 the tSAPInput component is using a custom module and we have improved it ever since. You should consider using 6.1.1 or the 6.2.1 out in July 2016.
Thomas

Re: Error while fetching data from SAP using Talend Open Studio DI 5.4.1

Sid3 — Thu, 23 Mar 2017 08:36:03 GMT

Hi Guys,
I am facing same issue. I am using Talend 5.6.1.
Exception in component tSAPBapi_2_TSAPBapi_OUT
SAPException@a8ad249 [
errorCode=22
,errorGroup=126
,errorKey=DATA_BUFFER_EXCEEDED
,errorMessage=DATA_BUFFER_EXCEEDED
,errorMessageClass=null
,errorMessageNumber=000
,errorMessageText=
,errorMessageType=
While i am searching for this issue in SAP websites they recommended to use the /BODS/RFC_READ_TABLE2 instead RFC_READ_TABLE.
I tried using this but no luck it is returning 0 rows even though source table has data(160K).
Please suggest me.

Re: Error while fetching data from SAP using Talend Open Studio DI 5.4.1

Anonymous — Tue, 20 Nov 2018 14:16:51 GMT

Can you help me with custom function that should be used

Regards

Arif