Time Calculated Members Causes The Error Message '[nQSError: 46008] Internal Error: File Server/Query/Optimizer/ServiceInterfaceMgr/SIMDB/Src/SQOIMDX' When Using Essbase BSO Cube
Last updated on FEBRUARY 28, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.140225 and later
Information in this document applies to any platform.
After upgrading to OBIEE 220.127.116.11.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.
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