Sql Server 2005 Replication Monitor Showing Error

Question

Hello Experts,

In Sql 2005 Merge replication we have 15 subscriptions running in that Synchronizing status showing for 2  rest all are showing Error with redcross  but when i checked all are working fine.  Is it Bug or something else i'm missing. I have restart the Sql Services in fact i have restarted the whole server but no change its same.

Answer 1

Double-click the suspect subscription(s) in Replication Monitor to view the details.  From the View: drop down, select Synchronizations with errors and view the last agent message for any sessions that contain errors.  If there is a red cross for a subscription then there should be sessions rows returned for the Synchronizations with errors view.

---

Brandon Williams (blog | linkedin)

Answer 2

Hi Williams,

Well Errors will happen when ever the system shuts down at other end as those are branches which gets closed. When ever systems are up the error goes. I'm finding the above issue since last week.

---

Regards SQL NOOB

Answer 3

Are these push subscriptions?  If so, then the Merge Agent runs at the Distributor and cannot connect to the Subscriber when the Subscriber is shut down which would explain the error.

---

Brandon Williams (blog | linkedin)

Answer 4

Yes your right,  the error comes when  subscriber is shut down at present its not and if we  double click the subscription the replication is working smoothly still the error shows, i need to know why

---

Regards SQL NOOB

Answer 5

When you double-click a subscription in Replication Monitor it displays agent session history.  The errors will not go away as it shows historical data for Merge Agent sessions.

---

Brandon Williams (blog | linkedin)