FIX: Merge Non-Convergence for SQL Server CE Subscriber (315758)

SYMPTOMS

Changes made to some articles on a Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) subscriber may not be applied to the publisher (a problem that is also called non-convergence). This may occur if the publication contains articles that are not joined to other articles by merge join filters and the articles have no PRIMARY KEY or FOREIGN KEY relationships to other articles that are involved in join filters.

This problem is specific to the processing of SQL Server 2000 Windows CE Edition merge replication subscribers; it does not occur for subscribers that are using other editions of SQL Server.

CAUSE

SQL Server CE expects articles to be processed in a specific order. An optimization exists where a group of articles that are not involved in join filters and that do not have Declarative Referential Integrity (DRI) with any other articles involved in join filters can be processed ahead of their nickname order. This is a valid optimization for non-SQL Server CE merge subscribers, but is not valid for SQL Server CE subscribers. The fix is to not use this optimization in situations where it is not permitted.

For additional information about merge replication article processing order, click the article number below to view the article in the Microsoft Knowledge Base:

307356 INF: Understanding Merge Replication Article Processing Order

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How To Obtain the Latest SQL Server 2000 Service Pack

NOTE: The following hotfix was created before the release of Microsoft SQL Server 2000 Service Pack 3.

The English version of this fix should have the following file attributes or later:

   Build       File name     Description
   ------------------------------------------

   8.00.0560   Replrec.dll   SP2-based hotfix