January 17, 2014 at 9:30 am
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
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply