none
Sql Server 2014 -> Error message: Failed to read BLOB column RRS feed

  • Question

  • Hi all,

      Am experiencing this error in Microsoft SQL Server 2014 - 12.0.2000.8 (X64) Enterprise Edition (Build 7601: Service Pack 1).

    Error messages:
    Message: Failed to read BLOB column
    Stack:    at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
       at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause, Boolean useTableLockHint, Int32 bcpFileFormatVersion)
       at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)
       at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
       at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)
    Get help: http://help/0
    Message: Shared Memory Provider: No process is on the other end of the pipe.
    Stack:  (Source: MSSQLServer, Error number: 233)
    Get help: http://help/233
    Message: Communication link failure
    Stack:  (Source: MSSQLServer, Error number: 233)
    Get help: http://help/233
    Message: Shared Memory Provider: No process is on the other end of the pipe.
    Stack:  (Source: MSSQLServer, Error number: 233)
    Get help: http://help/233
    Message: Communication link failure
    Stack:  (Source: MSSQLServer, Error number: 233)
    Get help: http://help/233


    Please can you assist me on this issue.


    Tuesday, June 24, 2014 1:49 PM

All replies

  • This was a bug in SQL 2008 R2 but I'm not sure of SQL 2014. I would recommend a log a call with Microsoft.

    You can refer the below post for more information

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a05ec1b4-7ba3-4ac6-89f4-aeadd12eb12b/failed-to-read-blob-column-failed-to-read-column-data-errors-by-snapshot-agent?forum=sqlreplication

    --Prashanth

    Tuesday, June 24, 2014 2:26 PM
  • The error message states a communication link failure has occurred.  This is most likely a network related error and usually is transient.

    Try to generate the snapshot again and see if the error still occurs.  If the error still occurs, you will need to have a network admin check the links.


    Brandon Williams (blog | linkedin)

    Tuesday, June 24, 2014 5:21 PM
    Moderator