Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Question Unanswered: Merge replication subscriber error: invalid cursor state

    These errors occur at the subscriber. First, "The merge process could
    not query the last sent and received generations" is generated, then
    immediately afterwards, "invalid cursor state" is generated. We are
    trying to pull a new subscription snapshot from the republisher. The
    subscriber has been added and removed from the replusher's pull
    subscriptions a number of times for testing. Now, we cannot get the
    subscriber to re-sync with the republisher.

    Any ideas?

  2. #2
    Join Date
    Aug 2004
    Posts
    2

    Resolution...

    The problem resulted from older pull subscription information strewn about the sysmerge* tables on the subscriber confusing the merge agent. Truncating these system tables solved the problems.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •