Skip to Content

HANA DB Studio not connecting to Multitenant

I am trying to get HANA db studio version 2.3.35 to connect to my HANA 2.3 instance. As listed the connection attempts get an odbc error. My hana instance is a vmware Linuz RHEL 7.4 installation. The client and DB studio are install on a windows 2012 server and a windows 7 machine. The issue is the one listed a couple of times regarding the studio trying to connect to port 30515 and needing to connect to 30541. I read sap note 2101244 which identifies the issue but doesn't state how to get around the port issue. I cannot find a global.ini file to edit on either of my installations so what am I missing here.

Thanks In advance

Troy Sorbet

output

com.sap.ndb.studio.jdbc.JDBCConnectionStatus: Database connection is not available; see error log at com.sap.ndb.studio.jdbc.JDBCPlugin.createConnection(JDBCPlugin.java:281) at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.executeTryJDBC(SAPSystemObjectUpdate.java:283) at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.execute(SAPSystemObjectUpdate.java:103) at com.sap.ndb.studio.navigator.operations.UpdateSAPSystemOperation.execute(UpdateSAPSystemOperation.java:73) at com.sap.ndb.studio.datamodel.controler.DataModelOperation.execute(DataModelOperation.java:70) at com.sap.ndb.studio.datamodel.controler.DataModelOperationQueue$DataModelOperationThread.run(DataModelOperationQueue.java:99) Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://s########m [Cannot connect to host s########m:30513 [Connection timed out: connect (local port 52254 to address 0:0:0:0:0:0:0:0, remote port 30513 to address 132.172.231.117 (s########m.s##.###.###))], -813.]. at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:126) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:203) at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.newInstance(SQLExceptionSapDB.java:50) at com.sap.db.jdbc.Driver._connect(Driver.java:1434) at com.sap.db.jdbc.Driver.connect(Driver.java:1068) at com.sap.ndb.studio.jdbc.JDBCConnection$1.run(JDBCConnection.java:169)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 20 at 09:36 PM

    Have you tried forcing the tenant and port as in step 7.b here (sounds like HDB:30541 in your case)? https://www.sap.com/developer/tutorials/hxe-howto-eclipse.html

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 20 at 10:56 PM

    as I see from the log:

    com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot 
    connect to jdbc:sap://s########m [Cannot connect to host 
    s########m:30513 [Connection timed out: connect (local port 52254 to 
    address 0:0:0:0:0:0:0:0, remote port 30513 to address 132.172.231.117 
    (s########m.s##.###.###))], -813.]. at

    it can not connect to your HANA SystemDB (Port 30513),

    First check that the HANA system has the address "132.172.231.117".

    Second, check the firewall on HANA system and on the client (open the ports you want)


    Add comment
    10|10000 characters needed characters exceeded