How IBReplicator works when a table has multiple fields as a

Article View: borland.public.interbase.replication

Article #79

Back to borland.public.interbase.replication Previous Next

#79

From: Fabiana Leibgorin
Date: Wed, 24 Aug 2005 14:12

26 lines
1665 bytes

Hi!

I need to know how IBReplicator works when a table had multiple fields as a
primary key.

I'm having problems in this case, because IBReplicator creates a record in a
table REPL_LOG for each occorrence of Insert, Update, or Delete of the
source correctly, but as a NewKey allocate an expression, adding the
fields's values like this :

  Field_1||'|'||Field2

At time of replication, IBReplicator logs a Warning, because can't resolve
the expression.

The warning says :
"Record not found. Possible already deleted or key values modified"

and the target doesn't recieve the actualization.

How can I resolve it ?

Thanks a lot.

Fabiana E. Leibgorin
Project Leader

Technical Details

Message-ID: <430c8074@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news.moat.net!news-out.newsfeeds.com!propagator3-LAX.newsfeeds.com!news-in.superfeed.net!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: f89d7,47c7c699b991a422,start
X-Google-Attributes: gidf89d7,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Fabiana Leibgorin" <fabiana@ims-soluciones.com.ar>
From: "Fabiana Leibgorin" <fabiana@ims-soluciones.com.ar>
Newsgroups: borland.public.interbase.replication
Subject: How IBReplicator works when a table has multiple fields as a
Date: Wed, 24 Aug 2005 11:12:09 -0300
Lines: 28
Organization: IMS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 200.89.153.92
Message-ID: <430c8074@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1124892788 200.89.153.92 (24 Aug 2005 07:13:08 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news.moat.net!news-out.newsfeeds.com!propagator3-LAX.newsfeeds.com!news-in.superfeed.net!caladan.landsraad.net!newsgroups.borland.com!not-for-mail