OBIEE 11g: Answers Report With Essbase Datasource Gives Error: “[nQSError: 46008] Internal error SQOIGeneratorBuiltIn.cpp”


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”)

 

 

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.

Steps:

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.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s