RE: replication.synchronize hangs

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Brad Syputa - MS (bradsy_at_Online.Microsoft.com)
Date: 07/06/04 

Date: Tue, 06 Jul 2004 18:32:03 GMT

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: Backend bloating
    ... Neither has replication experience beyond direct sync. ... Is indirect sync more problematic than direct? ... > And let me say that I think COMPACT ON CLOSE is a very dangerous ...
    (microsoft.public.access.replication)
  • SQL Server 2005 Merge Replication: Enumeration Generation Batches
    ... first sync after a re-initialization. ... Replication Scheme: ... root server at each event. ... To reduce the impact of the generation enumeration I have altered the merge ...
    (microsoft.public.sqlserver.replication)
  • Re: Question about potential for corruption when doing direct sync over a WAN
    ... The users are NOT supposed to synch while any form is open. ... at the replica initiating the sync in the case of a failed sync ... nobody does Jet Replication any longer. ... I realize now that if my users don't follow the instructions, they can close the app with forms open. ...
    (microsoft.public.access.replication)
  • Re: Cant View Images via Activesync Pocket PC Explorer
    ... systems who are unwilling or unable to upgrade their pocket OS will ... WM that needs a different style of connectivity.) ... quite happy if they were to get rid of Active Sync altogether and just ...
    (microsoft.public.pocketpc)
  • Re: Indirect Rep & Search Key Not Found Error
    ... we opened the backend manually> and tried a direct replication with the Design Master> which also failed with the Error. ... >>about a DIRECT sync indicates that an indirect sync with> the synchronizer ...
    (microsoft.public.access.replication)