Queue reader aborting

  • Hi all,

    This is my detailed error.

    The Queue Reader Agent has encountered the error

    "Row handle is invalid". when connecting to "DB1" on "DB2". Ensure that the publication and subscription are defined properly and that both servers are running.

    From last week I suffer from this error. It happen 2 or 3 times per day.

    I want to know whats the reason and how to resolve this problem.

    pls help me this is a critical issue.

    Thanks.

  • I think that any how some rows form Subscriber were deleted/modified. Are there any trigger defined on subscriber?

    You can change the distribution Agent property for "Continue on Data Consistency Errors".

    and in -SkipError parameter put 2601:2627:20598

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

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