My Oracle Support Banner

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


To view full details, 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 a vibrant support community of peers and Oracle experts.