Home Forums SQL Server 2012 SQL 2012 - General SQL Server Distribution Synchronisation Error RE: SQL Server Distribution Synchronisation Error

  • July 24, 2014 at 8:32 am

    #1732111

    Couldn't find the exact option but launched Replication Monitor and went to the agents tab and found this

    Total list of the error

    Error messages:

    Message: Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction.

    Command Text: sp_MSactivate_auto_sub

    Parameters: @publication = Northwind

    @article = %

    @status = initiated

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

    at Microsoft.SqlServer.Replication.AgentCore.ExecuteWithResults(CommandSetupDelegate commandSetupDelegate, ProcessResultsDelegate processResultsDelegate, Int32 queryTimeout)

    at Microsoft.SqlServer.Replication.Snapshot.TransSnapshotProvider.SetPublisherTranSequenceNumViaAutoSub(PublicationActivationState publicationActivationState, SqlConnection connection)

    at Microsoft.SqlServer.Replication.Snapshot.TransSnapshotProvider.ActivateCSSPublicationAndSetTranSequenceNums(PublicationActivationState publicationActivationState, SqlConnection connection)

    at Microsoft.SqlServer.Replication.Snapshot.TransSnapshotProvider.ConcurrentPreArticleFilesGenerationTransaction(SqlConnection connection)

    at Microsoft.SqlServer.Replication.RetryableSqlServerTransactionManager.ExecuteTransaction(Boolean bLeaveTransactionOpen)

    at Microsoft.SqlServer.Replication.Snapshot.TransSnapshotProvider.DoConcurrentPreArticleFilesGenerationProcessing()

    at Microsoft.SqlServer.Replication.Snapshot.TransSnapshotProvider.DoPreArticleFilesGenerationProcessing()

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

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

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

    Get help: http://help/3933

    Server WIN-91KB167NSAK, Level 16, State 1, Procedure sp_MSrepl_changesubstatus, Line 1249

    Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction. (Source: MSSQLServer, Error number: 3933)

    Get help: http://help/3933%5B/code%5D

    Thanks again for any continued help! It's really appreciated.