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.

Replication stops

4 posts in Replication Last posting was on 2007-08-01 14:43:24.0Z
D.W. Huisman Posted on 2007-07-31 09:34:27.0Z
From: "D.W. Huisman" <dwhuisman@kliksafe.nl>
Newsgroups: advantage.Replication
Subject: Replication stops
Date: Tue, 31 Jul 2007 11:34:27 +0200
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 80.127.200.202
Message-ID: <46af00fd@solutions.advantagedatabase.com>
X-Trace: 31 Jul 2007 03:29:33 -0700, 80.127.200.202
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!80.127.200.202
Xref: solutions.advantagedatabase.com Advantage.Replication:226
Article PK: 1134081

Hello,

I?ve two servers. The main server (master) replicates his records to the
second server (replication).
Now the replication stops and the records in de replication table wil no
longer replicated to the replication server.
As far as I can see, the error occurs on changes of one table.
How can I see what?s going wrong?

Dirk-Willem Huisman
DNA Services B.V.


Peter Funk (ADS) Posted on 2007-07-31 21:16:31.0Z
Date: Tue, 31 Jul 2007 21:16:31 +0000 (UTC)
Message-ID: <864d0bcbe4b08c9a19ce9003a79@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: Replication stops
Newsgroups: Advantage.Replication
References: <46af00fd@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.185
X-Trace: 31 Jul 2007 15:11:35 -0700, 10.24.38.185
Lines: 16
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.185
Xref: solutions.advantagedatabase.com Advantage.Replication:227
Article PK: 1134082

Hello D.W.,
The ads_err.adt file at c:\ on the master server should contain errors logged
when the replication fails. Those errors should give you an idea why the
replication updates are failing. If you're not sure what the errors mean,
post the log entries (or the log itself) here and we can help.

It sounds like maybe you changed the table's structure while replication
entries were in the replication queue. If you need to change the structure
of a table that is replicated, first make sure no entries are in the replication
queue, then change the structure of the master's table and the target's table.

Regards,
Peter Funk
Advantage R&D


D.W. Huisman Posted on 2007-08-01 07:39:32.0Z
From: "D.W. Huisman" <dwhuisman@kliksafe.nl>
Newsgroups: Advantage.Replication
References: <46af00fd@solutions.advantagedatabase.com> <864d0bcbe4b08c9a19ce9003a79@devzone.advantagedatabase.com>
Subject: Re: Replication stops
Date: Wed, 1 Aug 2007 09:39:32 +0200
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: 80.127.200.202
Message-ID: <46b0378e@solutions.advantagedatabase.com>
X-Trace: 1 Aug 2007 01:34:38 -0700, 80.127.200.202
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!80.127.200.202
Xref: solutions.advantagedatabase.com Advantage.Replication:228
Article PK: 1134083

Hello Peter,

We made no changes to any of the table-structures.
By the way, we are using ADS 8.1.0.15 running on two Linux servers.

Dirk-Willem Huisman
DNA


"Peter Funk (ADS)" <pfunk@nospam.com> schreef in bericht
news:864d0bcbe4b08c9a19ce9003a79@devzone.advantagedatabase.com...

> Hello D.W.,
> The ads_err.adt file at c:\ on the master server should contain errors
> logged when the replication fails. Those errors should give you an idea
> why the replication updates are failing. If you're not sure what the
> errors mean, post the log entries (or the log itself) here and we can
> help.
>
> It sounds like maybe you changed the table's structure while replication
> entries were in the replication queue. If you need to change the
> structure of a table that is replicated, first make sure no entries are in
> the replication queue, then change the structure of the master's table and
> the target's table.
>
> Regards,
> Peter Funk
> Advantage R&D
>
>


Peter Funk (ADS) Posted on 2007-08-01 14:43:24.0Z
Date: Wed, 1 Aug 2007 14:43:24 +0000 (UTC)
Message-ID: <864d0bcbe4c38c9a22f2804e937@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: Replication stops
Newsgroups: Advantage.Replication
References: <46b0378e@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.185
X-Trace: 1 Aug 2007 08:38:28 -0700, 10.24.38.185
Lines: 12
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.185
Xref: solutions.advantagedatabase.com Advantage.Replication:230
Article PK: 1134086

You need to look in the Advantage error log on the master server to determine
why the replication updates are not being executed successfully. Look for
errors in the 7600 - 7699 range. This page in our help documentation might
help:

http://devzone.advantagedatabase.com/dz/webhelp/Advantage8.1/server1/advantage_error_log_and_replication.htm

Regards,
Peter Funk
Advantage R&D