OBIEE 11g: Answers Report With Essbase Datasource Gives Error: "[nQSError: 46008] Internal error SQOIGeneratorBuiltIn.cpp"
Last updated on JANUARY 30, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.141014 to 18.104.22.168.151020 [Release 11g]
Information in this document applies to any platform.
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)"
If a TRIM funcion is added to the column "Account"."Gen6,Account" on the Answers report, the report works fine.
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.
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