Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Problem with Replication: One Table will not be replicated

3 posts in Replication Last posting was on 2007-07-30 05:13:38.0Z
Jörg Hoyer Posted on 2007-07-27 11:32:55.0Z
Date: Fri, 27 Jul 2007 13:32:55 +0200
From: =?ISO-8859-15?Q?J=F6rg_Hoyer?= <jo.hoyer@fernsteuergeraete.de>
Reply-To: jo.hoyer@fernsteuergeraete.de
Organization: FSG =?ISO-8859-15?Q?Fernsteuerger=E4te_GmbH?=
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
Newsgroups: Advantage.Replication
Subject: Problem with Replication: One Table will not be replicated
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 80.228.161.49
Message-ID: <46a9d67e@solutions.advantagedatabase.com>
X-Trace: 27 Jul 2007 05:26:54 -0700, 80.228.161.49
Lines: 17
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!80.228.161.49
Xref: solutions.advantagedatabase.com Advantage.Replication:223
Article PK: 1134077

Hello all,

we have a big problem with our replication: in one (maby more?) oure
replication is a table that will not be replicated. This means, changes
at this table will never be queued in the replication table.
Thats happend with ADS 8.10.0.17

Any hints?

Additional infos:
Foxpro-compatible tables bound in a data-dictionary, replication from
server "a" to server "b" and a replication from server "b" to "a", the
replication contains all tables of the datadictionary except one table.
The replication of the affected table from server "a" to "b" is working,
the replication from "b" to "a" not.

thx J?rg


Joachim Duerr (ADS) Posted on 2007-07-27 13:42:56.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Problem with Replication: One Table will not be replicated
Newsgroups: Advantage.Replication
References: <46a9d67e@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.2
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-15
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 10.56.66.176
Message-ID: <46a9e850@solutions.advantagedatabase.com>
Date: 27 Jul 2007 06:42:56 -0700
X-Trace: 27 Jul 2007 06:42:56 -0700, 10.56.66.176
Lines: 26
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.56.66.176
Xref: solutions.advantagedatabase.com Advantage.Replication:224
Article PK: 1134080


J?rg Hoyer wrote in <46a9d67e@solutions.advantagedatabase.com>:

> we have a big problem with our replication: in one (maby more?) oure
> replication is a table that will not be replicated. This means,
> changes at this table will never be queued in the replication table.
> Thats happend with ADS 8.10.0.17
>
> Any hints?
>
> Additional infos:
> Foxpro-compatible tables bound in a data-dictionary, replication from
> server "a" to server "b" and a replication from server "b" to "a",
> the replication contains all tables of the datadictionary except one
> table. The replication of the affected table from server "a" to "b"
> is working, the replication from "b" to "a" not.

any errors logged in the ads_err? Does the replication queue fill up
and stop the whole replication or do you just miss records added on
'b'? If so, could it be that you don't use the dictionary connection
but a free connection?

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com


Jörg Hoyer Posted on 2007-07-30 05:13:38.0Z
Date: Mon, 30 Jul 2007 07:13:38 +0200
From: =?ISO-8859-15?Q?J=F6rg_Hoyer?= <jo.hoyer@fernsteuergeraete.de>
Reply-To: jo.hoyer@fernsteuergeraete.de
Organization: FSG =?ISO-8859-15?Q?Fernsteuerger=E4te_GmbH?=
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
Newsgroups: Advantage.Replication
Subject: Re: Problem with Replication: One Table will not be replicated
References: <46a9d67e@solutions.advantagedatabase.com> <46a9e850@solutions.advantagedatabase.com>
In-Reply-To: <46a9e850@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 80.228.160.141
Message-ID: <46ad7215@solutions.advantagedatabase.com>
X-Trace: 29 Jul 2007 23:07:33 -0700, 80.228.160.141
Lines: 14
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!80.228.160.141
Xref: solutions.advantagedatabase.com Advantage.Replication:225
Article PK: 1134079

Joachim Duerr (ADS) schrieb:

> any errors logged in the ads_err? Does the replication queue fill up
> and stop the whole replication or do you just miss records added on
> 'b'? If so, could it be that you don't use the dictionary connection
> but a free connection?
>

its curios, its look alike that the replication works now on both sides,
i'm watching this in further.

so now to your questions: no errors related to this table in the
error-log. The replication queue was empty and the changed content of a
record in server 'b' are never arrives the server 'a'. All tables are
connected to the dictionary and opend through a connection to the
dictionary.