SAP Knowledge Base Article - Public

2493002 - 42029 invalid language specified in JSON


Execute a HANA view on Analysis for Office and receive a warning message “42029 invalid language specified in JSON”


  • Analysis for Office
  • Hana 

Reproducing the Issue

Execute a HANA view on Analysis for Office and pop ups a warning message "Invalid language specified in JSON. : Invalid language"


This message appears in case the user try to login to the system without explicitly entering a language token (e.g. EN) in Analysis Office login screen.


Enter the language by pressing the "Options" button on the Analysis for Office login dialog and entering the token into the "Language" field.

Each subsequent login the same language will be used by default.


Invalid, language, specified, JSON, 42029  , KBA , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions