"Part of the query...." message when loading a dashboard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-13-2025 01:44 AM - edited 05-13-2025 01:47 AM
I have a user receiving this message when loading a dashboard:
Error Message
Part of the query on u_change_ticketing has been ignored because of insufficient access for 'query_range' operation on u_change_ticketing.u_assigned_to_bpo
Error Message
Part of the query on u_change_ticketing has been ignored because of insufficient access for 'query_range' operation on u_change_ticketing.u_assigned_to_budget_approver
Error Message
Part of the query on u_change_ticketing has been ignored because of insufficient access for 'query_range' operation on u_change_ticketing.u_assigned_to_it
Error Message
Part of the query on u_change_ticketing has been ignored because of insufficient access for 'query_range' operation on u_change_ticketing.u_assigned_to_tma
What would be the cause of the above error message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-13-2025 02:17 AM
Hi @Madhumitha5 ,
The issue here is due to the ACL. Check the ACL in table "u_change_ticketing" the user viewing the dashboard doesn't have the required roles to view the fields "u_assigned_to_tma", "u_assigned_to_it" etc.
Once you have added the role in the ACL these messages wont appear.
Please mark the answer helpful and correct if it helps the issue. Happy scripting 🙂
-Shantanu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-13-2025 02:19 AM
this error comes because user doesn't have proper access control on the fields you are using in your filter or query
check the fields shared in your error and see if any field level READ ACL is blocking
see this KB on how to remove those errors
System throws an error message when any non-admin user clicks on "My Connected Apps" module.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader