merge replication identity check constraint insert fails

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » merge replication identity check constraint...

merge replication identity check constraint insert fails

Rate Topic

Display Mode

Topic Options

Author

Message

wmark793

Posted Wednesday, January 23, 2013 10:21 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, January 23, 2013 10:11 PM
Points: 1, Visits: 0

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)

Post #1410894

Bhuvnesh

Posted Wednesday, January 23, 2013 10:56 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1410903

« Prev Topic | Next Topic »

Permissions