Post reply

Replication Monitor is not working.

  • December 3, 2009 at 3:19 am

    #213149

    Replication Monitor is not working. Please see the attached screen shot.

    When I run the following stored procedures..

    sp_replmonitorhelppublisher

    sp_replmonitorhelpsubscription

    sp_replmonitorhelppublication

    All of them give following error message:

    Msg 50000, Level 16, State 1, Procedure sp_replmonitorrefreshagentdata, Line 238

    could not find agent entry

    Latency alert is also not working.

    I restarted the distributor. It did not help.

    Any help in resolving this issue is highly appreciated.

  • January 20, 2010 at 2:40 pm

    #1106376

    This can be caused by partially removed publications that leave metadata behind in the distribution sys tables. You can search for removed publications in the MSpublications, MSsnapshot_agents, MSpublisher_databases and perhaps other tables. Scrubbing these restored our replication monitor functionality.

    Converting oxygen into carbon dioxide, since 1955.

  • January 20, 2010 at 11:23 pm

    #1106506

    Steve Cullen (1/20/2010)

    This can be caused by partially removed publications that leave metadata behind in the distribution sys tables. You can search for removed publications in the MSpublications, MSsnapshot_agents, MSpublisher_databases and perhaps other tables. Scrubbing these restored our replication monitor functionality.

    Thanks Steve

  • October 7, 2011 at 11:23 am

    #1391880

    Do you have a good way to detect any of these orphans? I am also having the same issue and cannot resolve it.

    Kindest Regards,
    David

    ** Obstacles are those frightening things that appear when we take our eyes off the goal. **

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

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