For one of our SQL server 2005 enterprise, configured with merge replication, we suddenly start seeing the below error message:
The insert failed. It conflicted with an identity range check constraint in database 'ABC', replicated table 'dbo.tblMtxyze', column 'csa'. 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.
I went through the complete process of rectifying as explained here, but no luck.
We have about 10 publication from this single database ABC containing the filtered tables, around 6 and all of them going through same error:
Any idea how can i proceed from here, apart from setting up merge replication from scratch?
On exploring more we found that out of those 10 Publications, we have one Publication which act as master Publisher which needs to be working in order for rest 9 to work.
However, when we right click and went to properties of that publication, the articles( 6 common tables among all 10 pubs) were not at all present out there on this master publisher.
So we went ahead and try adding those articles , but it threw us error saying
An article with a different subscriber_upload_options value already exists for object '[dbo].tbl1
In order to resolve, we though this being master, went ahead and removed one article at a time from other 9 publications, thus allowing that table1 to show in article on master publication.
But again, the same thing goes if i try to add removed articles back to other 9 publications with same error.
What can be done here? We are out of thoughts for now as this merge replication seems very complicated!