Upgraded OBIEE 11g Dashboard Fails With Errors: "OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P ... [nQSError: 15002] Missing navigation space for subject area Core..."

(Doc ID 1496848.1)

Last updated on OCTOBER 05, 2017

Applies to:

Oracle Exalytics Software - Version to [Release 1.0 to 2.0]
Business Intelligence Suite Enterprise Edition - Version to [Release 11g]
Information in this document applies to any platform.
Checked for relevance 05-APR-2016.


Upgraded Oracle Business Intelligence Enterprise Edition (OBIEE) to, (or and ran the consistency check in the OBIEE  Admin Tool.

After completing these steps, the RPD was migrated to an Oracle Exalytics server and now certain dashboards are failing with error:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 15002] Missing navigation space for subject area Core. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT VALUEOF("LAST_ETL_DATETIME") FROM "Project - Revenue"')}


When the RPD is opened in the Admin tool again, the logical column ("LAST_ETL_DATETIME") is missing from the logical table ("Project - Revenue"') in the Core subject area.

If the consistency check is run again, another column seems to lose its source in the RPD file.  Once the source is removed, all dashboards and analyses that use this table/column encounter errors like those listed above.

This problem occurred in an Oracle Exalytics server environment, but can occur in any upgraded OBIEE or environment.


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