Meaning of error message: Part of the query on sys_dictionary has been ignored

LyneC · ‎09-23-2024

What would be the cause of the following error message when I try to create a new list - simple visualisation.

LyneC · ‎10-02-2024

Hi everyone,

We received the following solution for this issue from ServiceNow support:

Issue:
PA List Visualisation Error - Part of query on sys_dictionary has been ignoredInvestigation Summary:
After investigating, I have found that the following KB0717961 >>
- https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0717961
is mentioning this is expected behaviour "The system does not filter to use columns that a user does not have access to. This message simply lets us know why the filter isn't what it is expected to be."The workaround for this is by setting this property:
Name : glide.db.encoded_query.field_acl_error_msg
Type : true | false
Value: falseI
Solution Proposed:
Please follow the Workaround in the KB0717961 mentioned above and set system property "glide.db.encoded_query.field_acl_error_msg" to false to resolve the issue.

View solution in original post

Shawn34 · ‎09-23-2024

When did you start getting this error message? We are experiencing similar issues.

LyneC · ‎09-23-2024

have been seeing it for a couple months when we started creating visualisations and dashboards in platform analytics.

jacobspacek · ‎10-01-2024

This issue also started to appear for us with Platform Analytics when using List Visuals.

Ravi Chandra_K · ‎09-23-2024

Hello @LyneC ,

Can you try checking if there any Query BRs on sys_dictionary table which is not allowing the access

Please mark the answer as helpful and correct if helped.

Kind Regards,

Ravi Chandra