My Oracle Support Banner

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

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
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.