SAP HANA Database not working in my trial account

[former_member604150]

Hi, dear experts of SAP,

I'm using a Trial Account on SAP Cloud platform (Neo) and I cannot acces my SAP HANA Database on it.

What I already tried:

• Create an instance of SAP , sap-hana-running.png
• Install SAP Cloud Tools in Eclipse Oxyegn
• Try to add "my" cloud system in eclipse sap-eclipse-error.png

Here I receive an error, in eclipse log I can see this text. What I' doing wrong?

Thanks a lot!

JeMo

Connection to host 'hanatrial.ondemand.com' failed.

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:745)
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: com.sap.core.connectivity.tunnel.core.handshake.TunnelHandshakeException: Invalid status of handshake response: 503 Service Unavailable
 at com.sap.core.connectivity.tunnel.client.handshake.ClientProtocolHandshaker.finishHandshake(ClientProtocolHandshaker.java:130)
 at com.sap.core.connectivity.tunnel.client.handshake.AbstractClientHandshaker.handleTunnelHandshakeResponse(AbstractClientHandshaker.java:126)
 at com.sap.core.connectivity.tunnel.client.handshake.TunnelClientHandshaker.handleChannelRead(TunnelClientHandshaker.java:62)
 at com.sap.core.connectivity.tunnel.client.handshake.AbstractClientHandshaker.channelRead0(AbstractClientHandshaker.java:153)
 at com.sap.core.connectivity.tunnel.client.handshake.AbstractClientHandshaker.channelRead0(AbstractClientHandshaker.java:32)
 at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
 at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:363)
 at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:349)
 at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:341)
 at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:293)
 at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:280)
 at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:396)
 at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:248)
 at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:363)
 at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:349)
 at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:341)
 at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:287)
 at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:363)
 at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:349)
 at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:341)
 at io.netty.handler.ssl.SslHandler.unwrap(SslHandler.java:1228)
 at io.netty.handler.ssl.SslHandler.decode(SslHandler.java:1039)
 at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:411)
 at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:248)
 at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:363)
 at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:349)
 at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:341)
 at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1334)
 at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:363)
 at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:349)
 at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:926)
 at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:129)
 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

[former_member603637]

I am having the same problem since today, I already upgraded my neo-java-web-sdk (2.119.16) to the latest version, but the problem remains the same.

This was working smoothly some weeks ago with the 15 version

I execute sudo sh neo.sh open-db-tunnel -h hanatrial.ondemand.com -a s0016643317trial -u s0016643317 -i kafkatest -p XXXXX in a screen from my aws server (or local computer). this was working perfectly fine in the past

Stacktrace:

console_open-db-tunnel_1550575807921.log session_open-db-tunnel_1550575807921.log [centos@ip-10-0-159-215 log]$ cat console_open-db-tunnel_1550575807921.log 2019-02-19 11:30:08,214 INFO [main] com.sap.jpaas.infrastructure.console.ConsoleLogger: Arguments: -h hanatrial.ondemand.com -a s0016643317trial -u s0016643317 -i kafkatest -p ******** 2019-02-19 11:30:09,478 INFO [main] com.sap.jpaas.infrastructure.console.ConsoleLogger: Starting execution of command [open-db-tunnel] 2019-02-19 11:30:09,498 INFO [pool-2-thread-1] com.sap.jpaas.infrastructure.console.ConsoleLogger: No SDK status file for your configuration was found. Creating a new status file... 2019-02-19 11:30:11,092 INFO [main] com.sap.jpaas.infrastructure.console.ConsoleLogger: There is no tools page available on host hanatrial.ondemand.com. The default tools page on host hana.ondemand.com will be used instead. This is expected behaviour as some hosts do not have corresponding tools pages 2019-02-19 11:30:11,094 INFO [pool-3-thread-1] com.sap.jpaas.infrastructure.console.ConsoleLogger: No SDK status file for your configuration was found. Creating a new status file... 2019-02-19 11:30:13,349 INFO [pool-3-thread-1] com.sap.jpaas.infrastructure.console.ConsoleLogger: Successfully performed version validity check. The returned status is LATEST 2019-02-19 11:30:13,358 INFO [main] com.sap.jpaas.infrastructure.console.ConsoleLogger: Version validity check is completed 2019-02-19 11:30:13,359 INFO [main] com.sap.jpaas.infrastructure.console.ConsoleLogger: Command [open-db-tunnel] init() finished for [3880] ms 2019-02-19 11:30:13,369 INFO [main] com.sap.core.tunnelcommands.framework.executor.CommandTunnelRequestExecutor: CommandTunnelRequestExecutor.executeRequest() called for command [open-db-tunnel] (version: 1.3.0) 2019-02-19 11:30:16,296 INFO [tunnel-client-2-1] com.sap.core.connectivity.tunnel.client.handshake.ClientProtocolHandshaker: Sending handshake request for tunnel: jdbc:///kafkatest/t0f4989824a4e44038d0da662fae8b742 and host connectivitytunnel.hanatrial.ondemand.com:443 2019-02-19 11:30:17,012 ERROR [tunnel-client-2-1] com.sap.core.connectivity.tunnel.client.handshake.ClientProtocolHandshaker: Invalid status of handshake response: DefaultHttpResponse(decodeResult: success, version: HTTP/1.0) HTTP/1.0 503 Service Unavailable Server: BigIP Connection: Keep-Alive Content-Length: 104 2019-02-19 11:30:17,013 INFO [main] com.sap.jpaas.infrastructure.console.ConsoleLogger: Command [open-db-tunnel] cleanup() finished for [0] ms 2019-02-19 11:30:17,015 FATAL [main] com.sap.jpaas.infrastructure.console.ConsoleLogger: (!) ERROR: Failed to connect the tunnel; Unable to establish tunnel connection 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.core.persistence.commands.tunnel.OpenDbTunnelCommand.openTunnelInShellProcess(OpenDbTunnelCommand.java:197) at com.sap.core.persistence.commands.tunnel.OpenDbTunnelCommand.run(OpenDbTunnelCommand.java:135) at com.sap.jpaas.infrastructure.console.CommandManager.run(CommandManager.java:185) at com.sap.jpaas.infrastructure.console.CommandManager.run(CommandManager.java:146) at com.sap.jpaas.infrastructure.console.ConsoleClient.executeCommand(ConsoleClient.java:243) at com.sap.jpaas.infrastructure.console.ConsoleClient.run(ConsoleClient.java:185) at com.sap.jpaas.infrastructure.console.ConsoleClient.main(ConsoleClient.java:80) 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:41) at com.sap.core.connectivity.tunnel.client.management.DirectTunnelOperatorImpl.connect(DirectTunnelOperatorImpl.java:31) at com.sap.core.persistence.commands.tunnel.connection.DbTunnelManager.startTunnelClient(DbTunnelManager.java:73) ... 8 more Caused by: com.sap.core.connectivity.tunnel.core.handshake.TunnelHandshakeException: Invalid status of handshake response: 503 Service Unavailable at com.sap.core.connectivity.tunnel.client.handshake.ClientProtocolHandshaker.finishHandshake(ClientProtocolHandshaker.java:129) at com.sap.core.connectivity.tunnel.client.handshake.AbstractClientHandshaker.handleTunnelHandshakeResponse(AbstractClientHandshaker.java:128) at com.sap.core.connectivity.tunnel.client.handshake.TunnelClientHandshaker.handleChannelRead(TunnelClientHandshaker.java:63) at com.sap.core.connectivity.tunnel.client.handshake.AbstractClientHandshaker.channelRead0(AbstractClientHandshaker.java:156) at com.sap.core.connectivity.tunnel.client.handshake.AbstractClientHandshaker.channelRead0(AbstractClientHandshaker.java:33) at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340) at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:310) at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:297) at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:413) at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:265) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340) at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340) at io.netty.handler.ssl.SslHandler.unwrap(SslHandler.java:1407) at io.netty.handler.ssl.SslHandler.decodeJdkCompatible(SslHandler.java:1177) at io.netty.handler.ssl.SslHandler.decode(SslHandler.java:1221) at io.netty.handler.codec.ByteToMessageDecoder.decodeRemovalReentryProtection(ByteToMessageDecoder.java:489) at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:428) at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:265) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340) at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1434) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348) at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:965) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:163) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459) at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:884) at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) at java.lang.Thread.run(Thread.java:748)

[former_member604150]

An update: after multiply try&errors, which are all failed I just created an entirely neu trial account on hanatrial.ondemand.com. And now I am able to connect my hana database schema.

[ennoury]

Hi Jewgenij Moldawski,

I think 'user id' will always be - 'SYSTEM' and password with be the one which was created at the time of creating HANA database instance.