Replication-%s: agent %s scheduled for retry. %s

Details
Product: SQL Server
Event ID: 14152
Source: MSSQLServer
Version: 10.0
Component: SQL Server Database Engine
Message: Replication-%s: agent %s scheduled for retry. %s
   
Explanation

The specified replication agent has been scheduled to retry the requested operation. The process continues to retry until it reaches the configured maximum number of retry attempts for the job step.

A retry typically occurs because of one of the following reasons:

  • The
    QueryTimeout
    value is exceeded.

  • The
    LoginTimeout
    value is exceeded.

  • The replication process was chosen as a deadlock victim.

   
User Action

If the retry message is infrequent, no user action is required.

Use sp_help_jobstep to view the current setting for the maximum number of times the
Run agent
step for the specified replication agent will retry. You can use the
@retry_attempts
parameter of the sp_update_jobstep stored procedure to adjust the number of times a job step retries.

If the retry message recurs frequently, troubleshoot the issue based on the message that is causing the retry. Check the agent’s history for messages that indicate why the retry had to be scheduled. In some cases you may have to enable more detailed logging for your replication agent. For more information about how to configure logging for replication, see the Microsoft Knowledge Base article
312292http://support.microsoft.com/kb/312292
.

   
   
Version: 9.0
Component: SQL Server Database Engine
Message: Replication-%s: agent %s scheduled for retry. %s
   
Explanation

The specified replication agent has been scheduled to retry the requested operation. The process continues to retry until it reaches the configured maximum number of retry attempts for the job step.

A retry typically occurs because of one of the following reasons:

  • The
    QueryTimeout
    value is exceeded.

  • The
    LoginTimeout
    value is exceeded.

  • The replication process was chosen as a deadlock victim.

   
User Action

If the retry message is infrequent, no user action is required.

Use sp_help_jobstep to view the current setting for the maximum number of times the
Run agent
step for the specified replication agent will retry. You can use the
@retry_attempts
parameter of the sp_update_jobstep stored procedure to adjust the number of times a job step retries.

If the retry message recurs frequently, troubleshoot the issue based on the message that is causing the retry. Check the agent’s history for messages that indicate why the retry had to be scheduled. In some cases you may have to enable more detailed logging for your replication agent. For more information about how to configure logging for replication, see the Microsoft Knowledge Base article
312292http://support.microsoft.com/kb/312292
.

   
   
Version: 8.0
Component: SQL Engine
Message: Replication-%s: agent %s scheduled for retry. %s
   
Explanation
The specified replication agent has been scheduled to retry the requested operation. The process will retry until it reaches the configured maximum number of retry attempts for the job step.

Some of the situations where a retry is scheduled are:

  • The QueryTimeout value is exceeded.
  • The LoginTimeout value is exceeded.
  • The replication process was chosen as a deadlock victim.
   
User Action
If the retry message is infrequent, no user action is required.

Use sp_help_jobstep to view the current setting for the maximum number of times the “Run agent” step for the specified replication agent will retry. You can use the retry_attempts parameter of the sp_update_jobstep stored procedure to adjust the number of times a job step will retry.

If the retry message recurs frequently, troubleshoot the message that is causing the retry to be scheduled. Check the agent’s history for messages that indicate why the retry had to be scheduled. In some cases you may need to enable more detailed logging for your replication agent. For more information about configuring a log for replication, see the Microsoft Knowledge Base article 312292.

Related:

Leave a Reply