SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Error on DataLoad on a replicated table
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dolphin123
Yak Posting Veteran

USA
75 Posts

Posted - 12/28/2012 :  11:48:33  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

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

prett
Posting Yak Master

USA
195 Posts

Posted - 01/07/2013 :  01:38:22  Show Profile  Visit prett's Homepage  Reply with Quote
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

USA
75 Posts

Posted - 01/16/2013 :  11:58:18  Show Profile  Reply with Quote
Thanks a lot guys.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000