SAP Knowledge Base Article - Preview

3094189 - Error "parse error in json string: error: 0" - SDI OdataAdapter

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

SDI OdataAdapter connect with Mendix Application via remote source.

Product

SAP HANA smart data integration 2.0

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.