locked
identity range allocation entry for Publisher not found RRS feed

  • 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
    Wednesday, May 5, 2010 2:19 PM

Answers

  • 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.
    Wednesday, May 5, 2010 8:50 PM

All replies

  • shawn,

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

    Wednesday, May 5, 2010 7:58 PM
  • Yes, a couple times.  I checked though and the compatibility level is 90 (2005).  Is that still a known issue?

     

    Shawn

    Wednesday, May 5, 2010 8:41 PM
  • 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.
    Wednesday, May 5, 2010 8:50 PM