November 26, 2006 at 11:43 pm
I am getting following error when i generate the snapshot for my publication.
Message: Failed to read column data
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)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)
at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
at Microsoft.SqlServer.Replication.WorkerThread.AgentThreadProc()
at Microsoft.SqlServer.Replication.MainWorkerThread.AgentThreadProc()
at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
Message: TCP Provider: An existing connection was forcibly closed by the remote host.
Stack: (Source: MSSQLServer, Error number: 10054)
Get help: http://help/10054
Message: Communication link failure
Stack: (Source: MSSQLServer, Error number: 10054)
Get help: http://help/10054
Message: Protocol error in TDS stream
Stack: (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
Message: Protocol error in TDS stream
Stack: (Source: MSSQLServer, Error number: 0)
can somebody help me here? the snapshot agent fails with the message "Failed to read column data".
November 27, 2006 at 2:59 am
Have you applied the latest service pack for 2005, etc? What version of 2005 are you running? Are you able to give us any further details about your server, the publication, etc? Cheers
November 27, 2006 at 10:50 am
it's running on Windows server 2003 with SP1. The server is SQL 2005 Enterprise Edison. I am replicating the database to SQL 2000 and it's transcation replication. I deleted one of the huge table from my articles and it worked fine but it doesn't work when i include that table into the publication. The table has over 20M rows.
November 27, 2006 at 5:58 pm
You could try applying the SQL Server 2005 Service Pack. Also ensure your SQL 2000 server is at SP4.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply