OBIEE 11g: Error: "[nQSError: 43113] The post returned from OBIS [nQSError: 42015] Cannot function ship the following expression: AggrExternal" When Run a Report Against Essbase (Doc ID 1382839.1)

Last updated on JANUARY 23, 2017

Applies to:

Business Intelligence Answers Option - Version 11.1.1.5.0 [1308] and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.
***Checked for relevance on 14-May-2013***

Symptoms

You have Essbase database with a cube of 13 dimensions.  When you run a report in Answers against it, using 11 or more dimensions, you get the following error:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] The post returned from OBIS [nQSError: 42015] Cannot function ship the following expression: AggrExternal(Main.Product by [ Main.Gen4, Customer, Main.Gen4, Asset - Memnor, Main.Gen4, Asset - Member Key...

If you run a report with 10 dimensions and 1 measure, it works correctly.  This problem does not depend on tuned filters or selection order of measure and dimensions.

You also get this error when you run a report against a different Essbase cube, again with more than 11 dimensions.



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