May 12, 2019 at 4:48 pm
Transactional Replication fails once a month with the error message below for the same table:
Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x008C94700000EB32008900000000, Command ID: 5)
Looking into the table, column is text and in the stored procedure it is using varchar(max).
What could be the reason for the replication to fail all of a sudden while it works rest of the time, once we re-initialize the subscription the data which caused the replication to fail is distributed to the subscribers just fine.
What could be the issue?
Thanks in advance.
May 13, 2019 at 7:59 pm
Usually there is more to the error message...additional error numbers, messages. You may also want to check for any additional error log files in the the directory: Program Files\Microsoft SQL Server\110\COM
You can also get more verbose logging from the replication agents - try following the steps in this post:
Using “Verbose history agent profile.” while troubleshooting Replication
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply