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

#1 (**permalink**) 03-01-2008, 03:17 PM

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.

#2 (**permalink**) 03-01-2008, 03:17 PM

Drill down on the publication in the replication folder\Local Publications.
Right click on it and select Generate Scripts.

--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<bourgon@gmail.com> wrote in message
news:1181857951.236214.261320@o11g2000prd.googlegr oups.com...
> 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.
>

#3 (**permalink**) 03-01-2008, 03:18 PM

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

<bourgon@gmail.com> wrote in message
news:1181857951.236214.261320@o11g2000prd.googlegr oups.com...
> 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.
>

#4 (**permalink**) 03-01-2008, 03:25 PM

On Jun 18, 1:06 pm, "jeff_y" <jeffrey...@abc.com> wrote:
> 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, 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode