You are currently offline, waiting for your internet to reconnect

BUG: Identity Range Not Adjusted on Publisher When Merge Agent Runs Continuously

This article was previously published under Q304706
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 353367 (SHILOH_BUGS)
When the merge agent is running in continuous mode and is using automatic identity range handling, inserts on the publisher's table with identities may fail with the following message when the identity range is full:

Server: Msg 548, Level 16, State 2, Line 1
The identity range managed by replication is full and must be updated by a replication agent. The INSERT conflict occurred in database 'pubs', table 'Table1', column 'ident_t1'. Sp_adjustpublisheridentityrange can be called to get a new identity range.
The merge agent does not properly renew the identity range at the publisher.
You can work around this problem in the following ways:
  • Use the sp_adjustpublisheridentityrange system stored procedure to adjust the identity range manually.
  • Manually stop and start the merge agent.
  • Change the merge agent to run on a schedule (for example, every minute) instead of continuously.
Microsoft has confirmed this to be a problem in SQL Server 2000.
For more information on handling identity values in replication, see the following topics in SQL Server 2000 Books Online:
  • "Managing Identity Values"
  • "sp_adjustpublisheridentityrange"

Article ID: 304706 - Last Review: 01/16/2015 23:13:08 - Revision: 4.3

Microsoft SQL Server 2000 Standard Edition

  • kbnosurvey kbarchive kbbug kbpending KB304706