Replication is failing at 10 percent.

Products

• Endpoint Protection

Issue/Introduction

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.

Cause

Indexes need to be rebuilt. 

Resolution

To resolve this issue rebuild indexes in the SEPM database.

Additional Information

CRE-6513