Category Archives: Replication

Replication-Distribution Agent is already running


Very rarely should you acquire the following error, which can be viewed when looking at the job activity monitor failure history: “Agent message code 21036. Another distribution agent for the subscription(s) is running or the server is working on a … Continue reading

Posted in Replication | Leave a comment

Performance Reads ‘Not Enabled’


When looking at the performance monitor under the column ‘Performance’, the message ‘Not Enabled’ is indicated instead of the typical message of ‘Excellent’, ‘Poor’, or ‘Critical’.  This simply means that the threshold for this agent is not enabled and needs … Continue reading

Posted in Replication | Leave a comment

The process could not connect to Subscriber ‘ServerName’


When the message displays that it cannot connect to the subscriber, it is commonly because of the following reasons: The subscribing server is busy The subscribing server is down The authentication is failing Before correcting the problem, verify if the … Continue reading

Posted in Replication | Leave a comment

Transaction was deadlocked on lock resources : Transaction (Process ID #) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction


It is uncertain how the deadlocks occur, but it may be application related or due to too many processes running concurrently.  To avoid this, all the lookup tables are scheduled to execute every hour.  The specific deadlock error message that … Continue reading

Posted in Replication | 1 Comment

Inactive Subscription: The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated


When looking at the replication monitor, a message may appear under the ‘status’ column of the subscription watch tab that displays the message ‘not running/ inactive subscription’ “The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will … Continue reading

Posted in Replication | Leave a comment

not running expiring soon


Expiring Soon When looking at the replication monitor, a message may appear under the ‘status’ column of the subscription watch tab that displays the message ‘not running expiring soon’. This message is caused when a specific elapsed time has occurred … Continue reading

Posted in Replication | Leave a comment

can’t insert duplicate key to ‘subscriber’’ or a can’t insert because of a duplicate key


This error message ‘can’t insert duplicate key to ‘subscriber’’ or a can’t insert because of a duplicate key message pertain to a record that is trying to be inserted that previously existed. The primary reason this can occur is if … Continue reading

Posted in Replication | Leave a comment