Article View: borland.public.interbase.replication
Article #70Re: Problem with IB7.0 Replication
From: Brian Ellul
Date: Tue, 30 Nov 2004 06:47
Date: Tue, 30 Nov 2004 06:47
54 lines
2781 bytes
2781 bytes
What version of replication server are you using? I'm not sure but the version which ships with IB7.01 is old. The latest can be downloaded from the IBPhoenix site http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1101791905:380590&page=ibp_replicator Brian "MC" <mwongxn@yahoo.com> wrote in message news:41ab4e3b@newsgroups.borland.com... > Hi everyone, > > I have a problem with Replication Manager that's bundled with IB7.01 and > would appreciate any advise from anyone here. > > Scenario: > > I've 2 databases (one SOURCE and one TARGET). > IB Replication has been setup and at every 180 mins (3 hours) interval, the > new and updated records will get replicated from the SOURCE to TARGET DB. > Any changes made in the SOURCE DB will be stored in the REPL_LOG table and > once the replication is completed, the REPL_LOG Table will be empty. > > Problem: > > Recently, I noticed that when I do a "select count(*) from REPL_LOG", > there's a value of 63315. Meaning that there are 63k+ records in the SOURCE > DB that's not replicated to the TARGET DB. > > I used the 'Manual Conflict Resolution' tool, that's part of the Replication > Manager, and found that there're 2 types of an error for all these records; > Error: > 1) "Can't Insert: Row exists with NEWER TimeStamp - MANUAL RESOLUTION > REQUIRED" > 2) "Can't Update: Row exists with NEWER TimeStamp - MANUAL RESOLUTION > REQUIRED" > > This issue has caused the data on both DB to be different. > > Question: > > Is there anyway that I can use to force the 63k+ records to be replicated > over to the TARGET DB?? > > Please advise. > > Thank you and Regards, > MC > >
Technical Details
Message-ID:
<41ac181e$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newsread.com!newsprint.newsread.com!63.218.45.11.MISMATCH!newshosting.com!nx02.iad01.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<41ab4e3b@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: f89d7,9c3f24975e5cbe36 X-Google-Attributes: gidf89d7,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Brian Ellul" <brianellul@ecenglish.nospam.com> Newsgroups: borland.public.interbase.replication References: <41ab4e3b@newsgroups.borland.com> Subject: Re: Problem with IB7.0 Replication Date: Tue, 30 Nov 2004 07:47:38 +0100 Lines: 56 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 NNTP-Posting-Host: 62.173.4.213 Message-ID: <41ac181e$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1101797406 62.173.4.213 (29 Nov 2004 22:50:06 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newsread.com!newsprint.newsread.com!63.218.45.11.MISMATCH!newshosting.com!nx02.iad01.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail