3533179 - HANA instance inaccessible from HANA Studio & HANA Cockpit although services are all online and in GREEN state

• The HANA Database instance cannot be reached via the official HANA monitoring interfaces such as HANA Studio & HANA Cockpit .
• The SAP HANA Studio log file shows that HANA Studio cannot reach any of the ip addresses nor resolve their hostnames upon connection attempt :
  
  

  Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://Hostname;IP Address [None of the hosts could be reached. Unknown host Hostname/<unresolved>:SQL Port.  -709: (uninitialized) -> Hostname:SQL Port ConnectionID:0 SessionID:0; host = IP Address:SQL Port error = Cannot connect to host /IP Address:SQL Port. Connection timed out: connect: IP Address:SQL Port -813: (uninitialized) -> IP Address:SQL Port ConnectionID:0 SessionID:0].
  
  Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://Hostname;IP Address [None of the hosts could be reached. Data receive failed (socket timeout). Channel not readable after timeout on selector: IP Address:59955 -> Hostname:SQL Port ConnectionID:0 SessionID:0; host = IP Address:SQL Port error = Data receive failed (socket timeout). Channel not readable after timeout on selector: IP Address:59961 -> IP Address:SQL Port ConnectionID:0 SessionID:0].
  
  Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://Hostname [Data receive failed (socket timeout). Channel not readable after timeout on selector: IP Address:59933 -> Hostname:SQL Port ConnectionID:0 SessionID:0].
  
  Caused by: com.sap.db.jdbc.exceptions.RTETimeoutException: Data receive failed (socket timeout). Channel not readable after timeout on selector: IP Address:59955 -> Hostname:SQL Port ConnectionID:0 SessionID:0

   
• All services in a GREEN state according to sapcontrol :
  
  

  Hostname:HDB:sidadm /usr/sap/SID/HDB00/Hostname> /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function GetProcessList
  
  22.10.2024 05:21:26
  GetProcessList
  OK
  name, description, dispstatus, textstatus, starttime, elapsedtime, pid
  hdbdaemon, HDB Daemon, GREEN, Running, 2024 06 21 11:09:57, 2946:11:29, 57405
  hdbcompileserver, HDB Compileserver, GREEN, Running, 2024 06 21 11:10:06, 2946:11:20, 58260
  hdbindexserver, HDB Indexserver-SID, GREEN, Running, 2024 06 21 11:10:06, 2946:11:20, 58326
  hdbindexserver, HDB Indexserver-SID, GREEN, Running, 2024 06 21 11:10:06, 2946:11:20, 58329
  hdbnameserver, HDB Nameserver, GREEN, Running, 2024 06 21 11:09:57, 2946:11:29, 57473
  hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2024 06 21 11:10:06, 2946:11:20, 58263
  hdbwebdispatcher, HDB Web Dispatcher, GREEN, Running, 2024 06 21 11:12:22, 2946:09:04, 67400

SAP HANA Platform Edition 2.0

SAP HANA Studio

SAP HANA Cockpit

KBA , HAN-STD-ADM-DBA , SAP HANA Studio (Eclipse) Admin Tooling , HAN-CPT-CPT2-ADM , SAP HANA Cockpit 2 (Administration Core) , HAN-DB , SAP HANA Database , Problem