Symptom
- The system is connected to the remote source with the ExcelAdapter from the agent machine, the target SAP HANA is from a HEC system, when previewing data on the virtual table, sometimes it will time out with the error:
- Error: "Could not open “***” ERROR: XMLhttpRequest failed with the status code was ‘500’"
- Sometimes for a success execution, it will return the results in 1 seconds, the excel file is small with only a few records.
- DP server trace with error
"NetworkChannelCompletion.cpp(00518) : [e44f1a920b1883b,<HANA IP Address>:28812,<Agent IP Address>:5050,SDI,0] NetworkChannelCompletionThread #3 {<NetworkChannel>={<NetworkChannelBase>={this=139894087350808, fd=30, refCnt=1, idx=3, local=<HANA IP Address>/28812_tcp, remote=<Agent IP Address>/5050_tcp, state=Connected, pending=[r---]}}}: Error in asynchronous stream event: exception 1: no.2110001 (Basis/IO/Stream/impl/NetworkChannelCompletion.cpp:444) TID: 20014
Generic stream error: getsockopt, Event=EPOLLERR - , rc=110: Connection timed out;"
Read more...
Environment
SAP HANA Smart Data Integration
Product
SAP HANA smart data integration 2.0
Keywords
SAP HANA, TCP connection, SAP HANA, smart data integration, SDI , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , XX-SER-MCC , Mission Control Center - Knowledge Management , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.