Post reply

Another Distribution agent for the subscriptiion

  • September 26, 2003 at 7:01 am

    #101687

    sql2k sp3

    Im getting a message on replication that has been running

    for a while:

    Another distribution agent for the subscription(s) is

    running. NOTE: The step was retried the requested number

    of times (10) without succeeding. The step failed.

    Any ideas?

    Thanks

  • September 26, 2003 at 7:09 am

    #475981

    If it is a push subscription, check in the publisher with sp_who2 wich process id is running the agent.

    It could be that someone fire the agent from the command line, or that another job by mistake was created to run the agent.

  • September 26, 2003 at 7:26 am

    #475989

    How can I tell which process is running the distrubtion agent?

    I ran the sp_who2 and have a list of processes. I see several processes for the distribution database. When I look at the program name most of them are for my publication and subscription. There is one the say "Replication Distribution History"

    Thanks for your help

  • September 26, 2003 at 7:58 am

    #476004

    You could check for a process running sp_MSget_repl_commands, that is an sp runned by the distribution agent.

    You can use dbcc inputbuffer (spid) to find out.

  • September 26, 2003 at 8:36 am

    #476025

    I checked the processes and there is only one process with the sp_MSget_repl_commands.

    The subscription is a pulled subscription and I checked the server with the pulled subscription and there is only one instance of the distrib.exe running under the task manager windows. Also, I check the sp_who2 on that server as well and did not see any duplicates.

    Your help is greatly appreciated.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply