Article ID: 2832689 - View products that this article applies to.
When you add an article to a merge publication in Microsoft SQL Server, you receive the following error message:
<Time stamp> Category:SQLSERVER
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:
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.
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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 2832689 - Last Review: April 29, 2013 - Revision: 1.0