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 APRIL 17, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.