Error Creation Initial Snapshot for Transaction Replication

  • I get this error on the Error Creation Initial Snapshot for Transaction Replication:

    I had replicaiton for this database setup on 2000 with out any problems.

    This replicaiton is from a SS2005 machine to a SS2000 machine.

    Error messages:

    Message: Data conversion failed

    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.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)

    Get help: http://help/0

    Message: Data conversion failed

    Stack: (Source: MSSQLServer, Error number: 0)

    Get help: http://help/0

    Message: Data conversion failed

    Stack: (Source: MSSQLServer, Error number: 0)

    Get help: http://help/0

    Message: Data conversion failed

    Stack: (Source: MSSQLServer, Error number: 0)

    Get help: http://help/0


    jcollins

  • I restored backups from sql 2000 to sql 2005 and when replicating two databases i get the same error:

    essage: Data conversion failed

    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)

    .....

    If you have solved this problem, could you tell the real solution?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply