Part of the query on u_sam_incident has been ignored because of read security rules on u_sam_incident.account

[sathishsk]

Hi All,

I am getting below error when an end user tries to query the list view on service portal, but when he tries to access the list view on itil view, he is able to see the list of records.

ERROR MSG: "Part of the query on u_sam_incident has been ignored because of read security rules on u_sam_incident.account."

I have created a custom table called SAM-Incident(u_sam_incident) parent table is CASE table.

There are only 4 ACLs created for the custom table(create,delete,read and write) and this user has the associated role.

Here are the screenshot for the same.

1.
 

2.

3. Same user can see records as below.

Please let me know where do I need to check for resolving this error message?

Thanks & Regards,
Sathish

[Khozema Attar1]

Hello,

You can try creating a read acl on your table with no roles mentioned and see if it resolves your issue.

Mark helpful/correct if it helps.

Regards,

Khozema

[esioson]

Hi SatishSK:

With the upgrade from Kingston to either London or Madrid, something changed in the way Security ACL's are evaluated so that, at least to get past this, you will need to create an additional ACL that will allow for access.

So, in your case, your custom table is named u_sam_incident.  Try adding a new ACL at the record level for u_sam_incident without any field reference, just select (none) on the field side without any role(s) assigned to it.  Hopefully, you have other ACLs already in place at the field level to secure whatever it is you don't want other users to be able to do unless they are in a specific role.  This should get you past this error.  I ran into this same issue and was able to get past it by adding new ACLs similar to what I stated above.  But, you also have to be careful that the rest of the data is still secure based upon how you wish for it to show.

Good luck!

- E

[Michaela3]

Hi, I'm facing the same issue, how did you solve this? Thanks!