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.
| Author |
Topic |
|
hendrasd
Starting Member
20 Posts |
 Posted - 2003-04-11 : 23:41:47
|
| I set up a transactional replication with updating subscription for table TMember with identity (seed 1 increment 1) as Primary Key on Server A (act as publisher). I set up article for TMember with automatic range handling for the primary key, range at publisher 10, range at subscriber 10, and threshold value 80%. Subscriber didnt have schema or data before replication. After replication was succeeded, I tried to insert a row in table TMember on publisher, and it was successfully sent to subscriber. Then I tried to insert a new row at subscriber. After inserted, id value for the new row is 23. But problem exists when I tried to insert a new row on subscriber that would result the value of id 30, with the following error message :INSERT statement conflicted with COLUMN CHECK constraint 'repl_identity_range_tran_2105058535'. The conflict occured in database 'Replikasi', table 'TMember', column 'MemId'. What would be the cause of the error and how to work around it ?-- Never stop learning -- |
|
|
|
|
|
Problem with Automatically Range Handling