Skip to Content

open-db-tunnel failing ( 503 Service Unavailable)

Hi,

I am not able to set up a open-db-tunnel anymore. I tried using as well as my old (.15) and the latest neo-java-web-sdk-2.119.16.zip , My Hana Trial table is running and the way of connecting was working in the past.

sudo sh neo.sh open-db-tunnel -h hanatrial.ondemand.com -a s0016643317trial -u s0016643317 -i kafkatest -p ******

You can find the stacktrace below:

thank you in advance

Olivier

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)

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Feb 21, 2019 at 10:46 PM

    Hi Olivier,

    I got same problem too. My hana trial is running and also connecting was working in the past.

    2019-02-21 14:44:16,648 INFO [main] com.sap.jpaas.infrastructure.console.ConsoleLogger: Arguments: -h hanatrial.ondemand.com -u i871180 -p ******** -a i871180trial --id deeplens 2019-02-21 14:44:17,948 INFO [main] com.sap.jpaas.infrastructure.console.ConsoleLogger: Starting execution of command [open-db-tunnel] 2019-02-21 14:44:18,097 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-21 14:44:19,496 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-21 14:44:19,496 INFO [main] com.sap.jpaas.infrastructure.console.ConsoleLogger: Version validity check is completed 2019-02-21 14:44:19,496 INFO [main] com.sap.jpaas.infrastructure.console.ConsoleLogger: Command [open-db-tunnel] init() finished for [1548] ms 2019-02-21 14:44:20,353 INFO [main] com.sap.core.tunnelcommands.framework.executor.CommandTunnelRequestExecutor: CommandTunnelRequestExecutor.executeRequest() called for command [open-db-tunnel] (version: 1.2.0) 2019-02-21 14:44:22,797 INFO [tunnelclient-2-1] com.sap.core.connectivity.tunnel.client.handshake.ClientProtocolHandshaker: Sending handshake request for tunnel: jdbc:///deeplens/t8cdbf7aad20e436f8a1f796d6fa2ede6 and host connectivitytunnel.hanatrial.ondemand.com 2019-02-21 14:44:23,544 ERROR [tunnelclient-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-21 14:44:23,544 INFO [main] com.sap.jpaas.infrastructure.console.ConsoleLogger: Command [open-db-tunnel] cleanup() finished for [0] ms 2019-02-21 14:44:23,546 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:36) 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:127) 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:366) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:352) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:345) 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:366) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:352) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:345) at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:266) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:366) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:352) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:345) at io.netty.handler.ssl.SslHandler.unwrap(SslHandler.java:1066) at io.netty.handler.ssl.SslHandler.decode(SslHandler.java:900) 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:366) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:352) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:345) at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1294) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:366) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:352) at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:911) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:611) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:552) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:466) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:438) at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:140) at io.netty.util.concurrent.DefaultThreadFactory$DefaultRunnableDecorator.run(DefaultThreadFactory.java:144) at java.lang.Thread.run(Unknown Source)

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 25, 2019 at 05:47 AM

    Hi Jeff Chen,

    Did you got it working in the meanwhile, or did you find a way to bypass the problem?

    kr

    Olivier

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 25, 2019 at 02:30 PM

    Hi, it seems to be working again, but i don't get why.

    Could someone give a reason why it was not working?

    The only difference was that my location was different during the last weeks, but as it was not working on my aws server (US WEST) and now again, this reason does not really make sense.

    kr

    Olivier

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 25, 2019 at 07:09 PM

    Hi Olivier,

    This is not my first time need to handle this problem, so I just wait one day and It's working now.

    But, I'm still curious about this problem so I guess because we are using trial account?

    Best,

    Jeff

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.