My Oracle Support Banner

12c Drilling Into Hierarchy Produces Error: [nQSError: 14061] Specified drill-down selection does not exist (Doc ID 2191004.1)

Last updated on APRIL 25, 2018

Applies to:

Business Intelligence Reporting and Publishing - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Environment
===========
OBIEE 12.2.1.1.0

Drilling on a hierarchy column produces error. This same RPD and report worked fine in 11.1.1.7.

Error
=====
Detail error description :


Error generating view. Process action error.
Error Details
Error Codes: OAMP2OPY:E4BHSJTH:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
An error occurred while trying to generate drill down query.
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 14061. [nQSError: 14061] Specified drill-down selection does not exist. (HY000)




Drill on specific hierarchical column displays error. However another dashboard, using same column does not have error and can drill down. In each case the column was in the middle of many displayed columns

Changes

 

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!

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