My Oracle Support Banner

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

Last updated on AUGUST 30, 2021

Applies to:

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


On : 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
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:, But the error still occurs.
Patch 19599154 seems not be appropriate for this issue.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.