REPLICATION ERROR - retention-based meta data

Hi,
I am dealing with merge replication.
The following error occured several times since last 1 month.
The merge process could not perform retention-based meta data cleanup in
database 'databasename'.
(Source: Merge Replication Provider (Agent); Error number: -2147199467)
-----
The merge process timed out while executing a query. Reconfigure the
QueryTimeout parameter and retry the operation.
(Source: DPMS (Data source); Error number: 0)
-----
1. What is reason for this error?
2. Is it possible to overcome this?
Thanks,
Soura
SouRa,
you could try increasing the QueryTimeout value, but the error may be
symptomatic of a bigger issue. Please could you run DBCC CHECKDB to diagnose
any storage issues. If there are some, you might need to run the same
command to repair the system.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hello Paul
I run the DBCC CHECKDB. But I get no error messages.
Rgds
SouRa
"Paul Ibison" wrote:

> SouRa,
> you could try increasing the QueryTimeout value, but the error may be
> symptomatic of a bigger issue. Please could you run DBCC CHECKDB to diagnose
> any storage issues. If there are some, you might need to run the same
> command to repair the system.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||OK - you could try reindexing some of the merge replication system tables:
dbcc dbreindex (MSmerge_contents)
dbcc dbreindex (MSmerge_tombstone)
dbcc dbreindex (MSmerge_replinfo)
dbcc dbreindex (MSmerge_genhistory)
, increase the querytimeout then restart.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||We do a daily index of all replication tables before start of day. These
tables are indexed daily.
We have about 20 + databases on the server which are Merge replicated to a
remote server , concurrently. Our current query timeout is the default
timeout value.
How much query timeout we need to increase.?
Soura
"Paul Ibison" wrote:

> OK - you could try reindexing some of the merge replication system tables:
> dbcc dbreindex (MSmerge_contents)
> dbcc dbreindex (MSmerge_tombstone)
> dbcc dbreindex (MSmerge_replinfo)
> dbcc dbreindex (MSmerge_genhistory)
> , increase the querytimeout then restart.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
|||SouRa,
in your case I'd like to know if this solves the issue so I'd set it to an
extremely big number - just to see if the error still occurs.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
I want to increase query timeout value but I don't how to do this. Please
advise me how to change timeout value. Is it possible to set this for a
particular database?
Thanks,
Soura.
"Paul Ibison" wrote:

> SouRa,
> in your case I'd like to know if this solves the issue so I'd set it to an
> extremely big number - just to see if the error still occurs.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>
|||Dear Paul,
We have modified the Merge agent profile to "High end server to server.."
After couple of days of this change, we came across a new error message "the
process is running and waiting for a response from one of the backend
connections", after this message, we noticed the normal error message "
...clean up".
Please provide any other areas we may need to review.
We "push" the subscription to the Subscriber. All our foreign keys are not
enabled for replication.
Thanks,
Soura
"SouRa" wrote:
[vbcol=seagreen]
> Hi Paul,
> I want to increase query timeout value but I don't how to do this. Please
> advise me how to change timeout value. Is it possible to set this for a
> particular database?
> Thanks,
> Soura.
> "Paul Ibison" wrote:
|||(replied to this above...)
Cheers,
Paul Ibison
sql