Microsoft KB Archive/304706

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

Article ID: 304706

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q304706



BUG #: 353367 (SHILOH_BUGS)



SYMPTOMS
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.



CAUSE
The merge agent does not properly renew the identity range at the publisher.



WORKAROUND
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.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000.



MORE INFORMATION
For more information on handling identity values in replication, see the following topics in SQL Server 2000 Books Online:
 * &quot;Managing Identity Values&quot;
 * &quot;Using NOT FOR REPLICATION&quot;
 * &quot;sp_adjustpublisheridentityrange&quot;

Keywords: kbbug kbpending KB304706

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.