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



The information in this article applies to:

  • Microsoft SQL Server 2005 Mobile 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) 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 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 "Applies to" section.

REFERENCES

For more information about the RDA_TRACKOPTION parameter, visit the following Microsoft Developer Network (MSDN) Web site:

Modification Type:MinorLast Reviewed:7/25/2006
Keywords:kbExpertiseAdvanced kbtshoot kbprb KB920272 kbAudDeveloper kbAudITPRO