Showing error Part of the query on sys_pd_activity_context has been ignored because of read security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2024 09:15 AM
Hi
I am facing this issue once I open health and safety workspace.
How to fix this error .
@Allen Andreas @Pradeep Sharma @Community Alums @Anurag Tripathi @Mark Roethof

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2024 07:45 PM - edited 07-28-2024 07:46 PM
This would most likely be because of "read" ACL on the table: sys_pd_activity_context for the related field(s). You'd want to review your "read" ACLs for this table and field(s) in question and ensure that whomever you're viewing this as has the appropriate permission/role to pass it. Currently, it looks like they don't so it's ignoring some of the query and showing this error message.
See similar post here: https://www.servicenow.com/community/csm-forum/part-of-the-query-has-been-ignored-because-of-read-se...
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2024 12:52 PM
The error "Part of the query on sys_pd_activity_context has been ignored because of read security" is likely due to a "read" ACL (Access Control List) on the `sys_pd_activity_context` table or its related fields. Review the "read" ACLs for this table and the specific fields in question to ensure that the user viewing this data has the appropriate permissions or roles. The current permissions are insufficient, causing the query to be partially ignored and generating this error message.