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.

Eisen

2 posts in General Discussion Last posting was on 2011-09-19 08:37:06.0Z
can Replication Server send "set rowcount" to replicate site? Posted on 2011-09-19 08:06:21.0Z
Sender: 3ae4.4e715b1d.1804289383@sybase.com
From: can Replication Server send "set rowcount" to replicate site?
Newsgroups: sybase.public.rep-server
Subject: Eisen
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e76f7fd.3861.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Sep 2011 01:06:21 -0700
X-Trace: forums-1-dub 1316419581 10.22.241.41 (19 Sep 2011 01:06:21 -0700)
X-Original-Trace: 19 Sep 2011 01:06:21 -0700, 10.22.241.41
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9055
Article PK: 870218

Dear all
As we know, usually in table replication, we can specify
the affected rowcount by primary key in transaction. But in
the MSA or Warm-Standby situation, I found something maybe
cause problem.-- eg.
I build up a RS service with MSA to replicate entire
database from A.a to B.a
now on A.a we can
1. create table testtb (id int,b varchar(20))
2. insert testtb values(1,'haha')
insert testtb values(1,'haha')
insert testtb values(2,'hoho')
3. set rowcount 1
delete testtb where id=1
When we doing this, the RS shutdown immediately, and the
error log shows when RS transfer the DML from A.a to B.b --
in queue's transaction, we can see the rowcount should be 1,
but on the replicate the transaction would produce rowcount
to be 2. This issue caused the RS DSI fail. Would be there
any configuration to let RS also send the rowcount limit to
the replicate? Thanks in advance to any help.

Best Regards
Eisen


Eisen Posted on 2011-09-19 08:37:06.0Z
Sender: 3a41.4e76fe12.1804289383@sybase.com
From: Eisen
Newsgroups: sybase.public.rep-server
Subject: Re: can Replication Server send "set rowcount" to replicate site?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e76ff32.3a9f.1681692777@sybase.com>
References: <4e76f7fd.3861.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Sep 2011 01:37:06 -0700
X-Trace: forums-1-dub 1316421426 10.22.241.41 (19 Sep 2011 01:37:06 -0700)
X-Original-Trace: 19 Sep 2011 01:37:06 -0700, 10.22.241.41
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9056
Article PK: 870216

Sorry to misplace the topic and composer. If administrator
don't mind, please delete it. I'll repost it. Thanks

Best Regards
Eisen

> Dear all
> As we know, usually in table replication, we can
> specify the affected rowcount by primary key in
> transaction. But in the MSA or Warm-Standby situation, I
> found something maybe cause problem.-- eg.
> I build up a RS service with MSA to replicate entire
> database from A.a to B.a
> now on A.a we can
> 1. create table testtb (id int,b varchar(20))
> 2. insert testtb values(1,'haha')
> insert testtb values(1,'haha')
> insert testtb values(2,'hoho')
> 3. set rowcount 1
> delete testtb where id=1
> When we doing this, the RS shutdown immediately, and
> the error log shows when RS transfer the DML from A.a to
> B.b -- in queue's transaction, we can see the rowcount
> should be 1, but on the replicate the transaction would
> produce rowcount to be 2. This issue caused the RS DSI
> fail. Would be there any configuration to let RS also send
> the rowcount limit to the replicate? Thanks in advance to
> any help.
>
> Best Regards
> Eisen