Symptom
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
Read more...
Environment
multi-node
SAP HANA PLATFORM EDIT. 1.0
SAP HANA PLATFORM EDIT. 2.0
Product
Keywords
multi-node, jdbc, hana , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , Problem
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.