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 stops with "Execution Completed" Options

3 posts in General Discussion Last posting was on 2010-06-09 15:57:44.0Z
Bm Posted on 2010-06-08 04:03:11.0Z
Sender: 6889.4c0dc052.1804289383@sybase.com
From: Bm
Newsgroups: ianywhere.public.general
Subject: Replication stops with "Execution Completed" Options
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c0dc0ff.689b.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jun 2010 21:03:11 -0700
X-Trace: forums-1-dub 1275969791 10.22.241.41 (7 Jun 2010 21:03:11 -0700)
X-Original-Trace: 7 Jun 2010 21:03:11 -0700, 10.22.241.41
Lines: 50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8052
Article PK: 7076

Hi,

In one of our remote servers, all of a sudden replication
stopped working. When we start replication, it stops with
"Execution completed" message. I have pasted the log file
for reference. Any help to resolve this issue is highly
appreciated.


I. 06/08 00:56:32. 1: -c
I. 06/08 00:56:32. 2:
**********************************************************
I. 06/08 00:56:32. 3: -rd
I. 06/08 00:56:32. 4: 10
I. 06/08 00:56:32. 5: -rp
I. 06/08 00:56:32. 6: 3
I. 06/08 00:56:32. 7: -v
I. 06/08 00:56:32. SQL Remote Message Agent Version
9.0.2.2451
I. 06/08 00:56:32.
I. 06/08 00:56:32. Copyright © 1989-2004 Sybase, Inc.
Portions Copyright © 2002-2004,
iAnywhere Solutions, Inc.
I. 06/08 00:56:32. All rights reserved. All unpublished
rights
reserved.
I. 06/08 00:56:32.
I. 06/08 00:56:32. This software contains confidential and
trade
secret information of
I. 06/08 00:56:32. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 06/08 00:56:32. by the U.S. Government is subject to
restrictions set forth in a license
I. 06/08 00:56:32. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 06/08 00:56:32. other written agreement specifying the
Government's rights to use the
I. 06/08 00:56:32. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 06/08 00:56:32.
I. 06/08 00:56:32. iAnywhere Solutions, Inc., One Sybase
Drive,
Dublin, CA 94568, USA
I. 06/08 00:56:32.
I. 06/08 00:56:33. Execution completed


Thanks, BM.


Volker Barth <No_VBarth Posted on 2010-06-08 11:56:55.0Z
From: Volker Barth <No_VBarth@Spam_GLOBAL-FINANZ.de>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Replication stops with "Execution Completed" Options
References: <4c0dc0ff.689b.1681692777@sybase.com>
In-Reply-To: <4c0dc0ff.689b.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c0e3007@forums-1-dub>
Date: 8 Jun 2010 04:56:55 -0700
X-Trace: forums-1-dub 1275998215 10.22.241.152 (8 Jun 2010 04:56:55 -0700)
X-Original-Trace: 8 Jun 2010 04:56:55 -0700, vip152.sybase.com
Lines: 69
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8053
Article PK: 7074

Just a wild guess:

There was a thread on the replication NG some months before dealing with
a similar problem. In the end, the database missed a publisher (i.e. the
publisher - as user or as a priviledge - had been deleted beforehand).
That leads to the SQL Remote process closing "successfully" without any
further work.

See the thread "dbremote execution completed" from 2009-01-27,
news://forums.sybase.com:119/4b6028bc.61d7.1681692777@sybase.com

As stated there, for 9.0.2. EBF 3950 should fix this issue.

HTH
Volker

Bm wrote:
> Hi,
>
> In one of our remote servers, all of a sudden replication
> stopped working. When we start replication, it stops with
> "Execution completed" message. I have pasted the log file
> for reference. Any help to resolve this issue is highly
> appreciated.
>
>
> I. 06/08 00:56:32. 1: -c
> I. 06/08 00:56:32. 2:
> **********************************************************
> I. 06/08 00:56:32. 3: -rd
> I. 06/08 00:56:32. 4: 10
> I. 06/08 00:56:32. 5: -rp
> I. 06/08 00:56:32. 6: 3
> I. 06/08 00:56:32. 7: -v
> I. 06/08 00:56:32. SQL Remote Message Agent Version
> 9.0.2.2451
> I. 06/08 00:56:32.
> I. 06/08 00:56:32. Copyright © 1989-2004 Sybase, Inc.
> Portions Copyright © 2002-2004,
> iAnywhere Solutions, Inc.
> I. 06/08 00:56:32. All rights reserved. All unpublished
> rights
> reserved.
> I. 06/08 00:56:32.
> I. 06/08 00:56:32. This software contains confidential and
> trade
> secret information of
> I. 06/08 00:56:32. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the
> software and documentation
> I. 06/08 00:56:32. by the U.S. Government is subject to
> restrictions set forth in a license
> I. 06/08 00:56:32. agreement between the Government and
> iAnywhere Solutions, Inc. or
> I. 06/08 00:56:32. other written agreement specifying the
> Government's rights to use the
> I. 06/08 00:56:32. software and any applicable FAR
> provisions, for example, FAR 52.227-19.
> I. 06/08 00:56:32.
> I. 06/08 00:56:32. iAnywhere Solutions, Inc., One Sybase
> Drive,
> Dublin, CA 94568, USA
> I. 06/08 00:56:32.
> I. 06/08 00:56:33. Execution completed
>
>
> Thanks, BM.


Bm Posted on 2010-06-09 15:57:44.0Z
Sender: 25e5.4c0fb8bd.1804289383@sybase.com
From: BM
Newsgroups: ianywhere.public.general
Subject: Re: Replication stops with "Execution Completed" Options
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c0fb9f8.2657.1681692777@sybase.com>
References: <4c0e3007@forums-1-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Jun 2010 08:57:44 -0700
X-Trace: forums-1-dub 1276099064 10.22.241.41 (9 Jun 2010 08:57:44 -0700)
X-Original-Trace: 9 Jun 2010 08:57:44 -0700, 10.22.241.41
Lines: 85
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8054
Article PK: 7078

Hi Volker,

Thanks a lot for your response. I did get a chance to look
at the thread. The publisher is not deleted and has the
required priviledge. The remote database is Kazhakistan.
The problem started after they had interupption in internet
connectivity. Now, the internet connectivity is restored but
the replication is not working.

Thanks, BM

> Just a wild guess:
>
> There was a thread on the replication NG some months
> before dealing with a similar problem. In the end, the
> database missed a publisher (i.e. the publisher - as user
> or as a priviledge - had been deleted beforehand). That
> leads to the SQL Remote process closing "successfully"
> without any further work.
>
> See the thread "dbremote execution completed" from
> 2009-01-27,
> news://forums.sybase.com:119/4b6028bc.61d7.1681692777@syba
> se.com
>
> As stated there, for 9.0.2. EBF 3950 should fix this
> issue.
>
> HTH
> Volker
>
>
>
> Bm wrote:
> > Hi,
> >
> > In one of our remote servers, all of a sudden
> > replication stopped working. When we start replication,
> > it stops with "Execution completed" message. I have
> > pasted the log file for reference. Any help to resolve
> > this issue is highly appreciated.
> >
> >
> > I. 06/08 00:56:32. 1: -c
> > I. 06/08 00:56:32. 2:
> >
> >
> **********************************************************
> > I. 06/08 00:56:32. 3: -rd I. 06/08 00:56:32. 4: 10
> > I. 06/08 00:56:32. 5: -rp
> > I. 06/08 00:56:32. 6: 3
> > I. 06/08 00:56:32. 7: -v
> > I. 06/08 00:56:32. SQL Remote Message Agent Version
> > 9.0.2.2451
> > I. 06/08 00:56:32.
> > I. 06/08 00:56:32. Copyright © 1989-2004 Sybase, Inc.
> > Portions Copyright © 2002-2004,
> > iAnywhere Solutions, Inc.
> > I. 06/08 00:56:32. All rights reserved. All unpublished
> > rights
> > reserved.
> > I. 06/08 00:56:32.
> > I. 06/08 00:56:32. This software contains confidential
> > and trade
> > secret information of
> > I. 06/08 00:56:32. iAnywhere Solutions, Inc.
> > Use, duplication or disclosure of
> > the software and documentation
> > I. 06/08 00:56:32. by the U.S. Government is subject to
> > restrictions set forth in a license
> > I. 06/08 00:56:32. agreement between the Government and
> > iAnywhere Solutions, Inc. or
> > I. 06/08 00:56:32. other written agreement specifying
> > the Government's rights to use the
> > I. 06/08 00:56:32. software and any applicable FAR
> > provisions, for example, FAR 52.227-19.
> > I. 06/08 00:56:32.
> > I. 06/08 00:56:32. iAnywhere Solutions, Inc., One Sybase
> > Drive,
> > Dublin, CA 94568, USA
> > I. 06/08 00:56:32.
> > I. 06/08 00:56:33. Execution completed
> >
> >
> > Thanks, BM.