Patterns fails with "Identification Engine: Discovery status is FAILURE, Discovery using patterns could not be executed due to missing pattern xxxxxxx" - Support and Troubleshooting

Patterns fails with "Identification Engine: Discovery status is FAILURE, Discovery using patterns could not be executed due to missing pattern xxxxxxx" Issue The pattern is failing with the below error:

Identification Engine: Discovery status is FAILURE, Discovery using patterns could not be executed due to missing pattern xxxxxxx. Synchronize the pattern with the Mid Servers and try again. Cause The MID server is unable to Synchronize the pattern as the read ACL on the 'sa_pattern' does not allow the MID server user to read the table. Check if there are any Custom ACLs on sa_pattern table.

Mid Server logs :

2023-03-27 10:24:39 (830) File sync worker: sa_pattern Starting file synchronization: sa_pattern 2023-03-27 10:24:39 (830) FileSync:sa_pattern WARNING *** WARNING *** Could not get file sync snapshot because: Error: user not authorized to read synchronization target table: sa_pattern 2023-03-27 10:24:39 (830) FileSync:sa_pattern Finishing file synchronization: sa_pattern 2023-03-27 10:24:39 (830) FileSync:sa_pattern Setting countdown to 300 seconds in com.service_now.mid.filesync.NdlFileSyncer Below is the Link to ACLs:

https:// .service-now.com/nav_to.do?uri=%2Fsys_security_acl_list.do%3Fsysparm_query%3Dname%253Dsa_pattern%26sysparm_first_row%3D1%26sysparm_view%3D Resolution Add the missing roles for MID Server users which are defined for the READ ACL on the sa_pattern table or revert to using OOTB ACLs