Microsoft KB Archive/315758

= FIX: Merge Non-Convergence for SQL Server CE Subscriber =

Article ID: 315758

Article Last Modified on 6/18/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2000 Windows CE Edition

-



This article was previously published under Q315758



BUG #: 356388 (SHILOH_BUGS)



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
The installer does not install this hotfix correctly on x64-based systems. This installation issue occurs when the following conditions are true:
 * The system uses the Advanced Micro Devices (AMD) AMD64 processor architecture or the Intel Extended Memory 64 Technology (EM64T) processor architecture.

Note This issue does not occur on systems that use the Intel Itanium processor architecture.
 * The system is running a 64-bit version of the Microsoft Windows Server operating system.
 * The system is running a 32-bit version of SQL Server 2000.

We have corrected this installation issue in later builds of SQL Server 2000, starting with version 8.00.2244. When a customer who is running SQL Server 2000 on an x64-based system requests this hotfix, we will provide a build that includes this hotfix and that can be installed correctly on an x64-based system. The build that we provide will be version 8.00.2244 or a later version.

Service pack information
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 NOTE: Because of file dependencies, the most recent hotfix or feature that contains the files may also contain additional files.



STATUS
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000.

This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3.

Additional query words: non-convergence nonconvergence repl

Keywords: kbhotfixserver kbqfe kbsqlserv2000sp3fix kbbug kbfix kbsqlserv2000presp3fix KB315758

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.