Time Calculated Members Causes The Error Message '[nQSError: 46008] Internal Error: File Server/Query/Optimizer/ServiceInterfaceMgr/SIMDB/Src/SQOIMDX' When Using Essbase BSO Cube

(Doc ID 1962402.1)

Last updated on FEBRUARY 28, 2017

Applies to:

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


After upgrading to OBIEE, the following error is received with a custom report :

Odbc driver returned an error (SQLExecDirectW). Error Details
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 1919. (HY000)
SQL Issued: SELECT s_0, s_1, s_2, s_3, s_4, s_5, s_6, s_7, s_8, s_9, s_10, s_11, s_12, s_13, s_14, s_15, s_16, s_17, s_18, s_19, s_20, s_21, s_22, s_23, s_24, s_25, s_26, s_27, s_28, s_29, s_30, s_31, s_32, s_33, s_34, s_35, s_36, s_37, s_38, s_39, s_40, s_41 FROM ( SELECT 0 s_0, "XYZ"."CATE..)


The report worked fine prior to the upgrade.


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