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

Last updated on APRIL 14, 2020

Applies to:

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

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