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