SQL 2005 error: Replication-Replication Distribution Subsystem: agent (null) failed.

Discussion in 'microsoft.public.sqlserver.server' started by bourgon, Jun 14, 2007.

  1. bourgon

    bourgon Guest

    I'm getting this, after upgrading from 2000 to 2005.

    Replication-Replication Distribution Subsystem: agent (null) failed.
    The subscription to publication '(null)' has expired or does not
    exist.

    The only suggestions I've seen are to dump all subscriptions. Since
    we have several dozen publications to several servers, is there a
    decent way to script it all out, if that's the only suggestion?

    Thanks in advance.
     
    bourgon, Jun 14, 2007
    #1
    1. Advertisements

  2. Hilary Cotter, Jun 15, 2007
    #2
    1. Advertisements

  3. bourgon

    jeff_y Guest

    I get the similar error message, can this be explained in terms of its
    possible causes?
    My observation is my transactional replication goes well without any
    problems, but I keep on finding this annoying error in the sql server log.
    Any thoughts on this issue is highly appreciated.

    Jeff
     
    jeff_y, Jun 18, 2007
    #3
  4. bourgon

    bourgon Guest

    Jeff, we wound up contacting Microsoft about it. They had us run a
    trace on the server (turning on the "errors and warnings"), determined
    that it had something to do with subscriptions to a particular
    published database, then we removed and recreated them.

    We also, once we'd scripted and removed the subscriptions, we ran
    sp_removedbreplication. Hope this helps.
     
    bourgon, Jul 2, 2007
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.