My Oracle Support Banner

OBIEE When Excluding All Columns from Rows, nQSError: 43119 returns for Pivot View that has Evaluate Function (Doc ID 2198139.1)

Last updated on MARCH 12, 2019

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 exclude all the Rows columns, 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> for BIEE:, But 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.