ACL error on Scheduled reports

[sujan0119]

Users are getting the below error message on scheduled reports  but they are able to edit and save the changes on the scheduled reports.

Part of the query on par_coreui_migration_bridge_sysauto has been ignored because of insufficient access for 'query_match' operation on par_coreui_migration_bridge_sysauto.sysauto_report

[Bert_c1]

Try: KB1882675

There's a fix there:

Issue

When trying to build Platform Analytics reports or view data visualizations this error message appears:

Part of the query on sys_dictionary has been ignored because of insufficient access for the 'query_match' operation on sys_dictionary.display 

Release

All

Resolution

Create the following system property to prevent the errors from popping up:

Name: glide.db.encoded_query.field_acl_error_msg

Type: true | false

Value: false

[Jonathan Berna1]

I would not suggest suppressing the error message, as that is a global setting and will suppress them all when you do need to know where there are disconnects in the ServiceNow support supplied ACL updates.

For this particular scenario, you will want to update the existing READ ACL for par_coreui_migration_bridge_sysauto.  Our OOB ACL only include admin level roles for this table, which included report_admin. We did not want hand out report_admin to everyone, so include the report_scheduler into the ACL so that it would allow the 'can read' check to pass and not throw an error.  

This allow our user who was previously allowed to handled report scheduling to continue with that process without an unnecessary elevation to report_admin.