Replication & Identity Problem

• zhtway

  Old Hand

  Points: 325

  More actions

  September 21, 2010 at 2:00 pm

  #145198

  Hi,

  I am a starter and newbie to SQL Server. Currently, I am developing SQL replication database with Mobile Devices. Publication DB has several tables for replication. one table has Identity column.

  When Insert Query was run, I got the error.

  "09/21/2010 04:00:00,POD Generate Manifest,Error,1,SRV01,POD Generate Manifest,Generate Manifest,,Executed as user: NT AUTHORITY\SYSTEM. The insert failed. It conflicted with an identity range check constraint in database 'MobilePOD'<c/> replicated table 'dbo.Delivery'<c/> column 'DeliveryID'. If the identity column is automatically managed by replication<c/> update the range as follows: for the Publisher<c/> execute sp_adjustpublisheridentityrange; for the Subscriber<c/> run the Distribution Agent or the Merge Agent. [SQLSTATE 42000] (Error 548) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:01,16,3621,,,,0"

  In the Constraint, there is

  "repl_identity_range_227F86CA_526E_4DED_B178_162FF9848F44",

  whose expression is

  "([DeliveryID]>(54009) AND [DeliveryID]<=(55009) OR [DeliveryID]>(55009) AND [DeliveryID]<=(56009))"

  "Reinitialize all subscriptions" command can solve this issue.

  But I don't want to do it every time it occur.

  So what configuration did I do wrong and how to fix it?

  Thanks

  zhtway

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  September 22, 2010 at 11:41 pm

  #1226082

  Try "NOT FOR REPLICATION" option and test it.

  Hope it helps you.