Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    3

    Unanswered: The index entry for row ID was not found in index ID 3, of table 357576312

    Hi,

    I'm running a merge replication on a sql2k machine to 6 sql2k subscribers.
    Since a few day's only one of the merge agents fail's with the following error:

    The merge process could not retrieve generation information at the 'Subscriber'.
    The index entry for row ID was not found in index ID 3, of table 357576312, in database 'PBB006'.

    All DBCC CHECKDB command's return 0 errors
    I'm not sure if the table that's referred to in the message is on the distribution side or the subscribers side? A select * from sysobjects where id=357576312 gives different results on both sides . .

    Any ideas as to what is causing this error?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    What database is it ('PBB006')? Check the conflicts table on the offending subscriber and on the publisher.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jul 2004
    Posts
    3
    The table the id = referring to is MSMerge_tombstone on the subscriber.

    So which conflict table should I check? Since it is not a user table?
    Last edited by bbird; 07-14-04 at 08:55.

  4. #4
    Join Date
    Jul 2004
    Posts
    3
    fixed it by running dbcc checktable ('MSMerge_tombstone' REPAIR_FAST)

Posting Permissions

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