Replication and Identity
Posted By: Posted Date: September 21, 2010
Points: 0 Category :Sql Server
I am a starter and newbie to SQL Server. Currently, I am developing SQL MERGE 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
whose expression is
"([DeliveryID]>(54009) AND [DeliveryID]<=(55009) OR [DeliveryID]>(55009) AND [DeliveryID]&l
View Complete Post
More Related Resource Links