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.
SAP Knowledge Base Article - Preview