SAP Knowledge Base Article - Preview

3094189 - Error "parse error in json string: error: 0" while selecting VT table ODATAAdapter remote source - SAP HANA Smart Data Integration

Symptom

  • When trying to preview the data of a virtual table from an OdataAdapter remote source, get the error like below:
    Could not open <Schema>.<Virtual Table>.
    Error: (dberror)[403]: internal error: Remote execution error JSON error occurred: "parse error in json string: error: 0" for query "<The SELECT query>"
  • The same URL works fine in PosttMan.
  • Errors in the dpserver trace file:
    [24157]\{324792\}[39/-1] 2021-09-01 15:44:19.711634 e JsonFormatParser JsonFormatParser.cpp(00076) : JsonFormatParser::parseStr error: 0
    [24157]\{324792\}[39/-1] 2021-09-01 15:44:19.712498 e JsonFormatParser JsonFormatParser.cpp(00097) : JsonFormatParser::parseStr caught ltt::exception: exception  1: no.2520496  (DPServer/ODataClient/JsonFormatParser.cpp:79) TID: 24157
        JSON error occurred : "parse error in json string : error: 0"
    [24157]\{324792\}[39/-1] 2021-09-01 15:44:19.726515 e JsonFormatParser JsonFormatParser.cpp(00043) : JsonFormatParser::parse caught JsonError: exception  1: no.2520496  (DPServer/ODataClient/JsonFormatParser.cpp:79) TID: 24157
        JSON error occurred : "parse error in json string : error: 0"
    [24157]\{324792\}[39/-1] 2021-09-01 15:44:19.735630 e ODataClient      ODataClient.cpp(01942) : ODataClient::getEntities caught JsonError: exception  1: no.2520496  (DPServer/ODataClient/JsonFormatParser.cpp:79) TID: 24157
        JSON error occurred : "parse error in json string : error: 0"
    [24157]\{324792\}[39/-1] 2021-09-01 15:44:19.735975 e DPFramework      AdapterFactory.cpp(00747) : JSON error occurred : "parse error in json string : error: 0"
  • Errors in the indexserver trace file:
    [2719]\{324792\}[39/-1] 2021-09-01 15:44:19.736530 e DPAdapterManager AdapterManager.cpp(04666) : ::sendMessage: JSON error occurred : "parse error in json string : error: 0"
    [2719]\{324792\}[39/-1] 2021-09-01 15:44:19.736642 e FedTrace         DPAdapterAccess.cpp(02309) : DPAdapterResultSet::Fetch: failed with error: JSON error occurred : "parse error in json string : error: 0"


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

ODATA, JSON, support, request, format, xml , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.