Skip to Content
1

Unable to connect to SAP HANA from HANA Studio (Eclipse Plugin) or HCP Cockpit

Oct 21, 2016 at 10:08 AM

1k

avatar image
Former Member

Hello,

Have been using the HCP developer trial account for quite some time. In the process have deployed Java applications in the HCP cockpit and connected to the corresponding DB schemas using HANA Development Tools (HANA Studio - Eclipse Plugin).

Since yesterday I am not able to connect to the database schemas.

Neither able to log on to existing Cloud system or create a new one in the Systems tab, getting this error -

Could not connect to SAP HANA Cloud Platform system
An internal server error occurred.
Unexpected exception in openDbTunnel() called with account=p*******trial, schemaId=****


Corresponding Eclipse Error Log Extract:

...........................

........................

Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://localhost:30315;10.117.96.40:30110 [None of the hosts could be reached: [Cannot connect to host localhost:30315 [Connection refused: connect], -813.; host = 10.117.96.40:30110 error = Cannot connect to host 10.117.96.40:30110 [Connection timed out: connect], -813.]].

...........................

........................

Also not able to query Databases or Schemas through the HCP cockpit.

Even tried the Data Source Binding option for the application in Cockpit. All 3 options give show this error in the cockpit-

Unable to retrieve DB/schema list - Internal Exception: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed

Error Code: 0 Call: SELECT t0.CHANGED_BY, t0.DBAREATYPE, t0.DBFLAVOR, t0.ENCRYPTED_PWD, t0.ISSCHEMACREATED, t0.PSADMINVMNAME, t0.STATE, t0.STATECHANGEDAT, t0.USR, t0.ID, t0.ACCOUNT, t0.SERVER_HOST FROM DBAREA t0, DBSERVER t1 WHERE ((((t0.ISSCHEMACREATED = 1) AND (t0.ACCOUNT = ?)) AND t1.HOST LIKE ?) AND (t1.HOST = t0.SERVER_HOST)) bind => [2 parameters bound] Query: ReadAllQuery(referenceClass=DbArea sql="SELECT t0.CHANGED_BY, t0.DBAREATYPE, t0.DBFLAVOR, t0.ENCRYPTED_PWD, t0.ISSCHEMACREATED, t0.PSADMINVMNAME, t0.STATE, t0.STATECHANGEDAT, t0.USR, t0.ID, t0.ACCOUNT, t0.SERVER_HOST FROM DBAREA t0, DBSERVER t1 WHERE ((((t0.ISSCHEMACREATED = 1) AND (t0.ACCOUNT = ?)) AND t1.HOST LIKE ?) AND (t1.HOST = t0.SERVER_HOST))")

Please assist me in resolving the same.

Thanks,

Madhavan

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Matthias Steiner
Oct 21, 2016 at 10:16 AM
-1

(Please try "search" first next time.) Yes, there are issues at the moment - please refer to: https://answers.sap.com/questions/38957/error-in-hcp-persistence-databases-schemas.html

Locking this thread now!

Share
10 |10000 characters needed characters left characters exceeded