OBIEE 11g: Drilling In Analysis Containing Descriptor Id Columns Yields Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P

(Doc ID 1392014.1)

Last updated on OCTOBER 09, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.

Symptoms

Drill into an analysis which contains columns that have a Descriptor ID specified. As soon as one such column is present and a drill on any other dimension is attempted, the request SQL issued to the BI server is malformed and throws an error.

Example: Usage Tracking subject area - analysis XML

NOTE: "Query Time"."Month" has "Query Time"."Month Number" set as its descriptor ID column in the RPD!

Running the analysis yields normal results - i.e. the proper query count by month and by group name.

Drilling down on "Group Name" throws the following error:

View Display Error

Error getting drill information: SELECT "Query Time"."Month" saw_0, "Measures"."Query Count" saw_1, "Users"."Group Name" saw_2, "Usage Tracking"."Users"."User Name" saw_3, DESCRIPTOR_IDOF("Usage Tracking"."Query Time"."Month") saw_4 FROM "Usage Tracking" WHERE "Usage Tracking"."Users"."Group Name" = 'weblogic' =
Error Details
Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P
Location: saw.views.evc.activate, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool, saw.threadpool, saw.threads
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near <=>: Syntax error [nQSError: 26012] . (HY000)
SQL Issued: {call NQSGetLevelDrillability('SELECT "Query Time"."Month" saw_0, "Measures"."Query Count" saw_1, "Users"."Group Name" saw_2, "Usage Tracking"."Users"."User Name" saw_3, DESCRIPTOR_IDOF("Usage Tracking"."Query Time"."Month") saw_4 FROM "Usage Tracking" WHERE "Usage Tracking"."Users"."Group Name" = ''weblogic'' = ')}

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