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

LyneC
Tera Expert

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

Screenshot 2024-09-24 at 8.53.59 AM.png

 

1 ACCEPTED SOLUTION

LyneC
Tera Expert

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

17 REPLIES 17

LyneC
Tera Expert

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.

 

amalabraham2743
Tera Contributor

Hi LyneC,

Were you able to resolve your issue with the work around provided? I could not find the mentioned property in our instance.

Thanks,
Amal

No actually after using the solution in the article all that did was hide the error. I was looking more for a reason why or a better fix. 

josephd01
Mega Guru

Anyone found the cause of this and how to fix it rather than hiding?

lsbammes
Tera Contributor

Not really a good "Solve" when this issue is being hidden - anyone else been able to identify why this is happening?   We are on Xanadu Patch 3 - this is a new issue on some of our catalog pages.