Replication Error: 14151, severity: 18, State 1.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Replication Error: 14151, severity: 18, State...

Replication Error: 14151, severity: 18, State 1.

Rate Topic

Display Mode

Topic Options

Author

Message

JP10

Posted Wednesday, December 19, 2012 4:45 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:10 PM
Points: 22, Visits: 139

Hi,

I have like a orphaned publisher trying to push out a transactional request or something. I can't figure this out i get the below error message, but the actual publisher to subscription (push and subscriber is on another server from the publisher) is working just fine. But, in the SQL error log (on the publisher server) I am still getting the below message? Anybody encounter this or know how to find out where this is coming from and how to get rid of this message? Another note is we did swap servers for the subscriber, but like i said it replication is working just fine.

"Replication-Replication Distribution Subsystem: agent(null)failed. The subscription to publication has expired or does not exist."
Error: 14151, severity: 18, State 1.

Any help is much appreciated! Thanks.

Post #1398708

Satish Nagaraja

Posted Wednesday, December 19, 2012 11:11 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 29, 2013 2:25 AM
Points: 164, Visits: 251

Must be some old subscriptions as which are generating this , follow discussion in link below it would guide you.

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

Cheer Satish Smile

Post #1398786

JP10

Posted Thursday, December 20, 2012 11:17 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:10 PM
Points: 22, Visits: 139

Satish thanks a million it looks like exactly the problem we are having! We are going to first try and re-initialize it, because the stopping of the sql service is not a luxury we have since were in a 24x7 environment. So, if the re-initialize doesn't work we will have to schedule some time out to go down your route. Really appreciate the reference though i think your route will work if re-initialize doesn't. Appreciate it.

Post #1399078

« Prev Topic | Next Topic »

Permissions