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 and later
Oracle Exalytics Software - Version and later
Information in this document applies to any platform.


When running a report on an Exalytics server with OBIEE version, the report fails with error.  The report is using an Oracle 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 environment. 

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


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