OBIEE 11g: Answers Report With Essbase Datasource Gives Error: "[nQSError: 46008] Internal error SQOIGeneratorBuiltIn.cpp" (Doc ID 2054832.1)

Last updated on JANUARY 30, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.141014 to 11.1.1.7.151020 [Release 11g]
Information in this document applies to any platform.

Symptoms

When running a report with Essbase as the datasource, the following error occurs:

"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\Src\SQOIGeneratorBuiltIn.cpp, line 770. (HY000)"
--------------x--------------

If a TRIM funcion is added to the column "Account"."Gen6,Account" on the Answers report, the report works fine.

TRIM("Account"."Gen6,Account")



Changes

This report worked before. The only change that has been done, is the re-import of an Essbase cube to the OBIEE repository and in the Essbase cube the Custom4 dimension has changed. Also some dimension members in the Account dimension in the Essbase cube have moved from one hierarchy level to another.

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