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

LyneC · ‎09-23-2024

I get the error every time i try to create a "List" visualisation when using a nowlearning instance and when using 2 different customer instances (vancouver and washingtonDC versions). If it's a Query BR that is causing the issue then it isn't a Query BR that we put in.

mikeroe · ‎09-24-2024

I've also been able to recreate this issue in Xanadu release on my PDI.

LyneC · ‎09-23-2024

i wonder how i can report this as an issue to ServiceNow since its rather easy to reproduce. Perhaps it's already been reported.

steps:

logon as a user with viz_creator role to a new developer instance.

platform analytics-library->Data Visualisation

click on NEW

select type List - simple

and the following will appear:

jacobspacek · ‎09-24-2024

We have also been dealing with this issue, any solutions?

LyneC · ‎09-30-2024

No solution, I am trying to get one of our developers to report it to ServiceNow. The issue is annoying as the visualisation still works and shows the expected data. We just have to close the annoying red boxes each time.