cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SYSTEMDB - HANA STUDIO - Unable to connect

Go to solution
stoicaflorin
Explorer

on ‎2019 Dec 01 8:53 PM

0 Kudos
5,674

Hello,

My SAP HANA DB was upgraded from 2.0 SPS 0 to 2.00.037

I'm trying now to connect to SYSTEMDB from HANA Studio but this is not possbile. SYSTEM password was reset but still the connection doesnt work. The only way I can access it is from OS level with hdbsql. Any suggestions please? I can connect only over the tenant with SYSTEM and any other users.

Regards,

Florin

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
bharathyp
Active Participant
‎2019 Dec 02 1:06 AM
0 Kudos

Hi Florin,

If you are able to connect to tenant, that is a good sign. Means you have no connectivity issues

Can you share the exact error? authentication? communicaiton?

Pls include screenshots if possible of hdbsql as well, if you can. Tks.

Best Regards,

Bharath

stoicaflorin
Explorer
‎2019 Dec 02 9:21 AM
0 Kudos

Hello Priya, Kristen

I've started a trace from Hana Studio over the connection - for security reasons I've changed the name of the hostname to xxx 🙂

<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body><PRE><PLAINTEXT> Java version: 8 ClassLoader: com.sap.ndb.studio.jdbc.JDBCPlugin$2 [id=215438,parents=System@7428] Process ID: 9968 Driver version: package com.sap.db.jdbc, Java Platform API Specification, version 1.6, SAP HANA JDBC Driver, SAP SE, 2.4.63-956d351aa013aa9647b14219e56abec2298beb20 Trace configuration: Levels: PACKET,CONNECTIONS Show plain-text client-side encrypted values: Disabled Show timestamps: Disabled Trace file size: Unlimited Stop on error: Disabled ---- Thread 65b4d45 Thread-24 Connection opening: com.sap.db.jdbc.HanaConnectionFinalize@36fe7f87 Properties: {connectTimeout=10000, databaseName=SYSTEMDB, encrypt=false, instanceNumber=02, locale=en_US, password=***, reconnect=true, tableOutputParameterMetaData=false, transactionalLobs=false, user=FLORIN} PreferredAddresses: [xxx:30213] ResolvedAddresses: [xxx:30213] Session opening: com.sap.db.jdbc.BasicSession@24b9b682 HanaConnectionFinalize@36fe7f87 xxx:30213 RTEException: SQLSTART_REQUIRED(5) -813 Cannot connect to host xxx:30213 [connect timed out (local port 64457 to address 0.0.0.0, remote port 30213 to address 9.20.210.139 (cisbw4hana))], -813. java.lang.Throwable at com.sap.db.jdbc.trace.Tracer.printCurrentStackTrace(Tracer.java:275) at com.sap.db.jdbc.exceptions.RTEException.<init>(RTEException.java:44) at com.sap.db.jdbc.exceptions.RTEException.<init>(RTEException.java:24) at com.sap.db.jdbc.Session._throwRTEException(Session.java:938) at com.sap.db.jdbc.Session._openSocket(Session.java:551) at com.sap.db.jdbc.BasicSession.<init>(BasicSession.java:50) at com.sap.db.jdbc.BasicSession$1.newInstance(BasicSession.java:29) at com.sap.db.jdbc.Session.newInstance(Session.java:116) at com.sap.db.jdbc.ConnectionSapDB._connectAnchor(ConnectionSapDB.java:2214) at com.sap.db.jdbc.DriverSapDB._connect(DriverSapDB.java:2407) at com.sap.db.jdbc.DriverSapDB.connect(DriverSapDB.java:2063) at com.sap.ndb.studio.jdbc.JDBCConnection$1.run(JDBCConnection.java:173)

/etc/hosts from my computer (windows) was adjusted. Ping is reachable over host.

Regards,

Florin

Accepted Solutions (1)

Accepted Solutions (1)

kashyap_shah3
Contributor
‎2019 Dec 02 11:50 AM
0 Kudos

Hi Florin,

Please check if port 30213 is open on HANA database host from the host of HANA studio.
You can check this by running the command from HANA studio host: telnet <HANA database host> 30213

Please let me know if error continues even though port is opened.

Best Regards,
Kashyap Shah

Show replies
Show replies

Answers (3)

Answers (3)

stoicaflorin
Explorer
‎2019 Dec 02 1:28 PM

Hello Kashyap,

I have configured firewall and now the connection is working. (for testing purpose - disable firewall)

Thanks everyone for support.

Regards,

Florin

Show replies
Show replies
stoicaflorin
Explorer
‎2019 Dec 02 12:59 PM

Hello Kashyap,

Thank you for your support. I've testet the connection with telnet and is not working (connecting to...)

I will check from OS level to open port connection and get back here with a feedback.

Regards,

Florin

Show replies
Show replies
stoicaflorin
Explorer
‎2019 Dec 02 1:01 PM
0 Kudos

[root@xxx~]# netstat -an | grep 30213 tcp 0 0 0.0.0.0:30213 0.0.0.0:* LISTEN

Show replies
Show replies
Ask a Question