Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Error on DataLoad on a replicated table

Author  Topic 

dolphin123
Yak Posting Veteran

84 Posts

Posted - 2012-12-28 : 11:48:33
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 following


sp_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

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-12-28 : 15:24:33
Check this kb article
http://support.microsoft.com/kb/953481
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2013-01-07 : 01:38:22
This issue can be resolve with the following hotfix:

You can download the hotfix files through one of the following KB articles:

Hotfix to apply to SQL Server 2008 (without Service Pack 1):
http://support.microsoft.com/kb/973601/en-us

Hotfix to apply to SQL Server 2008 with Service Pack 1:

http://support.microsoft.com/kb/973602/en-us

I will recommend you to install the hotfix on your test environment before applying it to your production environment.
Go to Top of Page

dolphin123
Yak Posting Veteran

84 Posts

Posted - 2013-01-16 : 11:58:18
Thanks a lot guys.
Go to Top of Page
   

- Advertisement -