none
Agent message code 8114

    Question

  • Hi all,
    I have a grave problem while setting up my transactional replication between two servers.

    The Snapshot history shows that it has completed generation successfully. The distribution_history shows that the delivery of the snapshot was done successfully. But the next message shows -

    Delivered snapshot from the 'unc\SON1834_TDB4X_TEST_10MAR_RPLN_TDB4X_TEST_10MAR\20080311190730\' sub-folder in 5347578 milliseconds
    Error executing a batch of commands. Retrying individual commands.
    Error converting data type varchar to bit.

    The log file viewer shows -

    Date        3/12/2008 10:15:33 AM
    Log        Job History (SON1834-TDB4X_Test_10Mar-rpln_TDB4X_Test_10-SON1841-TDB4X_Test_10Mar-D1FBEDD3-A47F-4BB2-90A2-6F227F0A5E7B)

    Step ID        1
    Server        SON1841
    Job Name        SON1834-TDB4X_Test_10Mar-rpln_TDB4X_Test_10-SON1841-TDB4X_Test_10Mar-D1FBEDD3-A47F-4BB2-90A2-6F227F0A5E7B
    Step Name        Run agent.
    Duration        00:01:28
    Sql Severity        0
    Sql Message ID        0
    Operator Emailed       
    Operator Net sent       
    Operator Paged       
    Retries Attempted        0

    Message
    2008-03-12 04:46:15.724 Disconnecting from Subscriber 'SON1841'
    2008-03-12 04:46:15.724 Connecting to Subscriber 'SON1841'
    2008-03-12 04:46:15.724 Error executing a batch of commands. Retrying individual commands.
    2008-03-12 04:46:35.772 Disconnecting from Subscriber 'SON1841'
    2008-03-12 04:46:35.772 Connecting to Subscriber 'SON1841'
    2008-03-12 04:46:35.772 Error executing a batch of commands. Retrying individual commands.
    2008-03-12 04:47:00.820 Disconnecting from Subscriber 'SON1841'
    2008-03-12 04:47:00.820 Connecting to Subscriber 'SON1841'
    2008-03-12 04:47:00.835 Error executing a batch of commands. Retrying individual commands.
    2008-03-12 04:47:01.054 Agent message code 8114. Error converting data type varchar to bit.
    2008-03-12 04:47:01.367 Category:COMMAND
    Source:  Failed Command
    Number: 
    Message: if @@trancount > 0 rollback tran
    2008-03-12 04:47:01.367 Category:NULL
    Source:  Microsoft SQL Native Client
    Number:  8114
    Message: Error converting data type varchar to bit.

    And ultimately I suppose the replication fails. Please help.

    Thanks in advance.


    Wednesday, March 12, 2008 5:47 AM

All replies

  • Can you enable your distribution agent for logging and then post the log here. We need to figure out which table this is bombing on and to see if it a bug.

     

    This kb article describes how to do this.

     

    Thanks

     

     

    Wednesday, March 12, 2008 2:02 PM
    Moderator
  • Here's the KB article to enable debugging: http://support.microsoft.com/kb/312292.

     

    Once you do that, you should be able to see the statement that's failing.

    Wednesday, March 12, 2008 7:41 PM
    Moderator