Symptom
- HADR Fault Manager (FM) log is reporting the following error every few minutes:
ERROR AT sybOpenClient.cpp:executeQuery:2549 TIME: 2021 Jun 22 07:56:57 DESCRIPTION: Server message: Number 15933, Severity 16, State 1, Line 107, Server MYSRV, Procedure sp_listener --- Message string: A listener with protocol tcp, host xxx.xx.xx.xxx, port 50519 already exists. LAST OS-ERROR: (0) : Success - After HADR FM and both RMAs are restarted, HADR FM status shows:
> sybdbfm statusfault manager running, pid = 28171, fault manager overall status = ERR, currently executing in mode BOOTING
*** sanity check report (3)***.
node 1: server hostname1.corp.myc.tst, site HAP.
db host status: UNKNOWN.
db status OK hadr status PRIMARY.
node 2: server hostname2.corp.myc.tst, site HAC.
db host status: UNKNOWN.
db status OK hadr status STANDBY.
replication status: SUSPENDED.
VIPA status: ERROR.
failover prerequisites fulfilled: NO. - Now HADR FM log reports different errors like:
. GET_IP_ADDRESS_PROPERTIES=No address xxx.xx.xx.xxx with ipv4 address family assigned to any network interface is found.
…
interface is: .
address is: .
hostctrl GetIpAddressProperties: address not found.
. odbc_call timed out.
call is running.
...
terminateThread (CFB0D700) failed.
connect via odbc to ASE database server failed.
. ERROR in function SQLConnectWithRetry (1547) (SQLConnectWithRetry failed): (30293) [HY000] [SAP][ASE ODBC Driver]The socket failed to connect within the timeout specified.
ERROR in function SQLConnectWithRetry (1547) (SQLConnectWithRetry failed): (30012) [08001] [SAP][ASE ODBC Driver]Client unable to establish a connection
Connection failed using DRIVER={Adaptive Server Enterprise};server=xxx.xx.xx.xxx;port=50519;uid=sa;pwd=xxxxxxxxxx;EncryptPassword=1;logintimeout=3;CommandTimeOut=3;;EnableRedirection=0;.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03
- High Availability Disaster Recovery (HADR)
- Fault Manager (FM) 101
- Microsoft Azure
Product
Keywords
cloud, floating, floating_ip, support_floating_ip, ha/syb/support_floating_ip, vdbhost, ha/syb/vdbhost, VIP, ha/syb/az_ilb_port, ILB, Internal Load Balancer , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.