This section describes the output when rs_helproute is executed at the source Replication Server.
Message:
Route is being dropped. System table subscriptions are being dropped.
Description: The destination Replication Server is trying to drop the system table subscriptions.
Suggested Action: Check the list of system table subscriptions that still need to be dropped.
Message:
Route is being dropped. Waiting for the system table subscriptions to be dropped.
Description: The system is in this state until the subscriptions are dropped.
Suggested Action: The Replication Server should not be in this state for a long period of time. If it is, it may indicate a subscription problem. Refer to Chapter 5, “Subscription Problems”.
Message:
Route is being dropped. Source RS has not yet attempted to send the drop route protocol message to the destination RS.
Description: The sender Replication Server could not execute the rs_marker stored procedure against its RSSD.
Suggested Action: Restart the Replication Server.Check the RSSD and any related messages in the error logs. There may be a message in the error logs indicating some problem with the RSSD.
Message:
Route is being dropped. Drop route protocol message should be either in RSSD Replication Agent queue or in the inbound queue.
Description: This message is the result of one of the following problems:
Problem: A message may be stuck between the RSSD log and the Replication Server inbound queue. The sender Replication Server executed the stored procedure, but the RSSD replication agent cannot forward it to the Replication Server.
Suggested Action: Check if the RSSD replication agent is experiencing problems sending messages to the Replication Server.
If not, restart the RSSD replication agent.
Problem: A message may be stuck between the inbound and outbound queues in the Replication Server.
Suggested Action: Check if the Replication Server’s inbound queues are full or the distributor for the RSSD is not running.
If neither of these problems exist, restart the RSSD replication agent.
Message:
Route is being dropped. Drop route protocol message is waiting to be delivered to the destination.
Description: The sender Replication Server is not processing its outbound queue.
Suggested Action: Is the destination Replication Server operating? Did the RSI (Replication Server Interface) experience problems trying to connect to the destination Replication Server? If so, it may be necessary to resume this route.
