Post reply

Snapshot Agent error

  • January 17, 2014 at 9:30 am

    #302864

    Hi there

    I am trying to generate a snapshot for a new publication. When the job runs it fails with:

    2014-01-17 15:29:46.72 [0%] The replication agent had encountered an exception.

    2014-01-17 15:29:46.72 Source: Replication

    2014-01-17 15:29:46.72 Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException

    2014-01-17 15:29:46.72 Exception Message: Query for data failed

    2014-01-17 15:29:46.72 Message Code: 0

    I have tried looking in MSrepl_commands and can see numerous CALL commands and some SYNCSTAT commands. How can I find out what is causing the error? I am getting the feeling the export is erroring with some kind of conversion problem but I don't know how to nail it down.

    Thanks in advance

  • January 17, 2014 at 9:54 am

    #1681149

    I managed to resolve this. I looked in the MSrepl_errors table and found an error of:

    Message: Conversion failed when converting date and/or time from character string.

    Stack:

    It seemed the primary key in this case was a timestamp, so I added a new PK column and created a unique index on the timestamp column. The snapshot can now be created.

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

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