SQL Server 2014 Merge Replication Snapshot Agent Error

• surendar.r

  SSC Veteran

  Points: 248

  More actions

  December 9, 2014 at 8:18 am

  #292702

  We are in the process of testing SQL server 2014 Replication service. We have a separate server for distributor and publisher. I created a merge publication and ran the snapshot agent and it works fine with no data in the database. I connected the Subscriber to this merge publication and able to create the tables at the subscriber end. All these are working fine. After i migrate the data in the publisher and i made some modifications to one of the tables and so i ran the snapshot again. At this point the snapshot agent is struck and timing out and the error says

  Error Message : Another snapshot agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent.

  I checked the distributor and publisher and verified that no other agent or transaction is running except this one.

  Error messages:

  Message: Another snapshot agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent.

  Command Text:

  declare @retcode int

  exec @retcode = sys.sp_getapplock @Resource = N'PubServer-Test1-pub_Dev_Test1_M3-1',

  @LockMode = N'Exclusive',

  @LockOwner = N'Session',

  @LockTimeout = 0,

  @DbPrincipal = N'db_owner'

  if @retcode < 0 raiserror(21036, 16, -1, 'snapshot')

  Parameters:

  Stack: at Microsoft.SqlServer.Replication.AgentCore.ReMapSqlException(SqlException e, SqlCommand command)

  at Microsoft.SqlServer.Replication.AgentCore.AgentExecuteNonQuery(SqlCommand command, Int32 queryTimeout)

  at Microsoft.SqlServer.Replication.AgentCore.ExecuteDiscardResults(CommandSetupDelegate commandSetupDelegate, Int32 queryTimeout)

  at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.DoAgentInstanceChecking()

  at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()

  at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()

  at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQLServer, Error number: 21036)

  Get help: http://help/21036

  Server PubServer, Level 16, State 1, Procedure , Line 8

  Another snapshot agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent. (Source: MSSQLServer, Error number: 21036)

  Get help: http://help/21036%5B/quote%5D

  I am able to reproduce this issue every time.

  I am trying to identify the root cause of the problem and fix it. Any solution on how to approach this issue?

  Appreciate all your help.

  Thanks