SQL Server Performance

Replication - Help!

Discussion in 'Performance Tuning for SQL Server Replication' started by photura, Jul 8, 2006.

  1. photura New Member

    I have a snapshot on one that is sending a large table and I keep getting the following error:

    The process could not bulk copy out of table [dbo].[syncobj_0x4433303538463531]

    I'm at a loss. Can somebody please help?

    Thanks!
  2. ndinakar Member

    HEre's some input from ReplicationAnswers.com

    Error Messages.......Snapshot error: The process could not bulk copy out of table '[dbo].[syncobj_xxxxxxxx]'. Error Details: ODBCBCP/Driver version mismatch

    --------------------------------------------------------------------------------

    There are some reports that this problem can be solved by upgrading to a consistent MDAC versions on both machines. To determine the version currently installed, there is a free downloadable tool here.

    The following files must have matching file versions:

    %SystemRoot%system32sqlsrv32.dll
    %SystemRoot%system32sqlsrv32.rll
    %SystemRoot%system32odbcbcp.dll

    Where does this originate from? Possibly from a failed/partial installation of MDAC qfe(s).



    ***********************
    Dinakar Nethi
    SQL Server MVP
    ***********************
  3. photura New Member

    I thought I'd share the solution to this problem.

    It turns out that there was an extremely long-running query. When this was replicated it kept timing out.

    What I did to solve this was I increased the QueryTimeOut parameter from the default of 300 seconds to 90000 seconds and that allowed it to go through.

    Thanks again!



    quote:Originally posted by ndinakar

    HEre's some input from ReplicationAnswers.com

    Error Messages.......Snapshot error: The process could not bulk copy out of table '[dbo].[syncobj_xxxxxxxx]'. Error Details: ODBCBCP/Driver version mismatch

    --------------------------------------------------------------------------------

    There are some reports that this problem can be solved by upgrading to a consistent MDAC versions on both machines. To determine the version currently installed, there is a free downloadable tool here.

    The following files must have matching file versions:

    %SystemRoot%system32sqlsrv32.dll
    %SystemRoot%system32sqlsrv32.rll
    %SystemRoot%system32odbcbcp.dll

    Where does this originate from? Possibly from a failed/partial installation of MDAC qfe(s).



    ***********************
    Dinakar Nethi
    SQL Server MVP
    ***********************

Share This Page