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
Last updated on JANUARY 02, 2018
Applies to:Business Intelligence Server Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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 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.
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