OBIEE 11.1.1.9: nQSError: 43119 Occurs when EVALUATE Function and Server Complex Aggregate are Used Together (Doc ID 2207184.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 to 11.1.1.9.161018 [Release 11g]
Information in this document applies to any platform.

Symptoms

On : 11.1.1.9.0 version

In Analysis, create a simple report and edit one of the columns formula to use EVALUATE function.

Like below:

In the pivot view, when add Totals to Rows column and set the measures columns Aggregation Rule to 'Server Complex Aggregate' , the below error occurs.

Odbc driver returned an error (SQLExecDirectW).
Error Details
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: 42015] Cannot function ship the following expression: EVALUATE. (HY000)

 

We found similar Bug19599154,
And applied patch 19599154 against BIEE: 11.1.1.7.160719, But the error still occurs.
Patch 19599154 seems not be appropriate for this issue.

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