Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. "Cannot find the identity range allocation entry for the Subscriber" error when you add an article to a SQL Server merge publication

"Cannot find the identity range allocation entry for the Subscriber" error when you add an article to a SQL Server merge publication

View products that this article applies to.

Symptoms

When you add an article to a merge publication in Microsoft SQL Server, you receive the following error message:

<Time stamp> Category:SQLSERVER
Source: <Publisher>
Number: 20671
Message: Cannot find the identity range allocation entry for the Subscriber in the MSmerge_identity_range table. Reinitialize the subscription.

This issue occurs if the following conditions are true:
  • The merge publication is in one of the following versions of SQL Server:
    • Microsoft SQL Server 2005 
    • Microsoft SQL Server 2008 
    • Microsoft SQL Server 2008 R2 
    • Microsoft SQL Server 2012
  • The merge publication contains articles that have identity range management enabled. 
  • All articles that have identity range management enabled have the @subscriber_upload_options = 2 definition. 
  • The subscription has the @subscriber_type = N'Local' definition.
  • The article that is being added has the @subscriber_upload_options = 0 definition.

↑ Back to the top

Resolution

To resolve this issue, reinitialize the subscribers.

Note To avoid this issue completely, before the subscriptions are initialized for the first time, configure at least one article that has identity range management enabled, and then set the upload option to @subscriber_upload_options = 0.

↑ Back to the top

Cause

The issue occurs because the merge agent believes that the information about the empty MSmerge_identity_range table is corrupted. Therefore, SQL Server asks for the reinitialization.

During the initialization of the subscriber, an MSmerge_identity_range table is created at the subscriber. However, no data is populated because all articles have the @subscriber_upload_options=2 definition. Therefore, no change is expected to occur at the subscriber. When you add an article, the merge agent checks the subscriber MSmerge_identity_range table in order to set up the ranges for the new article.

↑ Back to the top

More Information

  • For more information about the subscriber_upload_options argument, see sp_addmergearticle (Transact-SQL).
    • The @subscriber_upload_options = 2 definition means that changes are not enabled at the subscriber. 
    • The @subscriber_upload_options = 0 definition means that there are no restrictions. The changes that were made at the subscriber are uploaded to the publisher.
  • For more information about the subscriber_type argument, see sp_addmergepullsubscription (Transact-SQL).

↑ Back to the top

Status

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

↑ Back to the top

Keywords: kbsql2005repl, kbsurveynew, kbtshoot, kbexpertiseadvanced, kb

↑ Back to the top

Article Info
Article ID : 2832689
Revision : 1
Created on : 1/7/2017
Published on : 4/29/2013
Exists online : False
Views : 390