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 11.1.1.7.140225 and later
Information in this document applies to any platform.

Symptoms

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


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 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.

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