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 SEPTEMBER 06, 2024

Applies to:

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

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