OBIEE 11g: Error: "Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P...[nQSError: 43119] Query Failed: Essbase ANCESTOR_NAMES property is empty" when Drilling in a Hierarchy (Doc ID 1603282.1)

Last updated on JANUARY 30, 2017

Applies to:

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.

Symptoms

You are using OBIEE 11g with Essbase as the data source.  When you drill in a report containing an unbalanced hierarchy to the lowest level of that hierarchy, you get the following error:

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed:
Essbase ANCESTOR_NAMES property is empty. (HY000)
SQL Issued: SELECT 0 s_0, "Sales Insight - North America Star"."- PBA"."Continued Operations" s_1, "Sales Insight - North America Star"."- PBA"."Level 1 PBA Code" s_2, "Sales Insight - North America Star"."- PBA"."Sub Continued operations" s_3
FROM
"Sales Insight - North America Star"
WHERE (("- PBA"."Level 1 PBA
Code" = 'PAA') AND ("- PBA"."Continued Operations" = '960_Local GAAP adjustments'))
FETCH FIRST 2000001 ROWS ONLY

 

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