Exalytics: OBIEE Error: [nQSError: 46008] Internal error: File server/Query/Optimizer/ServiceInterfaceMgr/SIMDB/Src/SQOIMDXGeneratorHyperion.cpp, line 2015. (HY000) When The Datasource Is Essbase and Aggregation Rule Is Default In Pivot Tables (Doc ID 2146411.1)

Last updated on JUNE 06, 2016

Applies to:

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

Symptoms

When using Essbase as a data source, the report correctly displays the data in a Table View. However, in a Pivot Table View, the following error is returned, when the Time dimension is removed from the layout:

Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 46008] Internal error: File server/Query/Optimizer/ServiceInterfaceMgr/SIMDB/Src/SQOIMDXGeneratorHyperion.cpp, line 2015. (HY000)

This error message occurs when any layout change is made that requires the data to be aggregated, i.e. aggregate monthly data.

Cause

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