on 04-23-2018 11:12 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.