My Oracle Support Banner

Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P ; reports error out if having filter on restricted column/ tables (Doc ID 2673578.1)

Last updated on JUNE 05, 2020

Applies to:

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

Symptoms


If a filter is applied on column from a table which has data level security set up, then report is throwing error saying "Unresolved Column"

 

Error getting drill information: SELECT "Products"."Product Number" saw_0,
"Offices"."Office" saw_1 FROM "Sample Sales Lite" WHERE ("Products"."Product
Number" = 5) AND ("Offices"."Office" = 'Montgomery Office')
Error Details
Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A
general error has occurred.
Please have your service administrator review this error. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
Please have your service administrator review this error. (HY000)
State: HY000. Code: 27046. [nQSError: 27046] Inaccessible column:
"Offices"."Office".
Please have your service administrator review this error. (HY000)
SQL Issued: {call NQSGetLevelDrillability('SELECT "Products"."Product Number"
saw_0, "Offices"."Office" saw_1 FROM "Sample Sales Lite" WHERE
("Products"."Product Number" = 5) AND ("Offices"."Office" = ''Montgomery
Office'') ')}

Changes

 Trying to Reports based on a column having restricted access to tables.

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
Changes
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.