Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Error: 14151, Severity: 18, State: 1

Author  Topic 

ias0nas
Starting Member

36 Posts

Posted - 2011-02-21 : 10:25:52
Hello,

Over the weekend I started getting this error message in the event logs of the DB server:

Replication-Replication Distribution Subsystem: agent (null) failed. The publication '<publication name>' does not exist.

When I run sp_readerrorlog I get this message:
Error: 14151, Severity: 18, State: 1
Replication-Replication Distribution Subsystem: agent (null) failed. The publication '<publication name>' does not exist.


The server is used as a publisher as well. I have deleted this specific publication and all the others and only left one that cannot be deleted as it is used for production.
I still get the message...

Executing this
SELECT * FROM dbo.MSsubscriptions
on the distribution database I only get the entries for the remaining replication that should be there.

Any ideas..? Any places I could look to delete entries for that publication?

Thanks,
Jason
   

- Advertisement -