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.

Removal of Replication Messages

2 posts in General Discussion Last posting was on 2008-12-22 15:12:03.0Z
mike.cutts Posted on 2007-05-15 10:35:49.0Z
From: mike.cutts@warwickicsystems.com
Newsgroups: ianywhere.public.general
Subject: Removal of Replication Messages
Date: 15 May 2007 03:35:49 -0700
Organization: http://groups.google.com
Lines: 21
Message-ID: <1179225349.695623.159690@n59g2000hsh.googlegroups.com>
NNTP-Posting-Host: 213.177.254.67
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1179225350 28926 127.0.0.1 (15 May 2007 10:35:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 15 May 2007 10:35:50 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 WICSSRV02
Complaints-To: groups-abuse@google.com
Injection-Info: n59g2000hsh.googlegroups.com; posting-host=213.177.254.67; posting-account=zWXwQgwAAACR6sf0UAGkOC6l4YbI4Dz5
Path: forums-1-dub!forums-master!newswest.sybase.com!newsfeed2.dallas1.level3.net!news.level3.com!postnews.google.com!n59g2000hsh.googlegroups.com!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7287
Article PK: 5504

Hi,

We are currently running Adaptive Server Anywhere v9, and have
experienced a problem whereby a child record has had information
entered against it on a replicated database after the parent record
had been deleted on the central copy, thereby resulting in a
constraint violation.

As a result of this violation, subsequent messages were not processed
correctly. We then found that by deleting the parent record on the
replicated database, removing the contents of the replication folders
and re-running the replication process (dbremote.exe), the problem was
resolved and future replication processes completed successfully.

All I really want to know is if deleting the contents of the
replication folders would cause any permanent problems with the
replication process, or whether it would auto-recover and continue to
work correctly.

Thanks.


"Nick Elson [Sybase iAnywhere]" < Posted on 2008-12-22 15:12:03.0Z
From: "Nick Elson [Sybase iAnywhere]" <@nick@.@elson@@sybase@.@com@>
Newsgroups: ianywhere.public.general
References: <1179225349.695623.159690@n59g2000hsh.googlegroups.com>
Subject: Re: Removal of Replication Messages
Lines: 48
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <494fae43$1@forums-1-dub>
Date: 22 Dec 2008 07:12:03 -0800
X-Trace: forums-1-dub 1229958723 10.22.241.152 (22 Dec 2008 07:12:03 -0800)
X-Original-Trace: 22 Dec 2008 07:12:03 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7292
Article PK: 5503


> All I really want to know is if deleting the contents of the
> replication folders would cause any permanent problems with the
> replication process, or whether it would auto-recover and continue to
> work correctly.

No problems at all, since those very same messages should have
been resent anyway. The concern is why you think this resolved
the issue, since ***it should not have done so***!?

In fact, just deleting messages should have had no overall impact.
The messages should be recreated and returned you right back
to the same problem again.

Are you sure you did not issue some sort of reset as well?
If something else (like that) was done then you could be missing
transactions that only occurred at the remote and the effects
of those changes could be permanently lost to the consolidate
site (and thus all others that should also have received those).

For future reference the quick fix for his specific problem is to
(temporarily) reinsert the missing parent row, letting the messages
apply and then delete it again; no deleting of messages required.

<mike.cutts@warwickicsystems.com> wrote in message
news:1179225349.695623.159690@n59g2000hsh.googlegroups.com...
> Hi,
>
> We are currently running Adaptive Server Anywhere v9, and have
> experienced a problem whereby a child record has had information
> entered against it on a replicated database after the parent record
> had been deleted on the central copy, thereby resulting in a
> constraint violation.
>
> As a result of this violation, subsequent messages were not processed
> correctly. We then found that by deleting the parent record on the
> replicated database, removing the contents of the replication folders
> and re-running the replication process (dbremote.exe), the problem was
> resolved and future replication processes completed successfully.
>
> All I really want to know is if deleting the contents of the
> replication folders would cause any permanent problems with the
> replication process, or whether it would auto-recover and continue to
> work correctly.
>
> Thanks.
>