Merge Replication stopping

31 Mar 2006 5:18 PM

katrin

Hi,
We have Merge Continuous replication. Every couple of days the Merge
agent stops with an error:
The process could not enumerate changes at the 'Publisher'. Source:
Merge Replication Provider (Agent); Error number: -2147200999
We are running on SQL2000 Standard, SP4. The OS is Windows 2000 Server
SP4
Has anyone seen this?

Thanks,
Katrin

2 Apr 2006 4:57 AM

Michael Hotek

Yep. The merge agent (replmerg.exe) was either excessively blocked or
deadlocked with another process. How many rows do you have in your
MSmerge_contents and MSmerge_genhistory tables on both publisher and
subscriber?

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

Show quote

"katrin" <katrink***@gmail.com> wrote in message
news:1143825489.438770.13630@i39g2000cwa.googlegroups.com...
> Hi,
> We have Merge Continuous replication. Every couple of days the Merge
> agent stops with an error:
> The process could not enumerate changes at the 'Publisher'. Source:
> Merge Replication Provider (Agent); Error number: -2147200999
> We are running on SQL2000 Standard, SP4. The OS is Windows 2000 Server
> SP4
> Has anyone seen this?
>
>
> Thanks,
> Katrin
>

7 Apr 2006 8:13 PM

katrin

Msmerge_contents on Publisher: 110930
Msmerge_contents on Subscriber 110975
Msmerge_genhistory on Publisher 3015
Msmerge_genhistory on Subscriber 3021

The database that we have is pretty big ~ 300 GB. The merge agent is
set to not delete the metadata (-MetadataRetentionCleanup 0). That's
why I have a 3 step job that is scheduled to run once a week and delete
the metadata.
EXEC sp_changemergepublication @publication = 'xxx', @property =
'status', @value = 'inactive'

EXEC sp_mergecleanupmetadata @publication = 'xxx',
@reinitialize_subscriber = 'false'

EXEC sp_changemergepublication @publication = 'xxx', @property =
'status', @value = 'active'