The Publisher failed to allocate a new set of identity ranges for the subscription

 dans Sites Microsoft par

Problem:

===========

Assume that you have tables with Identity columns declared as datatype INT and you are using Auto Identity management for those articles in a Merge Publication.

This Publication has one or more subscribers and you tried to re-initialize one subscriber using a new Snapshot.

Merge agent fails with this error:

>>
Source:  Merge Replication Provider

Number:  -2147199417

Message: The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a Publisher or a republishing Subscriber has run out of identity ranges to allocate to its own Subscribers or when an identity column