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)
SYMPTOMSConsider 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. CAUSEThis problem occurs because the corresponding records in the _SysRDASubscriptions system table are not deleted when you drop the last RDA pull table.WORKAROUNDTo 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.STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.REFERENCESFor more information about the RDA_TRACKOPTION parameter, visit the following Microsoft Developer Network (MSDN) Web site:
Modification Type: | Minor | Last Reviewed: | 7/25/2006 |
---|
Keywords: | kbExpertiseAdvanced kbtshoot kbprb KB920272 kbAudDeveloper kbAudITPRO |
---|
|