December 17, 2010 at 11:44 am
Message
Error: 14151, Severity: 18, State: 1.
Message
Replication-Replication Distribution Subsystem: agent (null) failed. The publication 'Temp_Report_Requirements_DM01' does not exist.
December 17, 2010 at 12:36 pm
ron morgan (12/17/2010)
Message
Error: 14151, Severity: 18, State: 1.
Message
Replication-Replication Distribution Subsystem: agent (null) failed. The publication 'Temp_Report_Requirements_DM01' does not exist.
It looks like you have a distribution agent that is running against an invalid publication. The following query MIGHT work to show you the job (distribution agent) but I'm guessing not due to the fact that the error is stating that the publication is not there. So, you will have to look through the jobs on that server to figure out which one it is. Hopefully it will have something of the publication name in the job name.
SELECTdistinct da.name
FROMMSpublications pub inner join MSsubscriptions subs
ON pub.publication_id = subs.publication_id
inner join MSdistribution_agents da
ON da.id = subs.agent_id
WHEREpub.publication = 'Temp_Report_Requirements_DM01'
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2010 at 12:38 pm
Oh, you would run that query on the distribution database on the distributor. You would also find the job there.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply