FIX: You cannot insert rows or upload changes into the SQL Server 2005 Compact Edition subscriber tables after you run the "sp_changemergearticle" stored procedure or you add a new merge publication article when another article has an IDENTITY column

Article translations Article translations
Article ID: 971970 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

Consider the following scenario:
  • You create a merge publication in SQL Server.
  • You add a table article that has an IDENTITY column to the publication.
  • You add a parameterized row filter to the article.
  • You create a SQL Server 2005 Compact Edition subscription to the publication.
  • You synchronize the subscription.
Then you perform one of the following operations:
  • At the publisher, you run the sp_changemergearticle stored procedure to change one of the following properties of the article:
    • processing_order
    • delete_tracking
    • partition_options
  • You add a new article to the publication, and then start the Snapshot Agent.
After you synchronize the subscription, when you try to insert a row into the subscriber table, you encounter one of the following problems:
  • If there is a record in the table that has a value of 1 for the IDENTITY column, you receive the following error message::
    Major Error 0x80040E2F, Minor Error 25016
    ><Insert Statement>
    A duplicate value cannot be inserted into a unique index. [ Table name = <TableName>,Constraint name = <ConstraintName> ]
  • If no records in the table have a value of 1 for the IDENTITY column, you can successfully insert a row into the subscriber table. However, when you synchronize the subscription to upload the change to the publisher, you receive the following error message:
    A subscriber row failed to apply at the publisher. Review the error parameters and the conflict logging tables at the publisher to determine the reason the row failed to apply. [ Table name = <TableName>, Row guid = <GUID> ]
    HRESULT 0x80004005 (28802)

CAUSE

This problem occurs because the table at the subscriber is reseeded to the value of 1 after you perform one of the following operations:
  • At the publisher, you run the sp_changemergearticle stored procedure to change one of the following properties of the article:
    • processing_order
    • delete_tracking
    • partition_options
  • You add a new article to the publication, and then start the Snapshot Agent.
The value of the AUTOINC_SEED column indicates the seed of the IDENTITY column. To check the seed of the IDENTITY column, you run the following statement against the table on the subscriber:
SELECT AUTOINC_MIN, AUTOINC_MAX, AUTOINC_NEXT, AUTOINC_INCREMENT, AUTOINC_SEED
FROM INFORMATION_SCHEMA.COLUMNS
WHERE AUTOINC_MIN IS NOT NULL

RESOLUTION

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, submit a request to Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support
Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

There are no prerequisites for installing this hotfix.

Restart requirement

You do not have to restart the computer after you apply this hotfix.

Hotfix replacement information

This hotfix does not replace a previously released hotfix.

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
For all supported ARMV4i-based versions of Windows CE 5.0
Collapse this tableExpand this table
File nameFile versionFile sizeDateTime
Sqlce30.dev.enu.wce5.armv4i.cabNot Applicable324,83416-Jun-200912:50
Sqlce30.repl.wce5.armv4i.cabNot Applicable758,30616-Jun-200912:50
Sqlce30.wce5.armv4i.cabNot Applicable1,622,65416-Jun-200912:50
For all supported ARMV4-based versions of Windows CE 4.0 for Pocket PC devices
Collapse this tableExpand this table
File nameFile versionFile sizeDateTime
Sqlce30.dev.enu.ppc.wce4.armv4.cabNot Applicable320,23416-Jun-200912:29
Sqlce30.ppc.wce4.armv4.cabNot Applicable1,580,66216-Jun-200912:29
Sqlce30.repl.ppc.wce4.armv4.cabNot Applicable736,26616-Jun-200912:29
For all supported x86-based versions of SQL Server 2005 Compact Edition
Collapse this tableExpand this table
File nameFile versionFile sizeDateTime
Eula_en.rtfNot Applicable114,90003-Jun-200910:55
Sqlceca30.dll3.0.5300.14293,76015-Jun-200922:55
Sqlcecompact30.dll3.0.5300.1459,28015-Jun-200922:55
Sqlceer30en.dll3.0.5300.14136,09615-Jun-200922:57
Sqlceme30.dll3.0.5300.1451,07215-Jun-200922:55
Sqlceoledb30.dll3.0.5300.14139,13615-Jun-200922:55
Sqlceqp30.dll3.0.5300.14532,35215-Jun-200922:55
Sqlcese30.dll3.0.5300.14290,68815-Jun-200922:55
System.data.sqlserverce.dll3.0.5300.14235,40815-Jun-200921:13

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 971970 - Last Review: July 14, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 2005 Compact Edition
Keywords: 
kbsurveynew kbhotfixserver kbautohotfix kbexpertiseadvanced kbqfe kbfix KB971970

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com