- You install Microsoft SQL Server Compact 3.5 on a computer.
- You create a subscriber in SQL Server Compact 3.5.
- You download many rows from a merge publication to a database while the publisher synchronizes with the subscriber. The rows contain many articles and constraints.
Native Error = 0, HRESULT = -2147217873, Error Message: A specified value violated the integrity constraints for a column or table.
When many rows for download are in a pending state, SQL Compact Client Agent calls a retry method that uses an invalid exchange ID. Therefore, the issue that is mentioned in the "Symptoms" section occurs.
For more information about how to obtain cumulative update package 5 for SQL Server Compact 3.5 SP2, click the following article number to view the article in the Microsoft Knowledge Base:
Article ID: 2585082 - Last Review: Aug 17, 2011 - Revision: 1