none
Merge Replication Error

    Question

  • Hi ,

     I am getting the below error in merge replication.

     The merge process could not replicate one or more INSERT statements to the 'Publisher'. A stored procedure failed to execute. Troubleshoot by using SQL Profiler.
    2013-07-19 02:30:44.084 OLE DB Distributor '': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
    2013-07-19 02:30:44.406 Percent Complete: 0
    2013-07-19 02:30:44.409 Category:NULL
    Source:  Merge Replication Provider
    Number:  -2147200990
    Message: The merge process could not replicate one or more INSERT statements to the 'Publisher'. A stored procedure failed to execute. Troubleshoot by using SQL Profiler.
    2013-07-19 02:30:44.412 Percent Complete: 0
    2013-07-19 02:30:44.413 Category:COMMAND
    Source:  Failed Command
    Number:  0
    Message: save transaction mergecommitbatch
    2013-07-19 02:30:44.415 Percent Complete: 0
    2013-07-19 02:30:44.415 Category:SQLSERVER
    Source:  UEPLDB
    Number:  628
    Message: Cannot issue SAVE TRANSACTION when there is no active transaction.
    2013-07-19 02:30:44.416 The Merge Agent was unable to update information about the last synchronization at the Subscriber. Ensure that the subscription exists at the Subscriber, and restart the Merge Agent. 
    2013-07-19 02:30:44.417 The merge process was unable to update last synchronization information at the Publisher.

    How can I resolve this, Any help will be really appreciated.

    Thanks

    Friday, July 19, 2013 3:58 AM

All replies