JCO_ERROR_COMMUNICATION: connection closed without message (CM_NO_DATA_RECEIVED) (tSAPTableInput)

[Anonymous]

Hello,
What should i do?

I have installed Talend Function Modules for SAP and I set the parameter "api.z_talend_read_table is true",

but I still get an error when using tSAPTableInput with 800000+ rows and 90+ columns as below

Exception in component tSAPTableInput_1 (SAP)
SAPException@4229bb3f [
errorCode=1
,errorGroup=102
,errorKey=JCO_ERROR_COMMUNICATION
,errorMessage=connection closed without message (CM_NO_DATA_RECEIVED)
,bapiName=/CMT/TLND_TABLE
,tableName=/BIC/B0003822000
]
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:110)
at org.talend.sap.impl.service.SAPTableDataService.getTableData(SAPTableDataService.java:240)
at saptos3.sap_0_1.SAP.tSAPTableInput_1Process(SAP.java:3664)
at saptos3.sap_0_1.SAP.runJobInTOS(SAP.java:4407)
at saptos3.sap_0_1.SAP.main(SAP.java:4189)
[FATAL] 16:19:08 saptos3.sap_0_1.SAP- tSAPTableInput_1 connection closed without message (CM_NO_DATA_RECEIVED)
org.talend.sap.exception.SAPException: connection closed without message (CM_NO_DATA_RECEIVED)
at org.talend.sap.exception.SAPException$Builder.<init>(SAPException.java:274) ~[sap-api-7.3.1-6.0.0.jar:?]
at org.talend.sap.exception.SAPException$Builder.<init>(SAPException.java:269) ~[sap-api-7.3.1-6.0.0.jar:?]
at org.talend.sap.exception.SAPException.newBuilder(SAPException.java:74) ~[sap-api-7.3.1-6.0.0.jar:?]
at org.talend.sap.impl.SAPUtil.createExceptionBuilder(SAPUtil.java:110) ~[sap-impl-7.3.1-6.0.0.jar:?]
at org.talend.sap.impl.service.SAPTableDataService.getTableData(SAPTableDataService.java:240) ~[sap-impl-7.3.1-6.0.0.jar:?]
at saptos3.sap_0_1.SAP.tSAPTableInput_1Process(SAP.java:3664) [classes/:?]
at saptos3.sap_0_1.SAP.runJobInTOS(SAP.java:4407) [classes/:?]
at saptos3.sap_0_1.SAP.main(SAP.java:4189) [classes/:?]

Thanks

[mwinkler]

Looks like you try to extract data from BW System. Maybe you can try to partitionize the data by using a filter on a field and call the component tSAPTableInput per filter value in a loop. Depending on the SAP System Configuration 800.000 rows might be to much to extract it once. Or try first to get e.g. 25.000 rows by using a specific filter condition.

Otherwise you could ask the SAP Admin-Team to help to analyze this error.

[Anonymous]

hi mwinker,
Thanks for your advice
I have partitioned the data as you said.
and then I get an error like this:

Exception in component tSAPTableInput_1 (Looping)
SAPException @ 5ba3f27a [
    errorCode = 1
   , errorGroup = 104
   , errorKey = JCO_ERROR_SYSTEM_FAILURE
   , errorMessage = Unable to fulfill request for 2650 bytes of memory space.
   , errorMessageText =
   , bapiName = / CMT / TLND_TABLE
   , tableName = / BIC / B0003822000
]

[mwinkler]

Could you please test with a fixed filter to check whether you are able to extract 10.000 rows, 20.000 rows, 50.000 rows?

If a batch has less than 800.000 it should be feasible. (will take some time). Otherwise the RFC System Parameter are set so restrictive and allows smaller
data transfers only.

[Anonymous]

hi mwinker,

I tried what you suggested.
when it reaches the record to 1.5 million to extract an error occurs as below

Exception in component tSAPTableInput_1 (Looping)
SAPException@1e04fa0a [
errorCode=1
,errorGroup=104
,errorKey=JCO_ERROR_SYSTEM_FAILURE
,errorMessage=Unable to fulfil request for 2650 bytes of memory space.
,errorMessageText=
,bapiName=/CMT/TLND_TABLE
,tableName=/BIC/B0003822000
]

Please help.

Thanks

[sam473]

me to facing same error how u approached to solve please help me