My Oracle Support Banner

OBIEE 12c: Error: "[nQSError: 14061] Specified drill-down selection does not exist." When Drilling through Hierarchy (Doc ID 2471618.1)

Last updated on FEBRUARY 17, 2019

Applies to:

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

Symptoms

On Oracle Business Intelligence Enterprise Edition(OBIEE) 12.2.1.3.180116 Version,

  1. The Drill-down functionality does not work after migration from OBIEE 11g while using more than 16 columns in the analysis.
  2. If the number of columns reduced, drill down works as expected.
  3. Tried the solution provided in the following KM document - "Hierarchy Drilling Issues In OBIEE 12.2.1.0.0 and 12.2.1.1.0 Linux (Doc ID 2191004.1)" i.e., applied the patch <Patch 24566569>, still issue persists.
  4. When drilling through hierarchical object in analysis with more than 16 columns, getting the below error.

Error:

View Display Error:

Error generating view. Process action error.

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)

 

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.