Microsoft KB Archive/920272

= Error message when you call the Pull method of an RDA object: &quot;duplicate value cannot be inserted into a unique index. [Table name = __sysRDASubscriptions, Constraint name = c_LocalTableName]&quot; =

Article ID: 920272

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Compact Edition

-



Bug #: 11431 (SSCE)



SYMPTOMS
Consider the following scenario. You call the Pull method of an RDA (Remote Data Access) object to download data from a remote Microsoft SQL Server database. You store that data in a single table in a local Microsoft SQL Server 2005 Mobile Edition (SQL Server Mobile Edition) database. In this scenario, you may receive the following error message:

duplicate value cannot be inserted into a unique index. [Table name = __sysRDASubscriptions, Constraint name = c_LocalTableName]

This problem may occur when the RDA_TRACKOPTION parameter is set to TRACKINGON or TRACKINGONWITHINDEXES.

Note The RDA_TRACKOPTION parameter is a parameter of the Pull method.



CAUSE
This problem occurs because the corresponding records in the _SysRDASubscriptions system table are not deleted when you drop the last RDA pull table.



WORKAROUND
To work around this problem, move the .exe program file to the folder where the SQL Server Mobile Edition DLLs are installed. By default, this folder is the C:\Windows folder.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.This problem was fixed in SQL Server 2005 Compact Edition.

