2589738 - JDBC:Cannot connect to SiteID=0

While trying to access certain tables in distributed system, following error is encountered:

  SAP DBTech JDBC: Cannot connect to SiteID=0 [VolumeID=4].

If the issue is reproduced with JDBC tracing following error can be seen in the JDBC trace:

RTEException: SQLSTART_REQUIRED(5) -813 Cannot connect to host 100.xx.xx.xxx:3xx15 [Connection timed out: connect (local port xxxxx to address 0:0:0:0:0:0:0:0, remote port 3xx15 to address 100.xx.xx.xxx)], -813.
Stack trace:
java.lang.Throwable
at com.sap.db.jdbc.trace.Tracer.printCurrentStackTrace(Tracer.java:209)
at com.sap.db.jdbc.exceptions.RTEException.<init>(RTEException.java:43)
at com.sap.db.jdbc.exceptions.RTEException.<init>(RTEException.java:23)
at com.sap.db.jdbc.Session._openSocket(Session.java:715)
at com.sap.db.jdbc.Session.openSocket(Session.java:457)
at com.sap.db.jdbc.Session$1.open(Session.java:632)
at com.sap.db.jdbc.HanaSystem.getSession(HanaSystem.java:316)
at com.sap.db.jdbc.ConnectionSapDB._openSession(ConnectionSapDB.java:2060)
at com.sap.db.jdbc.CallableStatementSapDB.getSession(CallableStatementSapDB.java:1687)
at com.sap.db.jdbc.CallableStatementSapDB.getSessionForExecute(CallableStatementSapDB.java:311)
at com.sap.db.jdbc.CallableStatementSapDB._execute(CallableStatementSapDB.java:6159)
at com.sap.db.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.java:2156)
at com.sap.ndb.studio.sql.editor.SQLExecuteJob$1.run(SQLExecuteJob.java:86)

using null

• multi-node
• SAP HANA PLATFORM EDIT. 1.0
• SAP HANA PLATFORM EDIT. 2.0

 multi-node, jdbc, hana , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , How To