SAP Knowledge Base Article - Public

3429953 - Query terminates with Error Code = 34023 and Error Text = Instantiation of calculation model failed; Failed to parse JSON

Symptom

- A BEx query terminates with Error Code = 34023 and Error Text = Instantiation of calculation model failed; Failed to parse JSON 

Environment

- SAP HANA 1.0, 2.0

- BW 7.50 or higher

- BW4/HANA 1.0 or higher

Reproducing the Issue

Run the BEx query

Cause

There was a hint being added to the InfoProvider as mentioned in the note: 2596555 - HANA Database-Hints for InfoProvider Access in a BW Query

From indexserver trace,  see errors like: CalcEngine       ceController.cpp(01276) : Failed to parse JSON: {"disabled_patterns": "50"} 

The added hint value {"disabled_patterns": "50"} was followed by some special characters, which caused the JSON parse error. 

Resolution

Remove the hint entry in the RSDRC_DB_HINTS view, re-add it again and make sure no trailing characters at the end of hint name and hint values for the new entry. 

Keywords

KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , Problem

Product

SAP Analytics Cloud 1.0