My Oracle Support Banner

OBIEE 12c: Essbase With More Than 20 Measures Gives Error NQSError: 46008 Internal Error: SQOIGeneratorBuiltIn.cpp (Doc ID 2587325.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.181016 and later
Information in this document applies to any platform.

Symptoms

On Oracle Business Intelligence Enterprise Edition, OBIEE 12.2.1.4.0 version

OBIEE environment won't work with OBIEE reports based on Essbase and federated relational data, when working with more than 21 measures.
In the log files noticed the below things that the query generator used two different strategies to build to MDX:

  < 20 measures: Individual queries for every measure
  > 20 measures: One single query that extracts all data in one go

   Facts_20: 20 measures and working.
   Facts_21: 21 measures and not working.


Essbase cannot handle the one single MDX query. And below error can be found in obis1disgnostics.log.




 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.