Connection failed. Could not connect to the SAP HANA Cloud Platform System

[former_member78643]

Hi Rui,

When working on Week 2 Unit 1 I was trying to create a db-tunel and got the following error message when adding a SAP HANA Cloud System:

"Connection failed. Could not connect to the SAP HANA Cloud Platform System. Check the error log for more details."

Event Details:

Message: Could not add SAP HANA Cloud Platform system

Exception Stack Trace:

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

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

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

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

  at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemHelper.connectToSapSystem(CloudSystemHelper.java:327)

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

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

  at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

Thanks in advance for the help.

Felipe

[Former Member · Accepted solution]

GO to preferences ---> Network Connections ---> Active provider choose as a (native).

I hope you will not got this error.

Thanks and best Regards

Aasif Shah

[Vlado · Accepted solution]

If it were a proxy issue, you would not get past the first wizard page.

[Former Member · Accepted solution]

you are right VLadimir Pavlov....

But I observ when we set Proxy as manual than we are not able to connect with hana cloud.

[Vlado · Accepted solution]

Network setup is different from one user to another, that's why we can't give a "one instruction fits everyone". For your case it might well be you don't work behind a proxy.

A basic test whether your network connections are set up correctly is to try and load the predefined update sites in the Eclipse preferences.

However, as said, it's unrelated to the issue in this thread.

[Former Member]

Same problem here. Found following URL in the error log.

https://services.hanatrial.ondemand.com/services/v1/instances/p1234567890trial/persistence/v3/dbtunn...

When I enter this URL into my Firefox browser (GET method), a basic auth dialog shows up. When I enter my user/pass, I don't get a 500, but a divergent 405 (method not allowed) and following HTTP-Headers.

So for me it looks like a problem on HCP side!

Allow    DELETE,PUT,OPTIONS

Cache-Control    private

Content-Length    0

Date    Fri, 27 Feb 2015 13:52:19 GMT

Expires    Thu, 01 Jan 1970 00:00:00 UTC

Server    SAP

Set-Cookie    BIGipServer~jpaas_folder~adminpersistencesvcservices.svc.hanatrial.ondemand.com=!gpA6mo8QjCowj1c+JMN/FDj9PjIkQ6g72ztf9hMtsIlmQjS5GXjLDLVTVonQIDT0wRmSIbU/nJLhde1F8U9TGzkJ+IIiRqxCzVFd4s02GDtN7V10rUz4GzI5amFSN4ELpvz5teqyniMCEaeimWs4pfzhI4iiUd4=; path=/; httponly; secure; httponly; secure

Quelltext anzeigen

Accept    text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

Accept-Encoding    gzip, deflate

Accept-Language    de,en-US;q=0.7,en;q=0.3

Authorization    Basic cDE5NDEyMTAzMDg6Z21zX3h5MTc=

Cache-Control    max-age=0

Connection    keep-alive

Cookie    JTENANTSESSIONID_7b1b1837-b36b-42de-b045-c9c3780d9766=hk5IqenfSlKzhdqykx7WXK3WZMh290C9zkZrdxMYX0c%3D; oucrskxsicrmyatyuskyzgxze=aOGjeao6O3DlEsV%2BcNh%2BRyJ9D8uNGf70n1Fj%2FXfNH8zSoh8IrZDZ1oLkla97nv%2FeTt9TsuIKyKhBmG4qxKbj5gqu8MJ9Ytdef0S8NRTkiyfHHp9tgnoc6QnHhYw5vRLgxN2OHFnnC2KBdCK1sVe8Nkwr%2B%2FD5LRO2NfcrHx6TEt7QmKvoEEYybxLvN8loYnskbuvGFnZejNhCjzGPcjCWBWcGgApbNJXPnSKyM%2FXWrb3TtMIUzbkZlQGzcpFSMJqOTMawyZoC%2BJxugC8Dp7IurOnvLgMXZ4saFPnj3e1rKGkO%2FeL00H2Ub96Et%2BMSBx9IcdlUmqAFhTdXsyPORQ355B5x1nA9jpxtjku%2BRz1biUI%3D; BIGipServer~jpaas_folder~adminpersistencesvcservices.svc.hanatrial.ondemand.com=!9IChy3JL6XEj3+M+JMN/FDj9PjIkQ7Yr3ufYBXJQ9KlTgv8Tw2yZenrhbUFttNq/tCBN8tMhr1/vYyR7T5MndmB1V9oorv5ul0isbTwM0Tn479+cjtAK7IChL48TANTJUk+48z8O2uMn827q3jryFGF+2a4CZNM=; BIGipServer~jpaas_folder~services.hanatrial.ondemand.com=!1C+OI6z737dMbDs+JMN/FDj9PjIkQyJSq3xcGme1daULW6g6FpkeyH1RhrzuNsDnQXlm5zhrPNc6OnQ=

DNT    1

Host    services.hanatrial.ondemand.com

User-Agent    Mozilla/5.0 (Windows NT 6.3; WOW64; rv:35.0) Gecko/20100101 Firefox/35.0

Content of my error log:

Could not connect to the SAP HANA Cloud Platform system. Check the error log for more details.

!ENTRY org.apache.log4j 4 0 2015-02-27 14:33:44.289

!MESSAGE com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy  - An internal server error occurred.

!ENTRY org.apache.log4j 4 0 2015-02-27 14:33:44.298

!MESSAGE com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy  - request URI: https://services.hanatrial.ondemand.com/services/v1/instances/p1234567890trial/persistence/v3/dbtunn...

!ENTRY org.apache.log4j 4 0 2015-02-27 14:33:44.306

!MESSAGE com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy  - statusCode: 500 Internal Server Error

!ENTRY org.apache.log4j 4 0 2015-02-27 14:33:44.313

!MESSAGE com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy  - contentType: text/plain

!ENTRY org.apache.log4j 4 0 2015-02-27 14:33:44.321

!MESSAGE com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy  - content: Unexpected exception in openDbTunnel() called with account=p1234567890trial, schemaId=test123

!ENTRY com.sap.cloud.tools.eclipse.hana.tunnel 4 0 2015-02-27 14:33:46.779

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

!STACK 0

java.util.concurrent.ExecutionException: com.sap.jpaas.infrastructure.console.exception.CommandException: An internal server error occurred.

Unexpected exception in openDbTunnel() called with account=p1234567890trial, schemaId=test123

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

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

Caused by: com.sap.jpaas.infrastructure.console.exception.CommandException: An internal server error occurred.

Unexpected exception in openDbTunnel() called with account=p1234567890trial, schemaId=test123

    at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.throwCommandExceptionWithContentInfoAndLog(DefaultResponseConsumingStrategy.java:92)

    at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.throwCommandExceptionWithContentInfoAndLog(DefaultResponseConsumingStrategy.java:56)

    at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.throwCommandExceptionWithContentInfoAndLog(DefaultResponseConsumingStrategy.java:51)

    at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.consume(DefaultResponseConsumingStrategy.java:45)

    at com.sap.core.tunnelcommands.framework.executor.JsonConsumingStrategy.consume(JsonConsumingStrategy.java:31)

    at com.sap.core.persistence.commands.tunnel.api.OpenDbTunnelConsumer.consume(OpenDbTunnelConsumer.java:37)

    at com.sap.core.tunnelcommands.framework.executor.CommandTunnelRequestExecutor.executeRequest(CommandTunnelRequestExecutor.java:89)

    at com.sap.core.tunnelcommands.framework.executor.CommandTunnelRequestExecutor.executeRequest(CommandTunnelRequestExecutor.java:39)

    at com.sap.core.persistence.commands.tunnel.api.CommandTunnelHandler.performOpenTunnelRequest(CommandTunnelHandler.java:263)

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

    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(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)

[Former Member]

Problem disappeared.

After an update of Eclipse Platform (-> Help -> Check for Updates) the problem was gone.

[former_member189133]

It worked.

Thank you

[Former Member]

Hi Felipe,

you found the solution?, I have the same problem...

regards

[Former Member]

Hi Johnny,

Same problem here. Did you find a solution? Beginning to think I should wait till the problem goes away by itself by some miracle.

-M

[Davidyanez]

Hello Colleagues,

I have face the same issue and this modification solve the issue: http://scn.sap.com/message/15135346#15135346

It seems that the tunnel app is not able to detect the local machine to check for free ports.

It is working for me using Kepler and Mac OS X 10.10.

Best Regards.

David.

[Former Member]

David, this is my first time trying out HCP.  I'm getting a similar issue with an Eclipse DBTunnel internal server exception on trying to add a trial instance on HCP after having created the HANA instance in the HCP Cockpit.  I tried your recommended fix by adding my hostname in /etc/hosts tied to loopback, but no luck.  I'm able to get through Add SAP HANA Cloud Platform System and see the HANA instance I created and select it, so authentication seems to be working.  But after clicking on Finish in the Trial Instances dialog, I get the exception below (anonymized my account info).

I'm running Eclipse Luna on Mac OS X 10.10.2 and following the tutorial from here:

Any information would be appreciated.  Thanks.

Joe

java.util.concurrent.ExecutionException: com.sap.jpaas.infrastructure.console.exception.CommandException: An internal server error occurred.

Unexpected exception in openDbTunnel() called with account=s000xxxxxxxtrial, schemaId=hihanaxs

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

Caused by: com.sap.jpaas.infrastructure.console.exception.CommandException: An internal server error occurred.

Unexpected exception in openDbTunnel() called with account=s000xxxxxxxtrial, schemaId=hihanaxs

    at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.throwCommandExceptionWithContentInfoAndLog(DefaultResponseConsumingStrategy.java:92)

    at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.throwCommandExceptionWithContentInfoAndLog(DefaultResponseConsumingStrategy.java:56)

    at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.throwCommandExceptionWithContentInfoAndLog(DefaultResponseConsumingStrategy.java:51)

    at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.consume(DefaultResponseConsumingStrategy.java:45)

    at com.sap.core.tunnelcommands.framework.executor.JsonConsumingStrategy.consume(JsonConsumingStrategy.java:31)

    at com.sap.core.persistence.commands.tunnel.api.OpenDbTunnelConsumer.consume(OpenDbTunnelConsumer.java:37)

    at com.sap.core.tunnelcommands.framework.executor.CommandTunnelRequestExecutor.executeRequest(CommandTunnelRequestExecutor.java:89)

    at com.sap.core.tunnelcommands.framework.executor.CommandTunnelRequestExecutor.executeRequest(CommandTunnelRequestExecutor.java:39)

    at com.sap.core.persistence.commands.tunnel.api.CommandTunnelHandler.performOpenTunnelRequest(CommandTunnelHandler.java:263)

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

    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)

[Former Member]

So I tried again this morning adding the trial HANA instance to my Eclipse System tab and this time it went through successfully without error.  But now I'm getting a connection error when trying to connect to the HANA instance.  It connected through successfully the first time and displayed the Administration console information, but then immediately dropped the connection and now having difficulty connecting back.  And now when I try to connect back up it either hangs or I just got the dialog message:

Ports [30115] required by system 'sxxxxxxxxxxtrial-hihanaxs (DEV_*') are currently in use.  Close all processes and programs that use these ports and then retry the operation.  Going to check the HCP cockpit on this HANA instance.

I wonder if there are some issues going on with HCP at this point or if there is something about my setup?  As a side note, I'm able to connect successfully to separate AWS HANA One instances that we have running without issue from the Eclipse System panel.

Joe

[former_member198220]

Hi Joe,

have you restarted Eclipse? If you connect to a cloud system the IDE is actually open a tunnel connection in the background, basically it opens a port on your local machine that's connected to the database running in HCP.

If the problem persists you can open the Terminal.app and use

sudo lsof -i :30015

to find out which process blocks the local port.

Best regards,

Marc

[Former Member]

Hi Marc, thanks for your response.  I restarted Eclipse after doing the software update described below by Robert.  Thanks Robert for the update suggestion.

I updated my Eclipse via Help->Check Updates and now it looks like the HANA instance is available at this point.  However, when double clicking on the instance to get the Administration console, I'm now getting the following error message:

Error while opening the Administration editor

Reason: Cannot open the Administration editor; you do not have the required privilege

The first time I tried, I was able to get the Administration console in Eclipse, but then my connection dropped.  Are you able to view the Administrative Console/editor on HCP via Eclipse?  Should I be able to access this or was it just an anomaly that I could briefly with HCP?

I tried looking locally to see if anything was listening on port 30015 locally via netstat and lsof and did not see anything.  The HCP HANA connection seems to be intermittent overall, but stabilized at this point.

Thanks.

Joe

[former_member198220]

Hi Joe,

I meant restart after the first connection failed. My suspicion was that the tunnel wasn't closed and thus blocked your second connection attempt.

The HANA "Trial instances" on the Trial landscapes are essentially just shared schemas on some database server, so you should not be able to view the administration editor - that would give you too much power over the server. Maybe different versions of the HANA tools behave differently (showing you the editor without being able to do something vs. not showing you the editor in the first place?). I can't give you an authoritative answer on that, though.

Best regards,

Marc    

[Former Member]

Hi Marc,

I've restarted Eclipse multiple times at this point, so hopefully that cleared it up.  The connection seems to be working at this point, but was shaky initially for whatever reason.

And was odd that I initially got to see the Administration console, but it isn't available now.  Maybe it was a timing thing with the instance being provisioned.  Was just hoping to see if I should be able to see it or not.  But I guess it might make sense that it is restricted in a shared environment like HCP.

Thanks again for all your assistance with this.  Take care.

Joe

[ChristianGünter]

Hi,

i have the same problem. Are there any news to this?

Regards, Christian

[tiago_queiroga]

I am getting the same error.

Is Hana cloud platform service on?

[bernd_hofmann]

I have forwarded this problem to the development teams. They are working on it now. Will update this thread with the outcome.

-Bernd

[alexander_silgidjian]

Hi Filipe,

Is there any chance that you hit yesterday downtime?

Is the problem still reproducible?

Kind Regards,

Alex

[former_member78643]

Hi Alex,

I just tried now and got same error to connect.

Step below works.

But when I click on finish below:

I get the error:

Thanks,

Felipe

[alexander_silgidjian]

Hi Filipe,

How did you create your HANA instance?

I tried to create one like yours in the Account page and it did not let me to. Only alphanumeric values are allowed starting with letter.

Would you try to drop this instance and create a new one via the Account page, after that repeat the add cloud system wizard?

Regards,

Alex

[former_member78643]

Hi Alex,

I am following the exercise instruction in the course SAP HANA Cloud Platform, week 2, units 1 and 2, delivered by Rui Nogueira. That instance was create automatically when a created a new server in the cloud with application name "opensapw2u1". Instance name is formated with my "accountname.applicationname.web".

Best regards,

Felipe Lemos

[Former Member]

Hi, I have encountered the same problem. Is there any solutions to this issue so far?