Friday, June 12, 2009

PRB: Log Reader Agent Does Not Function and You Receive an Error Message During Transaction Replication

When you use transaction replication to distribute the data, you may experience the following symptoms:Log Reader Agent does not replicate the data and it displays the following error message:


The process could not execute 'sp_replcmds' on servername.


The log file contains the following information:
Status: 2, code: 0, text: 'The process could not execute 'sp_replcmds' on servername'. The process could not execute 'sp_replcmds' on servername. Status: 2, code: 0, text: 'Timeout expired'. Disconnecting from Publisher servernameThe agent failed with a 'Retry' status. Try to run the agent at a later time.

CAUSE:
To facilitate transactional replication, Log Reader Agent moves the transactions that are marked for replication from the transaction log on the publisher to the distribution database. You may receive this error message when Log Reader Agent cannot move the transaction log within the time limit that you set in the Log Reader Agent QueryTimeout property.
See full detail:
http://support.microsoft.com/kb/811030

No comments: