locked
Unable start or stop merge replication (Push) RRS feed

  • Question

  • Hi,

    I have the merge replication (Push)  for SQL Server 2008.The right-click option for Start and Stop Synchronizing in subscriptions has been disabled. How can I stop the merge replication and start again ?

    This error happened 1 week after I created the merge replication. The merge data cannot sync to subscriber and only solution I can use is drop and re-create the merge replication again but error would be re-occur a week later.

    The merge replication work fine before and start from middle on May 2015, but it keep happen right now.

    Any solutions?

    Thanks

    Teddy

    Monday, June 29, 2015 2:49 AM

Answers

  • What your SQL Server version?

    How do you configure replication? Does each agent job run properly? Check if agent jobs are missing.
    Tuesday, June 30, 2015 8:57 AM

All replies


  • Hi,

    I have the merge replication (push) and theright-click option for Start and Stop Synchronizing in subscriptions has been disabled.

    I changed the heartbeat interval to 20 and this error happened 1 week after I created the merge replication. The merge data cannot sync to subscriber and only solution I can use is drop and re-create the merge replication again but error would be re-occur a week later.

    Any other solutions?

    Thanks
    Monday, June 29, 2015 2:42 AM
  • When I click the View Synchronization Status,

    ===================================

    SQL Server is unable to complete the operation. (View Synchronization Status)

    ------------------------------
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22&EvtSrc=Microsoft.SqlServer.Management.UI.SubscriptionSyncErrorSR&EvtID=CantComplete&LinkId=20476

    ===================================

    An error occurred while attempting to access the subscription. (View Synchronization Status)

    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Management.UI.MergeSubSyncPush..ctor(PropertiesStartContext startCtxt, IServiceProvider serviceProvider)
       at Microsoft.SqlServer.Management.UI.LaunchSubscriptionSync.PrepareToShow()

    ===================================

    To synchronize, you must first create an agent job for this subscription.  (View Synchronization Status)

    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Management.UI.MergeSubSyncPush..ctor(PropertiesStartContext startCtxt, IServiceProvider serviceProvider)


    • Edited by Teddy Lo Monday, June 29, 2015 2:54 AM
    Monday, June 29, 2015 2:53 AM
  • When you select view details what error message do you get?

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

    Monday, June 29, 2015 6:33 PM
    Answerer
  • Thanks for reply Hilary and that what I get from view detail


    Question
    You cannot vote on your own post===================================

    SQL Server is unable to complete the operation. (View Synchronization Status)

    ------------------------------
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22&EvtSrc=Microsoft.SqlServer.Management.UI.SubscriptionSyncErrorSR&EvtID=CantComplete&LinkId=20476

    ===================================

    An error occurred while attempting to access the subscription. (View Synchronization Status)

    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Management.UI.MergeSubSyncPush..ctor(PropertiesStartContext startCtxt, IServiceProvider serviceProvider)
       at Microsoft.SqlServer.Management.UI.LaunchSubscriptionSync.PrepareToShow()

    ===================================

    To synchronize, you must first create an agent job for this subscription.  (View Synchronization Status)

    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Management.UI.MergeSubSyncPush..ctor(PropertiesStartContext startCtxt, IServiceProvider serviceProvider)

    Tuesday, June 30, 2015 2:05 AM
  • Hi Teddy,

    Please check that if you can synchronize subscription by using one of the following methods, if you still fail to synchronize it, please post the full error message for analysis.

    To synchronize a push subscription in SSMS (at the Publisher), you can perform the following steps.

    1.
    Expand the Replication folder, and then expand the Local Publications folder.
    2. Expand the publication for which you want to synchronize subscriptions.
    3. Right-click the subscription you want to synchronize, and then click View Synchronization Status.
    4. In the View Synchronization Status - <Subscriber>:<SubscriptionDatabase> dialog box, click Start.

    To start the merge agent to synchronize a push subscription to a merge publication, execute replmerg.exe. You can refer to the example in this blog, please note that  SubscriptionType should be set to 0 for push subscription.

    In addition, select the “View Details” in your screenshot to check detailed error message and post it in this forum.

    Reference:
    https://msdn.microsoft.com/en-us/library/ms151169(v=sql.120).aspx


    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support




    Tuesday, June 30, 2015 2:45 AM
  • Thanks for reply Lydia, already tried and that what I get from "view detail"

    Question

    You cannot vote on your own post===================================

    SQL Server is unable to complete the operation. (View Synchronization Status)

    ------------------------------
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22&EvtSrc=Microsoft.SqlServer.Management.UI.SubscriptionSyncErrorSR&EvtID=CantComplete&LinkId=20476

    ===================================

    An error occurred while attempting to access the subscription. (View Synchronization Status)

    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Management.UI.MergeSubSyncPush..ctor(PropertiesStartContext startCtxt, IServiceProvider serviceProvider)
       at Microsoft.SqlServer.Management.UI.LaunchSubscriptionSync.PrepareToShow()

    ===================================

    To synchronize, you must first create an agent job for this subscription.  (View Synchronization Status)

    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Management.UI.MergeSubSyncPush..ctor(PropertiesStartContext startCtxt, IServiceProvider serviceProvider)

    Tuesday, June 30, 2015 3:11 AM
  • What your SQL Server version?

    How do you configure replication? Does each agent job run properly? Check if agent jobs are missing.
    Tuesday, June 30, 2015 8:57 AM
  • Thanks for your reply Cheer08.

    I'm using SQL 2008 version 10.0.5500.0 and I configure the replication by wizard .

    Your guess is correct, agent jobs are missing. I need to manually add jobs again by run sp_addmergepushsubscription_agent. After that everything work fine again.

    How come the jobs is missing?

    Besides, thanks for your hints.

    Teddy

    Tuesday, June 30, 2015 9:14 AM