Getting Error on CSM portal

[Unique45]

Hello Community!

We are getting below error in the CSM portal.

Error : Part of the query on sn_customerservice_case has been ignored because of insufficient access for 'query_range' operation on sn_customerservice_case.opened_by error.

Can anyone guide me to resolve this error.

Thanks in advanced!

[Mark Manders]

What are you trying to do? Are you opening a list or a form? Are you clicking on the landing page? It looks like there is a filter condition on the case table that is referencing something you don't have access to, related to the 'opened_by' field, like the error states. Knowing what action you are performing, would help.

[Robbie]

Hi @Unique45,

This is thrown due to an ACL issue. Rather than reinvent the wheel, another community member has both experienced the same issue and advised the solution found below - kudos @SumanthDosapati

However, in case of broken links moving forward, there's the summary and actions:

This error is thrown because there is a 'Read' ACL on sn_customerservice_case table with a role(s) associated to it.

If the user does not have the role specified within the ACL, this error message will be shown.

- Open ACLs and check Read ACLs on sn_customerservice_case table.

- Check for Roles in each ACL and ensure this aligns with the required functionality and ensure the required users have this role.

https://www.servicenow.com/community/csm-forum/part-of-the-query-has-been-ignored-because-of-read-se...

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie

[Unique45]

Hello @Mark Manders ,

When I clicked on 'My list' menu it s showing error

[Mark Manders]

Check on the user and the ACL's related to the case table and especially the 'opened by' field. Maybe you are clicking on it with the snc_internal role, while it is only allowed for the snc_external role, or something like that.