Oracle Exalytics: Query Fails with Error "Cannot function ship the following expression: Evaluate_Aggr ..."; Same Query Works on Standalone OBIEE Server (Doc ID 1994669.1)

Last updated on MARCH 30, 2015

Applies to:

Business Intelligence Server Administrator - Version 11.1.1.7.131017 and later
Oracle Exalytics Software - Version 1.0.0.3.0 and later
Information in this document applies to any platform.

Symptoms

When running a report on an Exalytics server with OBIEE version 11.1.1.7.131017, the report fails with error.  The report is using an Oracle 11.2.0.4.0 database source and the EVALUATE_AGGR function.
The error is:

[2015-03-05T08:41:16.000-06:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00548iFSA4376ER6uZ7EEH00023T0002E0,0:1:1:1:6] [tid: 46a9b940] [nQSError: 42015] Cannot function ship the following expression: Evaluate_Aggr( CORR(%1,%2),([ D901.c1, (D913.c1 + D912.c1 + D911.c1 + D910.c1 + D909.c1 + D908.c1 + D907.c1 + D906.c1 + D905.c1 + D904.c1 + D903.c1 + D902.c1) / D913.c2] by [ D901.c2] )). [[
[nQSError: 43119] Query Failed:

The same RPD and report complete successfully when run on a non-Exalytics OBIEE 11.1.1.7.131017 environment. 

This problem may occur on any Exalytics server running OBIEE patch versions from 11.1.1.7.131017 through OBIEE 11.1.1.7.150120.

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