Share via

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

  • Article
  • 09/09/2011

Question

Friday, September 9, 2011 7:20 PM

We suddently started seeing this error in the Applicaion log of our SQL 2005 Distrubtion server.  We ran SQL Profiler and found the command causing the error.  It is ...

* exec sp_MShelp_distribution_agentid 16,N'DatabaseName',NULL,4,N'DatabaseName',1*

I changed the db name for security, but you can see it is actually passing a NULL value for some reason.  We have looked at the MSPublicaions table

* select * from dbo.MSpublications where publisher_id=16 and publisher_db='DatabaseName'*

but there are no NULL fields returned.  This error is getting genrated every 60 seconds or so.  Any clues on how to figure out where it is coming from and fix it??

Jim

All replies (1)

Friday, September 9, 2011 9:34 PM ✅Answered

Duplicate Post:

Check this thread:

http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/fc6db830-b88d-4248-b887-21fd18d7aea1

 

-Please mark it as answer if you are satisfied with the resolution.

Thanks, Deepesh