"Part of the query...." message when loading an incident.

[Community Alums]

I have a user receiving this message at the top when loading an incident:

"Part of the query on change_request has been ignored because of read security rules on change_request_active".

This incident has no association to a change request. I impersonated another user with similar groups and roles and I am not able to replicate. Has anyone experienced this message?

[AnirudhKumar]

It's ACLs that are causing this.

This might be because the ACL that provides Read Access to Change request fields checks for Active change requests. And since your incident has the Change Request field blank, system has trouble evaluating for blank.active

Check if the related ACL was modified recently... 

[Sandeep Rajput · Accepted solution]

@Community Alums This message shows up for those users who do not have field level access to columns of a table due to ACLs. You can either grant the field level ACL to the user or set the following property to hide the message.

Name : glide.db.encoded_query.field_acl_error_msg
Type : true | false
Value: false

Source: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0717961