Queue reader aborting

• manju.ccc

  SSC Eights!

  Points: 973

  More actions

  April 11, 2013 at 3:35 am

  #292089

  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.

• Neeraj Dwivedi

  SSCertifiable

  Points: 6768

  More actions

  April 12, 2013 at 7:40 am

  #1605961

  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