OBIEE 11g Dashboard Prompt Drop Down Displays The Error - Failed to load(Invalid JSON string

(Doc ID 2193021.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


Dashboard prompts drop down are throwing the following error -

"Failed to load(Invalid JSON string: {"msg":"Odbc driver returned an error (SQLExecDirectW).", "linked":[{"msg":"State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.\n[nQSError: 43113] Message returned from OBIS.\n[nQSError: 43119] Query Failed: \n[nQSError: 59140] The evaluation of the index 0 expression on row count -1 failed.\n[nQSError: 59015] The requested column INVTR_MOVE_CD_DSC does not exist in this table.\n (HY000)", "linked":[ null]},{"msg":"SQL Issued: SELECT \"Inventory Movement\".\"Move Description\" saw_0 FROM \"V2i\" ORDER BY saw_0\r\nFETCH FIRST 65001 ROWS ONLY\r\n", "linked":[ null]}, null]}) "

The prompts were working fine in and after the upgrade to, few of the prompts are throwing these errors.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms