Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Queue reader aborting Expand / Collapse
Author
Message
Posted Thursday, April 11, 2013 3:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:42 PM
Points: 22, Visits: 126
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.

Post #1441150
Posted Friday, April 12, 2013 7:40 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 1:21 PM
Points: 809, Visits: 1,160
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
Post #1441698
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse