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 FEBRUARY 17, 2019
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.0  and later
Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.0  and later
Information in this document applies to any platform.
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)
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