Hi,I have a table is threw an error when we were loading data.The insert failed. It conflicted with an identity range check constraint in database 'DB', replicated table 'dbo.table', column 'myColumn'. 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 searched and found some things to try.1. On the publisher, under Identify range management, I changed the publisher range size and Subscriber range size to 10000000. It was 10000 and 1000 before.I made it like so, it will have a wider range. 2. On the publisher Server under the DB in question, I ran the followingsp_adjustpublisheridentityrange @table_name = '<tablename>'
2. on the subscriber, I selected the subscription, selected "View Sync status" and clicked on Monitor. It was already in "Start synchronising". I quickly saw some error related the table in question, but It went away. I am still getting the same failure but with some additional verbage.548 - The insert failed. It conflicted with an identity range check constraint in database '.*ls', replicated table '.*ls'ls.*lsls. 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. 50000 -Can anyone spot what I am doing wrong here?Regards,D
Error on DataLoad on a replicated table
Posted - 2012-12-28 : 11:48:33
