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.

ASE Replicator problem

2 posts in replicator Last posting was on 2008-04-28 05:17:48.0Z
Jose D. Lima Posted on 2008-04-15 18:07:19.0Z
From: "Jose D. Lima" <jdlima7@gmail.com>
Newsgroups: sybase.public.ase.replicator
Subject: ASE Replicator problem
Lines: 110
Organization: Alcatel-Lucent
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4804eed7@forums-1-dub>
Date: 15 Apr 2008 11:07:19 -0700
X-Trace: forums-1-dub 1208282839 10.22.241.152 (15 Apr 2008 11:07:19 -0700)
X-Original-Trace: 15 Apr 2008 11:07:19 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:185
Article PK: 103385

Dear all,

I'm trying to setup a replication between two sybase in a Linux Box.

I'm following a procedure, accondirng to ASE Replicator manual, them, when
I'm using the aserep.sh script on the first time, I'm geting one error.

Follow the error.

I. 2008/04/11 13:52:22.110. com.sybase.replite.RepLite Starting execution
of ASE Replicator <RepSP>. Time: Fri Apr 11 13:52:22 BRT 2008
I. 2008/04/11 13:52:22.111. com.sybase.replite.RepLite ASE
Replicator/12.5.2//P/generic/JDK 1.3.1/main/301/VM: Sun Microsystems Inc.
1.3.1_10/OPT/Fri Mar 12 17:18:28 MST 2004
I. 2008/04/11 13:52:22.113. com.sybase.replite.RepLite
I. 2008/04/11 13:52:22.113. com.sybase.replite.RepLite Confidential
property of Sybase, Inc.
I. 2008/04/11 13:52:22.113. com.sybase.replite.RepLite (c) Copyright Sybase
Inc. 1998-2004
I. 2008/04/11 13:52:22.113. com.sybase.replite.RepLite All rights reserved.
I. 2008/04/11 13:52:22.113. com.sybase.replite.RepLite Use, duplication, or
disclosure by the United States Government
I. 2008/04/11 13:52:22.113. com.sybase.replite.RepLite is subject to
restrictions as set forth in FAR subparagraphs
I. 2008/04/11 13:52:22.113. com.sybase.replite.RepLite 52.227-19 (a)-(d)
for civilian agency contracts and DFARS 252.227-7013
I. 2008/04/11 13:52:22.113. com.sybase.replite.RepLite (c)(1)(ii) for
Department of Defense contracts. Sybase reserves all
I. 2008/04/11 13:52:22.113. com.sybase.replite.RepLite unpublished rights
under the copyright laws of the United States.
I. 2008/04/11 13:52:22.113. com.sybase.replite.RepLite Sybase, Inc., One
Sybase Drive, Dublin, CA 94568-7902
I. 2008/04/11 13:52:22.115. com.sybase.replite.RepLite ASE Replicator
instance name = RepSP
I. 2008/04/11 13:52:22.118. com.sybase.replite.RepLite ASE Replicator port
number = 7,000
I. 2008/04/11 13:52:22.121. com.sybase.replite.RepLite ASE host name =
vivo1
I. 2008/04/11 13:52:22.123. com.sybase.replite.RepLite ASE port number =
5,000
I. 2008/04/11 13:52:22.125. com.sybase.replite.RepLite ASE Replicator
Distribution Database name = db_replicator
I. 2008/04/11 13:52:22.127. com.sybase.replite.RepLite ASE Replicator user
name = replicator
I. 2008/04/11 13:52:22.128. com.sybase.replite.RepLite ASE Replicator
started with tracing enabled. Trace flags can be set with sp_tracerep.
I. 2008/04/11 13:52:22.129. com.sybase.replite.RepLite ASE Replicator
started in replicating mode.
I. 2008/04/11 13:52:22.133. com.sybase.replite.RepLite JRE vendor
= Sun Microsystems Inc.
I. 2008/04/11 13:52:22.134. com.sybase.replite.RepLite JRE version
= 1.3.1_10
I. 2008/04/11 13:52:22.135. com.sybase.replite.RepLite JRE endor URL
= http://java.sun.com/
I. 2008/04/11 13:52:22.136. com.sybase.replite.RepLite JRE install
directory = /opt/sybase/shared-1_0/JRE-1_3
I. 2008/04/11 13:52:22.138. com.sybase.replite.RepLite JRE classpath
=
/opt/sybase/RPL-12_5/classes/aserep.jar:/opt/sybase/jConnect-5_5/classes/jconn2.jar:/opt/sybase/jConnect-5_5/classes/jTDS2.jar:/opt/sybase/shared-1_0/JRE-1_3/lib/i18n.jar
I. 2008/04/11 13:52:22.139. com.sybase.replite.RepLite OS name
= Linux
I. 2008/04/11 13:52:22.141. com.sybase.replite.RepLite OS architecture
= i386
I. 2008/04/11 13:52:22.142. com.sybase.replite.RepLite OS version
= 2.6.9-42.0.0.0.1.ELsmp
I. 2008/04/11 13:52:22.143. com.sybase.replite.RepLite User account name
= sybase
I. 2008/04/11 13:52:22.145. com.sybase.replite.RepLite User working
directory = /opt/sybase/RPL-12_5/bin
I. 2008/04/11 13:52:22.147. com.sybase.replite.RepLite Re-directing
standard System output.
I. 2008/04/11 13:52:22.148. com.sybase.replite.RepLite Re-directing
standard System error.
I. 2008/04/11 13:52:22.152. com.sybase.replite.RepLite Initializing ASE
Replicator component: Repository
I. 2008/04/11 13:52:22.156. com.sybase.replite.RepLite Obtaining directory
information.
I. 2008/04/11 13:52:22.157. com.sybase.replite.RepLite Creating DDBAdmin
repository.
I. 2008/04/11 13:52:22.160. com.sybase.replite.RepLite Initializing
DDBAdmin.
I. 2008/04/11 13:52:22.199. com.sybase.ra.conn.RAConnectionMgr Attempting
connection to URL: jdbc:sybase:Tds:vivo1:5000/db_replicator:
I. 2008/04/11 13:52:23.69. com.sybase.ra.conn.RAConnectionMgr Successfully
connected to <jdbc:sybase:Tds:vivo1:5000/db_replicator>
I. 2008/04/11 13:52:23.71. com.sybase.ra.conn.RAConnectionMgr Successfully
connected to <JCONN(host:port/db): 'vivo1:5000/db_replicator'>
I. 2008/04/11 13:52:23.88. com.sybase.ra.conn.RAConnectionMgr Closed
connection to <jdbc:sybase:Tds:vivo1:5000/db_replicator>
I. 2008/04/11 13:52:23.91. com.sybase.ra.conn.RAConnectionMgr Attempting
connection to URL: jdbc:sybase:Tds:vivo1:5000/db_replicator:
I. 2008/04/11 13:52:23.119. com.sybase.ra.conn.RAConnectionMgr Successfully
connected to <jdbc:sybase:Tds:vivo1:5000/db_replicator>
F. 2008/04/11 13:52:24.541. com.sybase.replite.RepLite ASE Replicator
initialization error in component <DDBAdmin>. Component message: Error
encountered checking environement: S0022: Invalid column name
'network_name'.
I. 2008/04/11 13:52:24.551. com.sybase.ra.conn.RAConnectionMgr Closed
connection to <jdbc:sybase:Tds:vivo1:5000/db_replicator>
I. 2008/04/11 13:52:24.552. com.sybase.replite.RepLite ASE Replicator
requesting Java Virtual Machine exit with message: ASE Replicator
initialization error in component <DDBAdmin>. Component message: Error
encountered checking environement: S0022: Invalid column name
'network_name'.

Anybody could help me ?

Tks


Michael Peppler Posted on 2008-04-28 05:17:48.0Z
From: Michael Peppler <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: ASE Replicator problem
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2008.04.28.05.17.49.966870@peppler.org>
Newsgroups: sybase.public.ase.replicator
References: <4804eed7@forums-1-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 27 Apr 2008 22:17:48 -0700
X-Trace: forums-1-dub 1209359868 10.22.241.152 (27 Apr 2008 22:17:48 -0700)
X-Original-Trace: 27 Apr 2008 22:17:48 -0700, vip152.sybase.com
Lines: 40
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:186
Article PK: 103393


On Tue, 15 Apr 2008 12:07:19 -0700, Jose D. Lima wrote:

> Dear all,
>
> I'm trying to setup a replication between two sybase in a Linux Box.
>
> I'm following a procedure, accondirng to ASE Replicator manual, them, when
> I'm using the aserep.sh script on the first time, I'm geting one error.
>
> Follow the error.

> I. 2008/04/11 13:52:23.91. com.sybase.ra.conn.RAConnectionMgr Attempting
> connection to URL: jdbc:sybase:Tds:vivo1:5000/db_replicator:
> I. 2008/04/11 13:52:23.119. com.sybase.ra.conn.RAConnectionMgr Successfully
> connected to <jdbc:sybase:Tds:vivo1:5000/db_replicator>
> F. 2008/04/11 13:52:24.541. com.sybase.replite.RepLite ASE Replicator
> initialization error in component <DDBAdmin>. Component message: Error
> encountered checking environement: S0022: Invalid column name
> 'network_name'.

I have only used Replicator to test it, quite a long time ago now, so my
experience with it is limited.

However, from the error it seems you have a configuration or script syntax
problem.

Without further information it is hard to tell what the problem really
might be - do you have a column called network_name anywhere in your
tables/procs, and if so is it referenced in your replication code?

Also, did you install the replicator SQL code correctly?

Michael
--
Michael Peppler - Peppler Consulting SaRL
mpeppler@peppler.org - http://www.peppler.org
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html