The identity range managed by replication is full and must be updated

[quisar]

Hi!

We have set identity cols as &quot;Not for replication&quot; and different range for the publisher and subscriber using merge replication. Now the subscriber we are getting an error &quot;The identity range managed by replication is full and must be updated by a replication agent. The insert conflict occurred in database <BDName>, TABLE <TableName>, COLUMN <ColName>&quot; while trying to insert in a table having identity field. The val in that col has reached the max value. How do I increase it using a script, or is there anyother way of doing this.

Thanks

Quisar

 

[tfurry]

Hi Quisar,
From what I've read and practiced with merge replication, it sounds like your publisher and subscriber are disconnected, and that one of them (you weren't clear on which one was giving the error) has reached its limit of assigned identity ranges. The solution is to reconnect the two and let the replication agent merge all the updates at the publisher. After that I'm not sure if it will automatically update the assigned identity ranges or not...you may have to do it manually or generate a new subscription.

Tim