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.

All is correct but not replicate

4 posts in Replication Agent Last posting was on 2004-11-08 16:35:13.0Z
Javier Jirón Posted on 2004-10-21 17:08:15.0Z
From: =?ISO-8859-1?Q?Javier_Jir=F3n?= <javierjiron@uniandesonline.edu.ec>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.rep-agent
Subject: All is correct but not replicate
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 200.93.227.69
X-Original-NNTP-Posting-Host: 200.93.227.69
Message-ID: <4177ecff@forums-1-dub>
Date: 21 Oct 2004 10:08:15 -0700
X-Trace: forums-1-dub 1098378495 200.93.227.69 (21 Oct 2004 10:08:15 -0700)
X-Original-Trace: 21 Oct 2004 10:08:15 -0700, 200.93.227.69
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:727
Article PK: 862365

Hi, all configuration is correct for ra for ms sql server, but not
replicate, in first instance the data is correct in the secondary
database, in a moment the DSI is down in primary database, but the
connection is resume, in this moment stop the replication.

The ra_statistics command show the replicated operations, but the data
is not arrived in the secondary database, the subscription in
replication server is active, what is the possible problem?


Wanda Beck Posted on 2004-10-21 17:22:53.0Z
From: "Wanda Beck" <wbeck@sybase.com>
Newsgroups: sybase.public.rep-agent
References: <4177ecff@forums-1-dub>
Subject: Re: All is correct but not replicate
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: wbeckw2k.sybase.com
X-Original-NNTP-Posting-Host: wbeckw2k.sybase.com
Message-ID: <4177f06d$1@forums-1-dub>
Date: 21 Oct 2004 10:22:53 -0700
X-Trace: forums-1-dub 1098379373 10.21.35.134 (21 Oct 2004 10:22:53 -0700)
X-Original-Trace: 21 Oct 2004 10:22:53 -0700, wbeckw2k.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:728
Article PK: 862366

Hello, Javier,

In the RepAgent Admin Guide, Chapter 6 is about Troubleshooting. The last
section entitled "Replication failure troubleshooting tips" has some good
information.
http://sybooks.sybase.com/onlinebooks/group-ra/rag1250e/ra125ag/@Generic__BookView

The DSI down at the primary is okay.

Do the ra_statistics show any skipped operations/transactions?

Thanks,
Wanda

"Javier Jirón" <javierjiron@uniandesonline.edu.ec> wrote in message
news:4177ecff@forums-1-dub...
> Hi, all configuration is correct for ra for ms sql server, but not
> replicate, in first instance the data is correct in the secondary
> database, in a moment the DSI is down in primary database, but the
> connection is resume, in this moment stop the replication.
>
> The ra_statistics command show the replicated operations, but the data
> is not arrived in the secondary database, the subscription in
> replication server is active, what is the possible problem?
>


Javier Jirón Posted on 2004-11-05 20:33:54.0Z
From: =?ISO-8859-1?Q?Javier_Jir=F3n?= <javierjiron@uniandesonline.edu.ec>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.rep-agent
Subject: Re: All is correct but not replicate
References: <4177ecff@forums-1-dub>
In-Reply-To: <4177ecff@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Original-NNTP-Posting-Host: 200.93.227.69
Message-ID: <418be3ae@forums-2-dub>
X-Original-Trace: 5 Nov 2004 12:33:50 -0800, 200.93.227.69
Lines: 15
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Nov 2004 12:33:51 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Nov 2004 12:33:54 -0800
X-Trace: forums-1-dub 1099686834 10.22.108.75 (5 Nov 2004 12:33:54 -0800)
X-Original-Trace: 5 Nov 2004 12:33:54 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:733
Article PK: 862373

I create other instance of ra, with the same configuration and run
correct, replicate is ok, what is the possible problem?

Javier Jirón wrote:

> Hi, all configuration is correct for ra for ms sql server, but not
> replicate, in first instance the data is correct in the secondary
> database, in a moment the DSI is down in primary database, but the
> connection is resume, in this moment stop the replication.
>
> The ra_statistics command show the replicated operations, but the data
> is not arrived in the secondary database, the subscription in
> replication server is active, what is the possible problem?
>


Wanda Beck Posted on 2004-11-08 16:35:13.0Z
From: "Wanda Beck" <wbeck@sybase.com>
Newsgroups: sybase.public.rep-agent
References: <4177ecff@forums-1-dub> <418be3ae@forums-2-dub>
Subject: Re: All is correct but not replicate
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: wbeckw2k.sybase.com
Message-ID: <418fa03d$1@forums-2-dub>
X-Original-Trace: 8 Nov 2004 08:35:09 -0800, wbeckw2k.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 8 Nov 2004 08:35:10 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 8 Nov 2004 08:35:13 -0800
X-Trace: forums-1-dub 1099931713 10.22.108.75 (8 Nov 2004 08:35:13 -0800)
X-Original-Trace: 8 Nov 2004 08:35:13 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:734
Article PK: 862371

Hi, Javier,

I'd like to help but there's no easy answer to your question. You still
have to do troubleshooting -- which means you have to examine all the
areas/components along the replication path.

If your RepAgent instance has replicated all the data and stays in
REPLICATING mode, then you'll need to troubleshoot the RepServer and the
replicate.

Part 3, Chapter 9 of The Heterogeneous Replication Guide
http://sybooks.sybase.com/onlinebooks/group-rs/rsg1260e/rshetrep/@Generic__BookView
has much good information on how to troubleshoot replication problems,
including how to troubleshoot when the replicate does not get updated.

Thanks,
Wanda

"Javier Jirón" <javierjiron@uniandesonline.edu.ec> wrote in message
news:418be3ae@forums-2-dub...
> I create other instance of ra, with the same configuration and run
> correct, replicate is ok, what is the possible problem?
>
> Javier Jirón wrote:
>
> > Hi, all configuration is correct for ra for ms sql server, but not
> > replicate, in first instance the data is correct in the secondary
> > database, in a moment the DSI is down in primary database, but the
> > connection is resume, in this moment stop the replication.
> >
> > The ra_statistics command show the replicated operations, but the data
> > is not arrived in the secondary database, the subscription in
> > replication server is active, what is the possible problem?
> >
>