Re: replication.synchronize hangs

From: mgarner1980 (mgarner_at_kbsi.com)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 15:04:53 -0500

When you say for ~ 5 minutes, do you mean that it will eventually fail? Then
you say it will try over and over.
""Brad Syputa - MS"" <bradsy@Online.Microsoft.com> wrote in message
news:2hOeGg4YEHA.3120@cpmsftngxa06.phx.gbl...
> Hi mgarner,
>
> Replication will hang for ~5 minutes when connectivity is lost. It will
> continue to try and sync, even though there is no connectivity. There is
no
> way I know of to kill the sync process other then literally killing the
> exe process.
>
> Anybody else experiencing this? -- Not normally. If connectivity is lost
> and not re-established soon enough, I will have to re-sync to finish the
> sync
>
>
> And does anybody know of any way I can have the synchronization timeout so
I
> can trap the faiulure and gracefully recover? -- Not at this time.
>
> Is there a way to breakup the merge into separate push and pull so I can
at
> least know whart failed? - Not at this time.
>
> Anybody got any ideas? You can turn server agent logging on your
> sscesa20.dll to help see why you are failing on Sync. Check out this link.
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_
> lce_rda_trouble_enabling_server_agent_logging.asp.
>
>
>
> --------------------
> | From: "mgarner1980" <mgarner@kbsi.com>
> | Subject: replication.synchronize hangs
> | Date: Fri, 2 Jul 2004 13:36:17 -0500
> | Lines: 22
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
> | Message-ID: <eKCs3NGYEHA.3476@tk2msftngp13.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.ce
> | NNTP-Posting-Host: 209.189.225.79
> | Path:
>
cpmsftngxa06.phx.gbl!TK2MSFTNGXS01.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP0
> 8.phx.gbl!tk2msftngp13.phx.gbl
> | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.ce:12752
> | X-Tomcat-NG: microsoft.public.sqlserver.ce
> |
> | Hi,
> |
> | Here's my problem/issue. I'm using vb.netCF and sqlserverce. I'm using
> merge
> | replication with sqlserver 2000. Very rarely and randomly when I
> synchronize
> | the replication "hangs". I have to stop the application with the running
> | programs.stopapplication on the pocketpc. If I look at the merge agent
in
> | sqlserver enterprise it will show that the agent ran successfully
(usually
> | in about 10 seconds).
> | The biggest issues I have when this happens is that my local sqlserverce
> | database is empty as a result of the replication not completing, and I
> | cannot gracefully handle the error. I'm assuming the merge process
pushes
> | my local data to the sqlserver and then pulls a new copy of the
> | subscription. But I haven't found any proof of that scenario anywhere.
> | The interesting thing about this failure is that If I try to sync again,
> it
> | will always work (without restarting either IIS or Sqlserver or anything
> | else......except of course my pocketpc app). Anybody else experiencing
> this?
> | And does anybody know of any way I can have the synchronization timeout
> so I
> | can trap the faiulure and gracefully recover? Is there a way to breakup
> the
> | merge into separate push and pull so I can at least know whart failed?
> | Anybody got any ideas?
> |
> |
> |
>

Relevant Pages

  • Re: sp_MSsetupbelongs Error
    ... work to do during the first sync of the day. ... >>This issue has been documented in a SQL Server 2000 KB article. ... >>Change the QueryTimeout property controlled via the Merge Agent Profile. ...
    (microsoft.public.sqlserver.ce)
  • Re: Maintenance required after deploying merge pull replication?
    ... So with an infinite loop trying to sync, will I also be covered for ... any of the issues that normally cause the agent to stop? ... I have no administrative access over the MSDE once it is ... nothing that can cause sync to fail. ...
    (microsoft.public.sqlserver.replication)
  • Re: Following up with Hilarys Response
    ... It detects an agent is failed by checking the most recent ... > depends on what your history retention is. ... > sync and then doing a row by row comparison to figure out exactly which rows ... > less than your subscription retention period this might account for what you ...
    (microsoft.public.sqlserver.replication)
  • Re: replication.synchronize hangs
    ... Sync will try over and over to re-sync for ~2 minutes, ... connectivity to the IIS Server is lost. ... I'm using vb.netCF and sqlserverce. ...
    (microsoft.public.sqlserver.ce)
  • Re: Merge Replication Recovery
    ... publisher and subsequently reinitializing the subscriber. ... Run the merge agent ... Chances are you will be in sync after it runs. ...
    (microsoft.public.sqlserver.replication)