Symantec Endpoint Protection Manager (SEPM) replication is failing in the environment. Checking replication-0.log the following warning is logged:
2022-07-18 16:03:41.399 THREAD 130 WARNING: ReplicationTask>> replicate: Unable to fetch changed data from remote site [Site SITENAME]: Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.
Indexes need to be rebuilt.
To resolve this issue rebuild indexes in the SEPM database.