Can't connect to the HANA database in neo.ondemand.com

[Former Member]

I have trouble accessing to any HANA database in the product landscape “neo.ondemand.com” via Eclipse -> SAP Hana Administration Console since yesterday (Dec 22, 2014). The following is the error information when connecting to the HANA db:

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

  at java.util.concurrent.FutureTask.report(Unknown Source)

  at java.util.concurrent.FutureTask.get(Unknown Source)

  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:98)

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

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:75)

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

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

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

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

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

  at java.util.concurrent.FutureTask.run(Unknown Source)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

  at java.lang.Thread.run(Unknown Source)

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:34)

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

  ... 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(Unknown Source)

  at sun.nio.ch.IOUtil.readIntoNativeBuffer(Unknown Source)

  at sun.nio.ch.IOUtil.read(Unknown Source)

  at sun.nio.ch.SocketChannelImpl.read(Unknown Source)

  at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:64)

  at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:108)

  at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:318)

  at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:89)

  at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178)

  at org.jboss.netty.handler.execution.MemoryAwareThreadPoolExecutor$MemoryAwareRunnable.run(MemoryAwareThreadPoolExecutor.java:622)

  ... 3 more

[tom_slee · Accepted solution]

I have been having the same issue since yesterday (Dec 23 2014): inability to connect to a HANA instance on neo.ondemand.com from within the SAP network. My stack trace is appended, but I think it is the same as Danielle's. I can connect to other HANA instances, just not to HCP.

I have been using the existing profile and HANA Studio install for several weeks with no problems. I have tried setting the proxy settings in Eclipse both to "proxy" and "proxy.wdf.sap.corp" (which it was before). My first thought was that this is related to an Eclipse plugin update, but I am also unable to open a tunnel to my neo.ondemand.com instances from the neo command line tool. My ability to connect to hana.ondemand.com instances remains unaffected.

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

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

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

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

  at com.sap.cloud.tools.eclipse.hana.tunnel.CloudSystemEventListener$1.run(CloudSystemEventListener.java:125)

  at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)

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:34)

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

  ... 4 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(Unknown Source)

  at sun.nio.ch.IOUtil.readIntoNativeBuffer(Unknown Source)

  at sun.nio.ch.IOUtil.read(Unknown Source)

  at sun.nio.ch.SocketChannelImpl.read(Unknown Source)

  at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:64)

  at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:108)

  at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:318)

  at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:89)

  at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178)

  at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)

  at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)

  at org.jboss.netty.handler.execution.MemoryAwareThreadPoolExecutor$MemoryAwareRunnable.run(MemoryAwareThreadPoolExecutor.java:622)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

  at java.lang.Thread.run(Unknown Source)

[tom_slee · Accepted solution]

Daniell - My problem has fixed itself over the New Year: I made no changes but can now connect. Have you seen the same? I would feel better if I knew how to notify people or diagnose the problem...

[Former Member · Accepted solution]

Hi Tom,

My problem has been fixed by itself over the New Year too. I've also sent an email to the HCP support teams and got a reply that this issue is caused by the upgrade of the Loadbalancer for neo.ondemand.com, which destroyed the connectivity service tunnel functionality. The HCP support team also sent me the planned downtime email about the Prod landscape, which people can subscribe to this email via the website (hanacloud-announce Info Page). I assume the people who has subscribe it will recieve email notifcation before any planned downtime/update happens for Prod landscape.

[tom_slee · Accepted solution]

Thanks - I have subscribed to the email. Fingers crossed...

[former_member195001]

Hi Danielle ,

     I thing your problem is similar to this :

     http://scn.sap.com/thread/3663669

     Have a look at this.

Thank you ,

Arpitha

[Former Member]

Thanks Arpitha for the information.

I've tried to remove and add proxy settings, however, nothing works.

I can connect to the database before and I didn't change anything lately. I am guessing it may be caused by the system upgrade on the server side. However, the website I checked for the timeline didn't mention anything  about the system upgrade happening these two days.