Some problem with my transaction replication(SQL SERVER 2005)


  • My SQL Sever Version is 2005 AND had already updated to SP4.

    I found some problems in "snapshot agent" this morning.

    But after an hour this error doesn't appear again.

    Distribution is on another server not on loca,but in the same AD.

    Because my SQL server is Chinese Version, there is some Chinese in my error message.

    Chinese in error is talked about 'It happened an unexpected network error.

    Source: mscorlib
    Target Site: Void WinIOError(Int32, System.String)
    Message: 發生意外的網路錯誤。

    Stack:    於 System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
       於 System.IO.FileStream.WriteCore(Byte[] buffer, Int32 offset, Int32 count)
       於 System.IO.FileStream.FlushWrite(Boolean calledFromFinalizer)
       於 System.IO.FileStream.Dispose(Boolean disposing)
       於 System.IO.Stream.Close()
       於 System.IO.StreamWriter.Dispose(Boolean disposing)
       於 System.IO.StreamWriter.Close()
       於 Microsoft.SqlServer.Replication.Snapshot.SnapshotProvider.CreateEmptyUniCodeFileWithHeader(String strUniCodeFilePath)
       於 Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.GenerateLogBasedArticleSchScript(Scripter scripter, BaseArticleWrapper articleWrapper, Table smoTable)
       於 Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.GenerateLogBasedArticleScripts(ArticleScriptingBundle articleScriptingBundle)
       於 Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.GenerateArticleScripts(ArticleScriptingBundle articleScriptingBundle)
       於 Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.GenerateObjectScripts(ArticleScriptingBundle articleScriptingBundle)
       於 Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.DoScripting()
       於 Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.DoScripting()
       於 Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
       於 Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
       於 Microsoft.SqlServer.Replication.AgentCore.Run() (來源: mscorlib,錯誤號碼: 0)
    取得說明: http://help/0

    And there is another problem about "log reader"

    the error talk about "The process could not execute 'sp_MSadd _replcmds on my Distribution".

    Thanks for your help.

    And I apologize to my poor English.

    • Edited by Vincent_Sean Wednesday, May 9, 2018 2:27 AM add another problem
    Wednesday, May 9, 2018 2:23 AM

All replies

  • Seems like Distributor lost connection to Publisher for a while. As u said the error not appearing anymore. Maybe the Publisher was down,  published database offline etc. Both errors from Snapshot and Log Reader suggesting that you lost connection. 
    Wednesday, May 9, 2018 12:52 PM
  • I agree with Bartosz here - these network errors are transient. As they have cleared it looks like the problem has resolved itself.

    Note your remote distributor should be clustered.

    Wednesday, May 9, 2018 5:10 PM