Security Rules Error Message: Part of the query on task has been ignored because of read security rules on task.ref_u_governance_invoice.u_service_provider_user

[Vasanth Pandia1]

Hi All,

After upgrading to london version, we are getting below error message on the home page for a report:

Part of the query on task has been ignored because of read security rules on task.ref_u_governance_invoice.u_service_provider_user

In Kingston, this error message doesn't appear.

Can someone please let me know what might be the issue and also let us know ".ref_" what does this issue.

Regards,

Vasanth

[VigneshMC]

ref_ implies or refers to a field which are part of child table and not part of parent table . Child table "u_governance_invoice" has an field called "u_service_provider_user" . When you query from task table (parent table )Some read ACL (on child table) on this field restricts the query to be completed .

[Vasanth Pandia1]

Hi Vignesh,

Thanks for your reply.

We have only 1 read acl (u_governance_invoice*) which is present in both london and kingston version. but the issue is happening only in london.

Regards,

Vasanth

[Inactive_User32]

Hi Vasanth,

We are also facing the same issue in the Homepage after the london upgrade "Part of the query on task has been ignored because of read security rules on task.ref_u_termination_task.u_parent_termination"

can you please help me to figure out why this issue occured in London and the solution u got!

Regards,

Manjusha

[Vasanth Pandia1]

Hi Manjusha,

There must be a read ACL on this table and field u_termination_task.u_parent_termination. Once the required role is mapped to the user. the issue should be solved. This is what the fix which we had done.

Please mark correct if you find this is correct solution.

Regards,
Vasanth