BUG: Identity Range Not Adjusted on Publisher When Merge Agent Runs Continuously (304706)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbpending KB304706 kbAudDeveloper |
|---|
|