Endpoint Protection Manager Replication failure - Unable to fetch changed data from remote site

Products

• Endpoint Protection

Issue/Introduction

Symantec Endpoint Protection Manager (SEPM) replication fails with the following error:

"Unable to fetch changed data from remote site [<SEPM Site>]: 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.

Environment

Release : 14.3 RU1

Cause

This issue could be caused by missing or highly fragmented SEPM indexes.

Resolution

For the health and performance of the database, it is recommended to routinely run database maintenance tasks.  Rebuilding the indexes on a regular basis helps reduce index fragmentation.  

If this replication issue is caused by high index fragmentation, the indexes will need to be rebuilt.

These tasks can be manually run or scheduled from the SEPM or within SQL.  For steps to perform these actions in the SEPM, reference the following article:

Scheduling automatic database maintenance tasks