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.