OBIEE Error: "[NQSERROR: 42015] Cannot Function Ship the Following Expression: AggrExternal" After Patchset Upate from 11.1.1.3 to 11.1.1.5

(Doc ID 1352471.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

When running a report with a measure from Essbase database using a 'case when' formula, it generates the following runtime error:
"[nQSError: 42015] Cannot function ship the following expression: AggrExternal"


Reproducible steps
1. Create a report using ASOSample > Transaction Type and select column "Gen2, Transaction Type"

2. Add the same column "Gen2, Transaction Type" column and then change its formula to:
case when "Transaction Type"."Gen2,Transaction Type" = 'Sale' then 'Sales' else 'Sales End' end

3. Run the report to check that it is working

4. Add the 'Sample - measure' to the report

5. Run the report and you get the following error:
"View Display Error
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: AggrExternal(Sample.Sample - measure by [ Sample.Gen2,Transaction Type, Sample.Gen2,Transaction Type -
Memnor, Sample.Gen2,Transaction Type - Member Key, case when Sample.Gen2,Transaction Type = 'Sale' then 'SALES' else 'Sales End' end ] ). (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='USD';SELECT 0 s_0, "ASOsamp"."Transaction Type"."Gen2,Transaction Type" s_1, case when "ASOsamp"."Transaction
Type"."Gen2,Transaction Type" ='Sale' then 'Sales' else 'Sales End' end s_2, SORTKEY("ASOsamp"."Transaction Type"."Gen2,Transaction Type") s_3, "ASOsamp"."Sample"."Sample - measure"
s_4 FROM "ASOsamp" WHERE ("ASOsamp"."Transaction Type"."Gen1,Transaction Type" = 'Transaction Type')"


Changes

Issue reproduced in 11.1.1.5
The same report works fine in OBI 11.1.1.3

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