Post reply

Replication Query

  • October 15, 2004 at 7:20 am

    #85627

    I have a question for you guys.

    We have replication trans/snap between 2/3 databases..pretty standard stuff.

    However, periodically, a problem occurs. The Distribution agent will fail giving the error Can't find row in subscriber. When I check the table in question on the subscriber, it is not just a case of a row being deleted, the whole range of ids in the table are out of synch.

    The work around is to replace the rows with those from the publisher and re-run the Distribution Agent with the profile 'Continue with errors...'. This seems to do the trick. Fortunately this is only on a test environment. But it is a mystery.

    A normal re-initialize and rerun the snaphot and run the Distribution does not seem to work.

    Any one have any ideas what could cause this.

    Many thanks

    Graeme

  • October 15, 2004 at 8:05 am

    #526903

    Check if in the subscriber someone is making changes to the published tables, or also check for triggers that can be changing the replicated data.

    Also you shoud check the stored procedures used by replication to see if they where changed by someone. run sp_HelpArticle to see what stored procedures, the publication uses. (check in BOL for parameters)

Viewing 2 posts - 1 through 1 (of 1 total)

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