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.

dbrepdef/repdef/duplicates

3 posts in General Discussion Last posting was on 2011-07-25 08:25:21.0Z
vtpcnk Posted on 2011-07-22 06:06:26.0Z
Sender: 7283.4e2911db.1804289383@sybase.com
From: vtpcnk
Newsgroups: sybase.public.rep-server
Subject: dbrepdef/repdef/duplicates
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e291362.72aa.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 21 Jul 2011 23:06:26 -0700
X-Trace: forums-1-dub 1311314786 10.22.241.41 (21 Jul 2011 23:06:26 -0700)
X-Original-Trace: 21 Jul 2011 23:06:26 -0700, 10.22.241.41
Lines: 37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9006
Article PK: 870172

added ds1.db1 and ds2.db2 to rep server - both with rep
agents.

setup db level rep defs and subscriptions from both sides.

created table with two columns on both sides - i int, vc
varchar(20).

created unique clustered index on column i on the table on
both sides.

created table level rep def on ds1.db1 and subscrited to it
from ds2.db2

inserted values 1,'one'
2, 'two'

etc

replication works fine and data is found in ds2.db2.

then i logged in as maint user on ds1.db1 and deleted row :
2,'two'.

then inserted again as 2,'Two'.

hoping to find duplicate error on ds2.db2.

but original row still present in target.

what's happening?

my actual aim is to test auto correction in a db rep def
environment. with or without a table level rep def/sub
within the db level rep.

appreciate any insights.


Luc Van der Veurst Posted on 2011-07-22 08:06:17.0Z
From: "Luc Van der Veurst" <dba_azvub@hotmail.com>
Newsgroups: sybase.public.rep-server
References: <4e291362.72aa.1681692777@sybase.com>
Subject: Re: dbrepdef/repdef/duplicates
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-Forwarded: by - (DeleGate/5.8.7)
X-Forwarded: by - (DeleGate/5.8.7)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e292f79$1@forums-1-dub>
Date: 22 Jul 2011 01:06:17 -0700
X-Trace: forums-1-dub 1311321977 10.22.241.152 (22 Jul 2011 01:06:17 -0700)
X-Original-Trace: 22 Jul 2011 01:06:17 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9007
Article PK: 870170

Did you insert row (2, 'Two') with a regular user or as the
maintenance user ? Since you logged in with the maintenance
user to delete the row in ds1 but not in ds2 (because transactions
executed by the maintenance user are not replicated), it sounds
normal that the row still exists in ds2.
If you insert a row as maintenance user, it's also normal that
it doesn't appear in ds2, so you don't get an error.

Luc.

<vtpcnk> wrote in message news:4e291362.72aa.1681692777@sybase.com...
> added ds1.db1 and ds2.db2 to rep server - both with rep
> agents.
>
> setup db level rep defs and subscriptions from both sides.
>
> created table with two columns on both sides - i int, vc
> varchar(20).
>
> created unique clustered index on column i on the table on
> both sides.
>
> created table level rep def on ds1.db1 and subscrited to it
> from ds2.db2
>
> inserted values 1,'one'
> 2, 'two'
>
> etc
>
> replication works fine and data is found in ds2.db2.
>
> then i logged in as maint user on ds1.db1 and deleted row :
> 2,'two'.
>
> then inserted again as 2,'Two'.
>
> hoping to find duplicate error on ds2.db2.
>
> but original row still present in target.
>
> what's happening?
>
> my actual aim is to test auto correction in a db rep def
> environment. with or without a table level rep def/sub
> within the db level rep.
>
> appreciate any insights.


vtpcnk Posted on 2011-07-25 08:25:21.0Z
Sender: 41ba.4e2d27bc.1804289383@sybase.com
From: vtpcnk
Newsgroups: sybase.public.rep-server
Subject: Re: dbrepdef/repdef/duplicates
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e2d2871.41eb.1681692777@sybase.com>
References: <4e292f79$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Jul 2011 01:25:21 -0700
X-Trace: forums-1-dub 1311582321 10.22.241.41 (25 Jul 2011 01:25:21 -0700)
X-Original-Trace: 25 Jul 2011 01:25:21 -0700, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9009
Article PK: 870173


> Did you insert row (2, 'Two') with a regular user or as
> the maintenance user ? Since you logged in with the
> maintenance user to delete the row in ds1 but not in ds2
> (because transactions executed by the maintenance user are
> not replicated), it sounds normal that the row still
> exists in ds2. If you insert a row as maintenance user,
> it's also normal that it doesn't appear in ds2, so you
> don't get an error.
>
> Luc.

sorry - didn't mention that the second duplicate row insert
was as regular user - NOT as maintenance user. so it was
supposed to be replicated.

on further research found that somebody had set up global
error clause to ignore duplicate errors.