identity range allocation entry for Publisher not found

Question

I had a publisher to a republisher scenario going on 2005 build 9.0.4035.
once all the subscriptions were moved to the republisher I dropped the
Publisher thereby making the republisher the new and only publisher.

Issue:  I need to create a new snapshot and the error I get when trying to
run the snapshot is:
    The identity range allocation entry for the Publisher could not be found
in the system table MSMerge_identity_range.  ensure the value for the
@identityrangemanagementoption property is "auto".

I've been researching and found a bug back that was back in sp2 and I have a
much more recent version.

any ideas?

Shawn

Answer 1

shawn,

Is your database upgraded from a previous version of sql server?

Answer 2

Yes, a couple times.  I checked though and the compatibility level is 90 (2005).  Is that still a known issue?

 

Shawn

Answer 3

I think the merge system table got messed up there, it would be hectic to fix it. I suggest you remove your replication settings (if affordable) using exec sp_removedbreplication 'yourdatabasename', remove the distributor then reconfigure and resetup your publication+subscribers.