About Replication error

  • I have got the follwing message while trying to synchronization. the messgae is 'The merge process could not initialize the subscription. The index entry for row ID was not found in index ID 2, of table 1511676433, in database 'ERP'.' Please I need a solution immediately. Please help me.

    Fazle Rabbee

  • data is not in sync between publisher and subscriber, please sync the data.

    Rajesh Kasturi

  • Sounds like you have data corruption. Please run the following in the database 'ERP'

    DBCC CHECKDB ('ERP') WITH NO_INFOMSGS, ALL_ERRORMSGS

    Do you have any idea when this started?

    Do you have any backups of this database?

    What version of SQL? (SELECT @@version)

    Read through this - http://www.sqlservercentral.com/articles/65804/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Hppefully re-attempting synchronization did work for you. If not, you may want to look into the tablediff command line utility to compare the table at the Publisher and Subscriber.

    ken

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply