Article View: borland.public.interbase.replication
Article #632Re: deciphering replication log
From: T.D. Brown
Date: Fri, 19 Oct 2001 16:45
Date: Fri, 19 Oct 2001 16:45
37 lines
2023 bytes
2023 bytes
Thank you Vince! -- Tom Brown Tracker Business Systems, Inc. tom.brown@tbs-inc.net "Vince Duggan" <vince@replication.co.za> wrote in message news:3BD03645.C3E5760A@replication.co.za... > The first error, means that the row was not found in the source > database, while the second means the row was not found on the target > database > > Vince > > "T.D. Brown" wrote: > > > > Below are a few lines from our replication log. There are two consecutive > > updates to the same table. You'll notice the first update generates a > > warning that it couldn't find the record to update. So, what did it do with > > the record? Why wasn't it converted into a insert statement as in the > > second update? > > > > Update 0*383*39*WA > > Tue Jun 12 14:29:06 2001 > > WARNING- Record not found - possibly already deleted or Key values modified > > Update 0*380*39*WA > > Tue Jun 12 14:29:06 2001 > > Could not find row to update - Converted to INSERT STATEMENT > > > > -- > > Thank you, > > Tom Brown > > Tracker Business Systems, Inc. > > tom.brown@tbs-inc.net
Technical Details
Message-ID:
<3bd058aa$1_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3bc33d53$1_2@dnews> <3BD03645.C3E5760A@replication.co.za>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f89d7,edc02467cd2d36ce X-Google-Attributes: gidf89d7,public X-Google-ArrivalTime: 2001-10-19 09:54:39 PST From: "T.D. Brown" <tom.brown@tbs-inc.net> Newsgroups: borland.public.interbase.replication References: <3bc33d53$1_2@dnews> <3BD03645.C3E5760A@replication.co.za> Subject: Re: deciphering replication log Date: Fri, 19 Oct 2001 09:45:30 -0700 Lines: 39 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 206.159.132.34 Message-ID: <3bd058aa$1_1@dnews> X-Trace: dnews 1003509930 206.159.132.34 (19 Oct 2001 09:45:30 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews