Article ID: 971970 - Last Review: July 14, 2009 - Revision: 1.0

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

Hotfix Download Available
View and request hotfix downloads

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

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)

Back to the top

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

Back to the top

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 (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 name	File version	File size	Date	Time
Sqlce30.dev.enu.wce5.armv4i.cab	Not Applicable	324,834	16-Jun-2009	12:50
Sqlce30.repl.wce5.armv4i.cab	Not Applicable	758,306	16-Jun-2009	12:50
Sqlce30.wce5.armv4i.cab	Not Applicable	1,622,654	16-Jun-2009	12:50

For all supported ARMV4-based versions of Windows CE 4.0 for Pocket PC devices

Collapse this tableExpand this table

File name	File version	File size	Date	Time
Sqlce30.dev.enu.ppc.wce4.armv4.cab	Not Applicable	320,234	16-Jun-2009	12:29
Sqlce30.ppc.wce4.armv4.cab	Not Applicable	1,580,662	16-Jun-2009	12:29
Sqlce30.repl.ppc.wce4.armv4.cab	Not Applicable	736,266	16-Jun-2009	12:29

For all supported x86-based versions of SQL Server 2005 Compact Edition

Collapse this tableExpand this table

File name	File version	File size	Date	Time
Eula_en.rtf	Not Applicable	114,900	03-Jun-2009	10:55
Sqlceca30.dll	3.0.5300.14	293,760	15-Jun-2009	22:55
Sqlcecompact30.dll	3.0.5300.14	59,280	15-Jun-2009	22:55
Sqlceer30en.dll	3.0.5300.14	136,096	15-Jun-2009	22:57
Sqlceme30.dll	3.0.5300.14	51,072	15-Jun-2009	22:55
Sqlceoledb30.dll	3.0.5300.14	139,136	15-Jun-2009	22:55
Sqlceqp30.dll	3.0.5300.14	532,352	15-Jun-2009	22:55
Sqlcese30.dll	3.0.5300.14	290,688	15-Jun-2009	22:55
System.data.sqlserverce.dll	3.0.5300.14	235,408	15-Jun-2009	21:13