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.
If you are not dealing with external aggregate, e.g. sum, then you can turn off the db feature QUALIFIED_DATA_REFERENCE_SUPPORTED.In general, it is not supported searching conditions using scalar functions such as substring, unless the search expression is also on the projection.
Turn off (disable) the db feature QUALIFIED_DATA_REFERENCE_SUPPORTED.
1) Open the repository using the Administration Tool. In the Physical Layer, select the ‘Essbase’ database, double click, go to Features tab, and UNCHECK the QUALIFIED_DATA_REFERENCE_SUPPORTED setting.
2) Restart BI Server.
3) Test again the report in OBIEE.