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.

Unable to configure replication agent

2 posts in Replication Agent Last posting was on 2005-01-07 23:11:33.0Z
Jayadev Posted on 2005-01-07 16:26:34.0Z
Sender: 2c03.41deb736.1804289383@sybase.com
From: Jayadev
Newsgroups: sybase.public.rep-agent
Subject: Unable to configure replication agent
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41deb83a.2c11.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jan 2005 08:26:34 -0800
X-Trace: forums-1-dub 1105115194 10.22.241.41 (7 Jan 2005 08:26:34 -0800)
X-Original-Trace: 7 Jan 2005 08:26:34 -0800, 10.22.241.41
Lines: 124
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:744
Article PK: 862384

Hi All,

I'm doing heterogeneous replication from MSSQL to Oracle.
This is uni-directional.

MSSQL--->RA12.5--->RS12.5--->ASE12.5.1--->DC12.5--->Oracle
9i

I'm not able to configure Replciation agent from MSSQL and
Replciation server

I'm using follwoing software on the HP-UX server

MSSQL server 2000
RA 12.5
Jconnect 5.5
RS 12.5
ASE 12.5.1


RA, RS, ASE, Jconnect has been installed on one server with
different logins

I've configured all the parameters,
For the primary database connection
For Replication Server
For RSSD database
for primary data server

after entrying all the values I checked with test_connection

It is showing both the PDS and RS as failed.


E. 2005/01/07 21:26:55.44.
com.sybase.ra.conn.query.QueryExceptionRemo
te Code: 0
E. 2005/01/07 21:26:55.44.
com.sybase.ra.conn.RAConnectionMgr Could not connect to
<MSMERJDBC(server:port): 'infofeed:1433'>: Attempt to unlock
branded JDBC driver FAILED for connection
<MSMERJDBC(server:port): 'infofeed:1433'> :
E. 2005/01/07 21:26:55.44.
com.sybase.ra.conn.RAConnectionMgr SQL ERROR --
E. 2005/01/07 21:26:55.44.
com.sybase.ra.conn.RAConnectionMgrMessage:
[SYBASE][SQLServer JDBC Driver]Error establishing socket.
E. 2005/01/07 21:26:55.44.
com.sybase.ra.conn.RAConnectionMgrSQLState: 08001
E. 2005/01/07 21:26:55.44.
com.sybase.ra.conn.RAConnectionMgrRemote Code: 0
E. 2005/01/07 21:26:55.44.
com.sybase.ra.conn.RAConnectionMgr SQL ERROR --
E. 2005/01/07 21:26:55.44.
com.sybase.ra.conn.RAConnectionMgrMessage:
[SYBASE][SQLServer JDBC Driver]infofeed
E. 2005/01/07 21:26:55.44.
com.sybase.ra.conn.RAConnectionMgrSQLState: HY000
E. 2005/01/07 21:26:55.44.
com.sybase.ra.conn.RAConnectionMgrRemote Code: 0
I. 2005/01/07 21:26:55.45.
com.sybase.ra.conn.RAConnectionMgr Attempting conne
ction to URL: jdbc:sybase:Tds:OLDBeta3:6666:
E. 2005/01/07 21:26:55.45.
com.sybase.ra.conn.query.QueryException All connection
attempts have failed, retries = 0
E. 2005/01/07 21:26:55.45.
com.sybase.ra.conn.query.QueryException name:
JCONN(host:port): 'OLDBeta3:6666'
E. 2005/01/07 21:26:55.45.
com.sybase.ra.conn.query.QueryException URL:
jdbc:sybase:Tds:OLDBeta3:6666

E. 2005/01/07 21:26:55.45.
com.sybase.ra.conn.query.QueryException props:
E. 2005/01/07 21:26:55.45.
com.sybase.ra.conn.query.QueryException password =
'*****' (suppressed)
E. 2005/01/07 21:26:55.45.
com.sybase.ra.conn.query.QueryException PACKETSIZE=
'2048'
E. 2005/01/07 21:26:55.45.
com.sybase.ra.conn.query.QueryException user=
'rauser'
E. 2005/01/07 21:26:55.45.
com.sybase.ra.conn.query.QueryException
JCONNECT_VERSION = '6'
E. 2005/01/07 21:26:55.45.
com.sybase.ra.conn.query.QueryException
CHARSET_CONVERTER_CLASS =
'com.sybase.jdbc2.utils.PureConverter'
E. 2005/01/07 21:26:55.46.
com.sybase.ra.conn.query.QueryException


This is the output of pdb_xlog

1> pdb_xlog
2>
Msg 32000, Level 20, State 0:
Server 'ramssqlora', Procedure 'pdb_xlog', Line 1:
Command <pdb_xlog> failed - SQL connection or execution
failed:
SQL ERROR --

Message: [SYBASE][SQLServer JDBC Driver]Error
establishing socket.

SQLState: 08001
Remote Code: 0
SQL ERROR --
Message:
[SYBASE][SQLServer JDBC Driver]infofeed
SQLState: HY000
Remote Code:


1. Is this because of firewall issues
2. The DC is required between MSSQL and Replciation
server(I'm doing uni-directional MSSQL--> Oracle9i)
3. Or, any other JDBC drivers are required for this.

thanks in advance
Jayadev


Wanda Beck Posted on 2005-01-07 23:11:33.0Z
From: "Wanda Beck" <wbeck@sybase.com>
Newsgroups: sybase.public.rep-agent
References: <41deb83a.2c11.1681692777@sybase.com>
Subject: Re: Unable to configure replication agent
Lines: 143
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: <41df1722@forums-2-dub>
X-Original-Trace: 7 Jan 2005 15:11:30 -0800, wbeckw2k.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 7 Jan 2005 15:11:30 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 7 Jan 2005 15:11:33 -0800
X-Trace: forums-1-dub 1105139493 10.22.108.75 (7 Jan 2005 15:11:33 -0800)
X-Original-Trace: 7 Jan 2005 15:11:33 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:745
Article PK: 862385

Hi, Jayadev,

If your RA is outside the firewall attempting access to MSSQL inside the
firewall, then I think that this is the problem. I found this thread in the
DataDirect forum for Connect JDBC:
http://forums.datadirect.com/ddforums/thread.jspa?forumID=4&threadID=367&messageID=1770#1770
that suggests that the "Error establishing socket" is because the host name
or port is specified incorrectly. But if you, in fact, have specified them
correctly, then the firewall is getting in the way.

I suggest installing RepAgent inside the firewall so that it can easily
access MSSQL.

Thanks,
Wanda

<Jayadev> wrote in message news:41deb83a.2c11.1681692777@sybase.com...
> Hi All,
>
> I'm doing heterogeneous replication from MSSQL to Oracle.
> This is uni-directional.
>
> MSSQL--->RA12.5--->RS12.5--->ASE12.5.1--->DC12.5--->Oracle
> 9i
>
> I'm not able to configure Replciation agent from MSSQL and
> Replciation server
>
> I'm using follwoing software on the HP-UX server
>
> MSSQL server 2000
> RA 12.5
> Jconnect 5.5
> RS 12.5
> ASE 12.5.1
>
>
> RA, RS, ASE, Jconnect has been installed on one server with
> different logins
>
> I've configured all the parameters,
> For the primary database connection
> For Replication Server
> For RSSD database
> for primary data server
>
> after entrying all the values I checked with test_connection
>
> It is showing both the PDS and RS as failed.
>
>
> E. 2005/01/07 21:26:55.44.
> com.sybase.ra.conn.query.QueryExceptionRemo
> te Code: 0
> E. 2005/01/07 21:26:55.44.
> com.sybase.ra.conn.RAConnectionMgr Could not connect to
> <MSMERJDBC(server:port): 'infofeed:1433'>: Attempt to unlock
> branded JDBC driver FAILED for connection
> <MSMERJDBC(server:port): 'infofeed:1433'> :
> E. 2005/01/07 21:26:55.44.
> com.sybase.ra.conn.RAConnectionMgr SQL ERROR --
> E. 2005/01/07 21:26:55.44.
> com.sybase.ra.conn.RAConnectionMgrMessage:
> [SYBASE][SQLServer JDBC Driver]Error establishing socket.
> E. 2005/01/07 21:26:55.44.
> com.sybase.ra.conn.RAConnectionMgrSQLState: 08001
> E. 2005/01/07 21:26:55.44.
> com.sybase.ra.conn.RAConnectionMgrRemote Code: 0
> E. 2005/01/07 21:26:55.44.
> com.sybase.ra.conn.RAConnectionMgr SQL ERROR --
> E. 2005/01/07 21:26:55.44.
> com.sybase.ra.conn.RAConnectionMgrMessage:
> [SYBASE][SQLServer JDBC Driver]infofeed
> E. 2005/01/07 21:26:55.44.
> com.sybase.ra.conn.RAConnectionMgrSQLState: HY000
> E. 2005/01/07 21:26:55.44.
> com.sybase.ra.conn.RAConnectionMgrRemote Code: 0
> I. 2005/01/07 21:26:55.45.
> com.sybase.ra.conn.RAConnectionMgr Attempting conne
> ction to URL: jdbc:sybase:Tds:OLDBeta3:6666:
> E. 2005/01/07 21:26:55.45.
> com.sybase.ra.conn.query.QueryException All connection
> attempts have failed, retries = 0
> E. 2005/01/07 21:26:55.45.
> com.sybase.ra.conn.query.QueryException name:
> JCONN(host:port): 'OLDBeta3:6666'
> E. 2005/01/07 21:26:55.45.
> com.sybase.ra.conn.query.QueryException URL:
> jdbc:sybase:Tds:OLDBeta3:6666
>
> E. 2005/01/07 21:26:55.45.
> com.sybase.ra.conn.query.QueryException props:
> E. 2005/01/07 21:26:55.45.
> com.sybase.ra.conn.query.QueryException password =
> '*****' (suppressed)
> E. 2005/01/07 21:26:55.45.
> com.sybase.ra.conn.query.QueryException PACKETSIZE=
> '2048'
> E. 2005/01/07 21:26:55.45.
> com.sybase.ra.conn.query.QueryException user=
> 'rauser'
> E. 2005/01/07 21:26:55.45.
> com.sybase.ra.conn.query.QueryException
> JCONNECT_VERSION = '6'
> E. 2005/01/07 21:26:55.45.
> com.sybase.ra.conn.query.QueryException
> CHARSET_CONVERTER_CLASS =
> 'com.sybase.jdbc2.utils.PureConverter'
> E. 2005/01/07 21:26:55.46.
> com.sybase.ra.conn.query.QueryException
>
>
> This is the output of pdb_xlog
>
> 1> pdb_xlog
> 2>
> Msg 32000, Level 20, State 0:
> Server 'ramssqlora', Procedure 'pdb_xlog', Line 1:
> Command <pdb_xlog> failed - SQL connection or execution
> failed:
> SQL ERROR --
>
> Message: [SYBASE][SQLServer JDBC Driver]Error
> establishing socket.
>
> SQLState: 08001
> Remote Code: 0
> SQL ERROR --
> Message:
> [SYBASE][SQLServer JDBC Driver]infofeed
> SQLState: HY000
> Remote Code:
>
>
> 1. Is this because of firewall issues
> 2. The DC is required between MSSQL and Replciation
> server(I'm doing uni-directional MSSQL--> Oracle9i)
> 3. Or, any other JDBC drivers are required for this.
>
> thanks in advance
> Jayadev