Article ID: 2585082 - View products that this article applies to.
Consider the following scenario:
Note This issue occurs in both 32-bit operating system and 64-bit operating system.
Native Error = 0, HRESULT = -2147217873, Error Message: A specified value violated the integrity constraints for a column or table.
This issue occurs because an invalid exchange ID is used.
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.
The hotfix that resolves this issue is included in cumulative update package 5 for SQL Server Compact 3.5 Service Pack 2 (SP2).
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:
(http://support.microsoft.com/kb/2553608/ )Cumulative Update 5 for SQL Server Compact 3.5 Service Pack 2