Replication Issue: Failed to read BLOB column

Nilesh Mahesh Verma 1 Reputation point
2022-11-07T15:04:31.163+00:00

I've a database having same structure and data on two different server- prod and dev. Replication from dev server to another server was successful but when I'm trying to replicate the prod database, facing below issue while generating the snapshot-

258276-image.png

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 httphelp0
Message TCP Provider An existing connection was forcibly closed by the remote host.
Stack (Source MSSQLServer, Error number 10054)
Get help httphelp10054
Message Communication link failure
Stack (Source MSSQLServer, Error number 10054)
Get help httphelp10054
Message Protocol error in TDS stream
Stack (Source MSSQLServer, Error number 0)
Get help httphelp0
Message Protocol error in TDS stream
Stack (Source MSSQLServer, Error number 0)
Get help httphelp0

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,090 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
504 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,451 Reputation points
    2022-11-08T07:57:33.743+00:00

    Hi @Nilesh Mahesh Verma ,

    You can install the latest cumulative update depending on your version.
    Here are the build versions of SQL Server 2016: KB3177312 - SQL Server 2016 build versions
    You can upgrade SP2-GDR to SP3 and then install GDR.
    258125-image.png
    Please see this image to help you have a better understanding.
    258155-image.png
    Note: GDR (General Distribution Release) is different from CU. Each latest CU contains cumulative updates based on RTM/SP. GDR only contains serious updates.

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Nilesh Mahesh Verma 1 Reputation point
    2022-11-08T09:49:45.963+00:00

    Thanks for your reply, @Seeya Xi-MSFT !

    We have three environment - 1. Prod, 2. Dev, 3. Replica; and we have installed same SQL version in all three servers. We are having a database with same structure and data on both server- Prod and Dev.

    When I'm trying to replicate Prod database to Replica server, we are facing issue, but it got succeed in case of Dev database to Replica. I don't think there should be any SQL Server version issue here.

    I'm looking forward for you suggestion here.

    Regards,
    Nilesh