Skip to Content
0

HANA DB Studio not connecting to Multitenant

Apr 19 at 08:41 PM

530

avatar image

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)

10 |10000 characters needed characters left characters exceeded

What is the instance number of your machine? 05 or something else?

0

The instance number is 05 sid is HDB

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Lucia Subatin
Apr 20 at 09:36 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Ayman Salem Apr 20 at 10:56 PM
0

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)


Share
10 |10000 characters needed characters left characters exceeded