SAP Knowledge Base Article - Preview

3380932 - ERROR: "XMLhttp: Request failed with the status code ‘500’" - SAP HANA Smart Data Integration

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.