OBIEE 11g: Answers Report With Essbase Datasource Gives Error: "[nQSError: 46008] Internal error SQOIGeneratorBuiltIn.cpp"
(Doc ID 2054832.1)
Last updated on MARCH 03, 2019
Applies to:Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.141014 to 220.127.116.11.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document