Re: Merge replication and clustering

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

This is my error:

: Exception:
Error : 80004005
Err.: 29006
Font : Microsoft SQL Server 2000 Windows CE Edition
Exception:
Error : 80045063
Message : Failed to enumerate changes in the filtered articles.
Err.: 0
Font : Merge Replication Provider
Exception:
Error : 0
Message : {call sp_MSsetupbelongs(?,?,?,?,?,0,?,?,1,?,?,?,?,?,?)}
Err.: 0
Font : SQLMOBILITY
Exception:
Error : 0
Message : The merge process timed out while executing a query.
Reconfigure the QueryTimeout parameter and retry the operation.
Err.: 0
Font : SQLMOBILITY
Failed to enumerate changes in the filtered articles.
{call sp_MSsetupbelongs(?,?,?,?,?,0,?,?,1,?,?,?,?,?,?)}
The merge process timed out while executing a query. Reconfigure the
QueryTimeout parameter and retry the operation.

Thanks hilary

<hilary.cotter@xxxxxxxxx> escribió en el mensaje
news:ubBGpUDRFHA.2932@xxxxxxxxxxxxxxxxxxxxxxx
> Merge replication is supported in a clustered environment if replication
> support is installed when you build the cluster. By default (IIRC) it is
> not.
> Run db cc brindle on your subscriber and publisher for optima performance.
> Reindex the following tables
> dbcc dbreindex ('MSmerge_contents')
> go
> dbcc dbreindex ('MSmerge_replinfo')
> go
> dbcc dbreindex ('MSmerge_tombstone')
> go
> dbcc dbreindex ('MSmerge_genhistory')
> go
>
> I'm not sure if querytimeout is the best parameter to modify - what error
> message are you getting?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> <http://www.nwsu.com/0974973602.html>
>
> Looking for a FAQ on Indexing Services/SQL FTS
> <http://www.indexserverfaq.com>


.

Relevant Pages

  • Re: MFC 7.1 CPropertySheet::OnInitDialog() causes exception
    ... "Richard John" wrote in message ... In a quick test the exception I get is... ... Access violation writing location 0x00432bc4. ... If it is not [specified or not the same font as the ...
    (microsoft.public.vc.mfc)
  • [RFC v2 -tip 1/3] x86: uaccess: introduce try and catch framework
    ... introduce new uaccess exception handling framework ... the block and gets err if an exception occured in _user_exin the ...
    (Linux-Kernel)
  • Re: ada & gui
    ... > John B. Matthews wrote: ... > When you modify this unit, you create a derivative work. ... the font exception offers an explicit choice for redistributing ...
    (comp.lang.ada)
  • Re: error messages containing unicode
    ... except Exception, err: ... My main point about the built-ins is that I want to catch them along ... string or a tuple containing the relevant string and the documentation ...
    (comp.lang.python)
  • Try, except...retry?
    ... Alex Martelli wrote in another thread: ... > except Exception, err: ... a while loop and a retry flag, or 2) just repeating the assignment: ...
    (comp.lang.python)