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 error

3 posts in General Discussion Last posting was on 2012-08-01 07:16:54.0Z
M Kumar Posted on 2012-07-31 11:38:26.0Z
Sender: 8f8.5017c298.1804289383@sybase.com
From: M Kumar
Newsgroups: sybase.public.ase.general
Subject: Replication error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5017c3b2.913.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 31 Jul 2012 04:38:26 -0700
X-Trace: forums-1-dub 1343734706 172.20.134.41 (31 Jul 2012 04:38:26 -0700)
X-Original-Trace: 31 Jul 2012 04:38:26 -0700, 172.20.134.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31284
Article PK: 74174

We are getting below error.

Replication system has route enabled.

From primary,data is replicating to Two desination servers.

Issue:

Data is getting replicated to only one target server and for
the second we getting below error.

I. 2012/07/30 23:34:54. RSI: connection to "Secondary
replication server" is established and the route is active.
E. 2012/07/30 23:34:56. ERROR #4089 RSI(Secondary
replication server) - i/rsiint.c(2213)
RSI sender Secondary replication server: Could not
get a truncation point.
I. 2012/07/30 23:34:56. RSI for "Secondary replication
server": Continuing after an exception.


Please advise on the same.


Manish Negandhi [TeamSybase] Posted on 2012-07-31 14:44:16.0Z
From: "Manish Negandhi [TeamSybase]" <negandhi.manish_nosmap@gmail.com>
Newsgroups: sybase.public.ase.general
References: <5017c3b2.913.1681692777@sybase.com>
Subject: Re: Replication error
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <5017ef40@forums-1-dub>
Date: 31 Jul 2012 07:44:16 -0700
X-Trace: forums-1-dub 1343745856 172.20.134.152 (31 Jul 2012 07:44:16 -0700)
X-Original-Trace: 31 Jul 2012 07:44:16 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31287
Article PK: 74177


<M Kumar> wrote in message news:5017c3b2.913.1681692777@sybase.com...
> We are getting below error.
>
> Replication system has route enabled.
>
> From primary,data is replicating to Two desination servers.
>
> Issue:
>
> Data is getting replicated to only one target server and for
> the second we getting below error.
>
> I. 2012/07/30 23:34:54. RSI: connection to "Secondary
> replication server" is established and the route is active.
> E. 2012/07/30 23:34:56. ERROR #4089 RSI(Secondary
> replication server) - i/rsiint.c(2213)
> RSI sender Secondary replication server: Could not
> get a truncation point.
> I. 2012/07/30 23:34:56. RSI for "Secondary replication
> server": Continuing after an exception.
>
>
> Please advise on the same.

Correct forum for this question would be sybase.public.rep-server. Anyways
did you do any changes in replication system like upgrade/migration changing
secondary truncation point etc ?
What is the repserver version.

-HTH
Manish Negandhi
[TeamSybase]


M Kumar Posted on 2012-08-01 07:16:54.0Z
Sender: 2ee0.5018d6ec.1804289383@sybase.com
From: M Kumar
Newsgroups: sybase.public.ase.general
Subject: Re: Replication error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5018d7e6.2efe.1681692777@sybase.com>
References: <5017ef40@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 1 Aug 2012 00:16:54 -0700
X-Trace: forums-1-dub 1343805414 172.20.134.41 (1 Aug 2012 00:16:54 -0700)
X-Original-Trace: 1 Aug 2012 00:16:54 -0700, 172.20.134.41
Lines: 50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31300
Article PK: 74187


> <M Kumar> wrote in message
> > news:5017c3b2.913.1681692777@sybase.com... We are
> getting below error. >
> > Replication system has route enabled.
> >
> > From primary,data is replicating to Two desination
> servers. >
> > Issue:
> >
> > Data is getting replicated to only one target server and
> > for the second we getting below error.
> >
> > I. 2012/07/30 23:34:54. RSI: connection to "Secondary
> > replication server" is established and the route is
> > active. E. 2012/07/30 23:34:56. ERROR #4089
> > RSI(Secondary replication server) - i/rsiint.c(2213)
> > RSI sender Secondary replication server: Could
> > not get a truncation point.
> > I. 2012/07/30 23:34:56. RSI for "Secondary replication
> > server": Continuing after an exception.
> >
> >
> > Please advise on the same.
>
> Correct forum for this question would be
> sybase.public.rep-server. Anyways did you do any changes
> in replication system like upgrade/migration changing
> secondary truncation point etc ? What is the repserver
> version.
>
> -HTH
> Manish Negandhi
> [TeamSybase]
>
>
>
> HI Manish,

Thanks for the reply.

we got the issue resolved.

There was an orphan connection but the RSI queue had data
for that connection.
Data could not be sent to this connection, and since RSI
queue is single threaded (one route) prevented other data to
flow.

This was corrected by recreating the connection (dummy
connection).