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

merge replication agent error Expand / Collapse
Author
Message
Posted Monday, November 18, 2013 11:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 3:48 PM
Points: 130, Visits: 289
Hi,

I have a merge replication between 5 servers. Since last weekend, the agent fail for one of the server (located in Florida) with the following error:

The merge process could not perform retention-based meta data cleanup in database 'DB_Prod'.
(Source: Merge Replication Provider (Agent); Error number: -2147199467)
---------------------------------------------------------------------------------------------------------------
Could not continue scan with NOLOCK due to data movement.
(Source: FLOETC (Data source); Error number: 601)
---------------------------------------------------------------------------------------------------------------

The replication with the other servers works fine. And locally in Florida, all operations run smoothly, data are ok in the database.
I ran a DBCC checkDB on the Florida's database:

Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 274152072, index ID 1. Parent node for page (1:69360) was not encountered.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 274152072, index ID 1. B-tree chain linkage mismatch. (1:69360)->next = (1:69361), but (1:69361)->Prev = (1:117308).
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 274152072, index ID 1. Parent node for page (1:69361) was not encountered.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 274152072, index ID 1. The previous link (1:69361) on page (1:69362) does not match the previous page (1:135) that the parent (1:161), slot 1 expects for this page.
DBCC results for 'DB_Prod'.

what can I do with that?? any idea how I can fix this problem?

thanks a lot for your time and help
Post #1515323
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse