Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

COOR_MODE question

1 view
Skip to first unread message

nickcousin

unread,
Mar 14, 2007, 2:12:44 PM3/14/07
to
When I set my COOR_MODE to NONE I can connect to my primary
database. When I set it to ALWAYS I can't use my test id to
connect to the database and my RCM shows and error of :
03/14/07 01:54:39 PM. The login request failed. Unable to
connect the spid '49' to the server 'opsw_testsrv'.

Any ideas where to look?
Thanks

Neal Stack

unread,
Mar 14, 2007, 4:15:10 PM3/14/07
to
Hello,

When COORD_MODE=ALWAYS or ENFORCED a CM must be connected to
OpenSwitch or else OpenSwitch will not forward the client
connections to ASE.

The COORD_USER and COORD_PASSWORD in the OpenSwitch.cfg must
match the same values in the rcm.cfg or else the RCM will be
unable to connect to OpenSwitch.

If these match and the RCM is still unable to connect to OpenSwitch,
I would recommend running OpenSwitch with the following DEBUG flags
set in the OpenSwitch.cfg file:
DEBUG=efhunqCR

And also start the RCM with the "-T A" trace flag.

Then if you can post the error logs from each component, I
might be able to tell more.

Sybase recommends running the RCM on the same server as where
OpenSwitch is running to keep things like network failures from
preventing communication between the two.

Thanks,
Neal

nickcousin

unread,
Mar 15, 2007, 11:12:46 AM3/15/07
to
Neal,

thanks for the help. Looks like the replication was held up
becasue the tables used by openswith was create by the
comm_user on the secondary side but by dbo on the primary
side. When it issued a truncate of the tabel it couldn't
find it. I changed that around to be owned by dbo and
openswitch allows me to connect.

Thanks again!!
Nick

0 new messages