This error commonly arises during the replication of very large tables, indicating that the table contains more records than the internal mechanism can effectively track.
Our REPLICATE command stores extra duplicate checks and Sync keeps a list of primary keys to facilitate these checks. Depending on the size of the tables involved, this side of the replication may overflow, resulting in the above error.
To resolve this issue, you can disable duplicate checks by setting the ‘EnableDuplicateProtection’ property to False in the Job Additional Options, as shown in the following screenshots:
This will help you bypass the error.
Please reach out to [email protected] if this does not resolve the problem for you.
