"Part of the query...." message when loading a dashboard

Madhumitha5
Tera Contributor

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

 

2 REPLIES 2

shantanu_patel8
Mega Guru

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

Ankur Bawiskar
Tera Patron
Tera Patron

@Madhumitha5 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader