SAP Knowledge Base Article - Preview

3070372 - Fault Manager errors when using Floating IP - SAP ASE 16.0 with HADR on Azure

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 status

    fault 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

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 16.0

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.