We have a Merge Replication system between SQL 2008 R2 Enterprise and Express edition. 2 servers are on the same domain, and everything works fine by sql replication.
When we want to synchronize by web synchronization, we get an error like below
"The merge process detected a mismatch while evaluating the subscriber partition validation expression. The problem can be resolved by
reinitializing the subscription." (we did reinitializing but same error again!)
and also this another error message in same situation
" - The common generation watermark is invalid at this replica since it does not exist or metadata for changes not yet propagated may have been cleaned up.
- The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be lost leading to non-convergence. This could be due to the subscriber not having synchronized within the retention
period, or because of one of the replicas being restored to a backup older than retention period, or because of the publisher performing more aggressive cleanup on articles of type download-only and articles with partition_options = 3."
View Complete Post