OBIEE 10g / 11g - Filter Based on Direct Database Request (Doc ID 1991117.1)

Last updated on MARCH 26, 2015

Applies to:

Business Intelligence Server Enterprise Edition - Version 10.1.3.4.2 [2405] to 11.1.1.7.150120 [Release 10g to 11g]
Information in this document applies to any platform.

Symptoms

When you try to filter a column based on another request which is a direct database request, then an error message appears:

View Display Error

Error getting drill information: SELECT "Offices"."D1 Office" saw_0, "Base Facts"."1- Revenue" saw_1, "More Office Objects"."D1k Office Key" saw_2 FROM "A - Sample Sales" WHERE "More Office Objects"."D1k Office Key" IN (SELECT saw_0 FROM (EXECUTE PHYSICAL CONNECTION POOL "Sample Relational Connection" select to_char(OFFICE_KEY) from SAMP_OFFICES_D where OFFICE_KEY < 10;) nqw_1 )
 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.socketrpcserver, 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: 27004] Unresolved table: "EXECUTE". (HY000)
SQL Issued: {call NQSGetLevelDrillability('SELECT "Offices"."D1 Office" saw_0, "Base Facts"."1- Revenue" saw_1, "More Office Objects"."D1k Office Key" saw_2 FROM "A - Sample Sales" WHERE "More Office Objects"."D1k Office Key" IN (SELECT saw_0 FROM (EXECUTE PHYSICAL CONNECTION POOL "Sample Relational Connection" select to_char(OFFICE_KEY) from SAMP_OFFICES_D where OFFICE_KEY < 10;) nqw_1 )')}

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