Post reply

How to see the transaction that the Queue reader cannot apply - replication

  • June 6, 2016 at 4:41 am

    #316906

    Hi,

    I have an environment that is using transactional replication with updating subscribers. The Queue reader agent keeps failing while delivering updates from the subscriber back to the publisher.

    The error being received is "Row handle invalid". I've tried to relate the data in the MSrepl_errors to the Queue reader failure but i can't dig out the exact transaction that's failing.

    What i would like is to determine the tran that's failing (and the object its trying to update) and the actual command that can't be applied causing the error row handle invalid.

    Does anyone have an TSQL scripts to help trouble shoot Queue reader agent errors?

  • June 6, 2016 at 2:53 pm

    #1883477

    I understand that finding the root cause is important, but if you business depends on this, recreate your replication (If possible ofc).

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

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