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 |
|
Andre54
Starting Member
2 Posts |
 Posted - 2008-01-08 : 05:25:06
|
| Hi all i have setup merge replication with one publisher and 3 subscribers The replication worked fine for about 2 months then i recieved the following error on all my subscriptions The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a Publisher or a republishing Subscriber has run out of identity ranges to allocate to its own Subscribers or when an identity column data type does not support an additional identity range allocation. If a republishing Subscriber has run out of identity ranges, synchronize the republishing Subscriber to obtain more identity ranges before restarting the synchronization. If a Publisher runs out of identit (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199417)Get help: http://help/MSSQL_REPL-2147199417I have updated my sql server to service pack 2 The publisher is sql Standard edition and the subscribers are Express edition Any help would be great Thanx |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-08 : 22:29:50
|
| How did you set identity seed on those tables? What's data type of the column? |
 |
|
|
Andre54
Starting Member
2 Posts |
Posted - 2008-01-09 : 01:41:23
|
| The identity seed is managed automatically The error is not on a specific table, it is for the complete publication. To answer your question about the data typeI am going to try and use the sp_adjustpublisheridentityrange today and see what happens |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-09 : 23:19:16
|
| Default seed is 1, but you can specify it when add identity column and you should specify different seed on different server in this case. |
|
|
|
|
|
|
Merge replication identity range error