Skip to Content
-1

Not able connect to the HANA database in us1.hana.ondemand.com using HANA studio

Apr 23 at 10:12 AM

139

avatar image
Former Member

Hi All,

I am not able to connectany HANA database in the product landscape “us1.hana.ondemand.com”, although I am able to connect ‘hanatrial.ondemand.com’ from HANA Studio.

I am using below credential while adding hana cloud system in hana studio.

Region Host: us1.hana.ondemand.com

Sub-account name: bcXXXXXXX

User name: S00xxxxxxx

Password: xxxxxxxx

Database: ii8

Database user: SDI_USER

Passowrd: xxxxxx


Please find below log of error information while connecting to HANA DB:

!ENTRY com.sap.cloud.tools.eclipse.hana.tunnel 4 0 2018-04-23 13:52:31.242

!MESSAGE Connection to host 'us1.hana.ondemand.com' failed.

!STACK 0

java.util.concurrent.ExecutionException: com.sap.jpaas.infrastructure.console.exception.CommandException: Failed to connect the tunnel

at java.util.concurrent.FutureTask.report(FutureTask.java:122)

at java.util.concurrent.FutureTask.get(FutureTask.java:192)

at com.sap.ndb.studio.common.CallableUtil.executeCallable(CallableUtil.java:62)

at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionWizard$1.run(CloudSystemConnectionWizard.java:101)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)

Caused by: com.sap.jpaas.infrastructure.console.exception.CommandException: Failed to connect the tunnel

at com.sap.core.persistence.commands.tunnel.connection.DbTunnelManager.startTunnelClient(DbTunnelManager.java:76)

at com.sap.core.persistence.commands.tunnel.api.CommandTunnelHandler.openTunnel(CommandTunnelHandler.java:148)

at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemHelper.openTunnel(CloudSystemHelper.java:289)

at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemHelper.addCloudSystem(CloudSystemHelper.java:343)

at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionWizard$1$1.call(CloudSystemConnectionWizard.java:92)

at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionWizard$1$1.call(CloudSystemConnectionWizard.java:1)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:812)

Caused by: com.sap.core.connectivity.tunnel.api.management.ConnectionFailedException: Unable to establish tunnel connection

at com.sap.core.connectivity.tunnel.client.management.DirectTunnelOperatorImpl.connect(DirectTunnelOperatorImpl.java:36)

at com.sap.core.persistence.commands.tunnel.connection.DbTunnelManager.startTunnelClient(DbTunnelManager.java:73)

... 9 more

Caused by: java.io.IOException: An existing connection was forcibly closed by the remote host

at sun.nio.ch.SocketDispatcher.read0(Native Method)

at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:43)

at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:223)

at sun.nio.ch.IOUtil.read(IOUtil.java:192)

at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:380)

at io.netty.buffer.PooledUnsafeDirectByteBuf.setBytes(PooledUnsafeDirectByteBuf.java:288)

at io.netty.buffer.AbstractByteBuf.writeBytes(AbstractByteBuf.java:1100)

at io.netty.channel.socket.nio.NioSocketChannel.doReadBytes(NioSocketChannel.java:367)

at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:118)

at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:642)

at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:565)

at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:479)

at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:441)

at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:858)

at io.netty.util.concurrent.DefaultThreadFactory$DefaultRunnableDecorator.run(DefaultThreadFactory.java:144)

... 1 more

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

2 Answers

Lucas Vaccaro
Apr 23 at 08:46 PM
0

Hi Koushik,

Are you within a corporate network? Maybe there's some network component closing the connection in between and you have to white-list some IP's.

Regards,
Lucas

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Lucas,

We have tried it outside of our corporate network too and have got same error log :( .

Regards,

Koushik

0
Ivan Mirisola
Apr 24 at 09:17 PM
0

Hi Koushik,

Are you trying to connect from a Neon Eclipse or from a HANA Studio? Are you running the latest plugin versions?

I have just tried to connect from a Eclipse Neon to a HANA DB I have on US1 landscape and to me it seems to work. I have a direct connection to the internet, so I don't use a proxy setting on my Eclipse.

Your issue tells me that the connection to us1 was broken (java.io.IOException: An existing connection was forcibly closed by the remote host). This usually happens when the host is not reachable due to network problems or when the client (Eclipse) is unable to complete the SSL handshake. I believe your issue is the the later since you tell us your machine is able to browse the internet.

You might be running an older version of HANA Studio or even older HANA Eclipse plugins. If that's the case you might face connectivity issues. Please make sure you have the latest plugins installed by doing a "Help" -> "Check for Updates" on Eclipse. Mine are:

SAP HANA Studio Version: 2.3.34

If everything else fails, then try establishing a db tunnel with the NEO SDK, like this:

neo open-db-tunnel -h <host> -u <user> -a <subaccount> --id<schema ID>

Please note that the user here is not the DB user... it is the platform user. And SchemaID is not an internal DB schema, it is the ID of your database (to be found via Cockpit).

Once you are done with this tunnel, you can create a local hana connection using localhost for your hana box (jdbc:sap://localhost:3001).

Regards,
Ivan

Share
10 |10000 characters needed characters left characters exceeded