January 23, 2013 at 10:21 pm
Hi, I use merge replication. I tried to insert a couple of records at the publisher. I am 'sa' on the instance. It throws an error -
Msg 548, Level 16, State 2, Line 3
The insert failed. It conflicted with an identity range check constraint in database 'merge_abc', replicated table 'dbo.address', column 'AddressID'. If the identity column is automatically managed by replication, update the range as follows: for the Publisher, execute sp_adjustpublisheridentityrange; for the Subscriber, run the Distribution Agent or the Merge Agent.
The statement has been terminated.
I tried to check the identity range using script
select
publication,
subscriber,
subscriber_db,
range_begin,
range_end,
next_range_begin,
next_range_end,
max_used
from
MSmerge_identity_range_allocations
However, I don't understand the identity ranges it displays.
Do I use the sp_adjustpublisheridentityrange, if so any advise on how to set values and how to know the exact identity range I have now?
Please let me know.
(Also, anything at subscriber that I need to change/observe, please let me know)
January 23, 2013 at 10:56 pm
i am not good in replication but yes i found something for you
This problem occurs because the current identity value of the table on the publisher is not within the identity range of the identity range check constraint. This behavior occurs when multiple Merge Agents try to increase the identity range at the same time by creating the next identity range on the publisher.
from http://support.microsoft.com/kb/953481
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply