Skip to Content
Author's profile photo Vladimir Pavlov

Connecting to #SAP #HANA Instances on #SAPHCP from #Eclipse IDE

I seem to be in a blogging mood recently. 😉 Unfortunately, I missed the chance to give a shout about a cool new feature which was released couple of weeks ago (on March 13, precisely speaking) but apparently has left unnoticed by many folks and friends of SAP HANA Cloud Platform. So – and as a wise man had once said – I thought “better late than never” and decided to try and fix this lapse.

What am I talking about? Well, until March 13, if you wanted to connect to an SAP HANA instance on SAP HCP, you had to open a DB tunnel in the Console Client by executing the open-db-tunnel command, copy the connection details it returned to you (including the instance number, DB user and password), go to your HANA Studio (and yes, it had to be a separate standalone IDE from your other Eclipse IDE which you were using for Java development on HCP and/or any other development you do!) and paste those connection details into the corresponding wizard pages. Oh, and did I mention that you had to keep the DB tunnel in the Console Client open while you were working on the remote HANA instance? Sounds fun? Guess not.

Well, forget about the above. We’ve put an end to all those tedious, awkward and error-prone steps within so many different tools. Now you can do everything in a single tool (Eclipse IDE) with just a couple of clicks. The prerequisite is that you have installed an Eclipse Kepler IDE and the SAP HANA Cloud Platform Tools on top, as described in Setting Up the Tools. (And yes, you got it right – all necessary SAP HANA Tools now can be installed as well from the SAP Development Tools for Eclipse – Kepler Software Repository, so you don’t need a separate HANA Studio installation any longer.)

Now, if you already have a trial or productive SAP HANA instance in your account (see e.g. Creating a Trial SAP HANA Instance), you can just go to the SAP HANA Development perspective in your Eclipse IDE, right click in the Systems view and select Add Cloud System… which should open up this nice wizard:

/wp-content/uploads/2014/04/add_cloud_system_424317.png

Enter your account info and click Next. This will lead you to the second page where you have to select an instance from the list:

/wp-content/uploads/2014/04/add_cloud_system_2_424318.png

Click Finish and in a few seconds it will be added in the Systems view. If you are working with a productive instance, you also need to provide your own DB user and password. See in the official documentation how to create it. In this case, as a last step the wizard might ask you to change your DB password if it is an initial one and you haven’t changed it yet.

That’s it! Now you can go on and import some sample apps, play with them, or develop your own XS app – it’s up to you. Enjoy! And don’t hesitate to share your feedback and comments – we are always looking for further improvements and simplifications. 🙂

Assigned tags

      53 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Wolfgang Weinmann
      Wolfgang Weinmann

      Hi Pavlov,

      thanks very, very much for sharing that! I got a HCP instance and I already installed the Eclipse - Kepler - Addon in my HANA Studio and get the option "Add Cloud System".

      This all looks very great.

      But unfortunately I have no idea, where the password for the access is derived from. I tried all my "standard" passwords, but nothing worked. And obviously there is no option to reset the password.

      So the big question is: where can I reset the password? Or from which system is the password derived? Since 2 days I have a ticket open and this ticket goes like a ball in a ping-pong-match.....

      Thanks a lot in advance

      Wolfgang

      Author's profile photo Former Member
      Former Member

      Hello Wolfgang,

      from your post I can consider that you have a productive HANA instance.

      You need to create DB user that you can use to connect from Eclipse based HANA tools.

      More details how you can create and manage DB users for productive HANA instance operated on SAP Hana Cloud Platform, please see the following section inside documentation: SAP HANA Cloud Platform

      Best regards,

      Dobri

      Author's profile photo Wolfgang Weinmann
      Wolfgang Weinmann

      yes, sorry, I got it in the meantime!

      thanks a lot!

      Author's profile photo Vladimir Pavlov
      Vladimir Pavlov
      Blog Post Author

      Hi,

      @Dobri: thanks for stepping in and helping Wolfgang at such a record-breaking response time! 🙂

      @Wolfgang: thanks for the kind words! (please feel free to also rate and/or like it using the buttons at the top right and below the post 😉 )

      btw, it's actually mentioned in the last paragraph:

      If you are working with a productive instance, you also need to provide your own DB user and password. See in the official documentation how to create it.

      I'm really sorry that you had to wait for two days to have your ticket resolved (perhaps it got into the wrong queue?) - as you can see, it's a piece of cake.

      Cheers,

      --Vlado

      Author's profile photo Wolfgang Weinmann
      Wolfgang Weinmann

      🙂

      Author's profile photo Former Member
      Former Member

      Just a small side note from my end: I had to install the "SAP HANA Cloud Platform Tools" from the "SAP Development Tools for Eclipse Kepler - https://tools.hana.ondemand.com/kepler"-package to get the "Add Cloud System"-option

      Searching for "standard Kepler" wasn't enough.

      Author's profile photo Vladimir Pavlov
      Vladimir Pavlov
      Blog Post Author

      Yes, that's what described above:

      The prerequisite is that you have installed an Eclipse Kepler IDE and the SAP HANA Cloud Platform Tools on top, as described in Setting Up the Tools.

      What do you mean by "standard Kepler-Addon"?

      Author's profile photo Former Member
      Former Member

      "Eclipse Kepler IDE" as description was just not precise enough for me, "SAP Development Tools for Eclipse Kepler" is what is needed to find the Addon without searching too long and I just wanted to point also directly to the addon URL https://tools.hana.ondemand.com/kepler

      With "standard Kepler" I ment the IDE release version which itself is called "Kepler": http://download.eclipse.org/releases/kepler

      Author's profile photo Muhammad Muaz Qazi
      Muhammad Muaz Qazi

      I am following the same steps mentioned above but not successful.

      Message is: JN5 localhost00 - System state cannot be determined

      What is wrong I don't understand ?

      Author's profile photo Vladimir Pavlov
      Vladimir Pavlov
      Blog Post Author

      You can ignore that message - it does not have functional impact.

      Author's profile photo Former Member
      Former Member

      In the "Add SAP HANA cloud Platform system' I specified

      Landscape host = hanatrial.ondemand.com

      Account name

      User name

      Password

      I get the following error: The information about trial and productive SAP HANA instances cannot be fetched from SAP HANA Cloud Platform. Check the error log for more information.

      1. What am I doing wrong?

      2. Where is the error log please?

      Thanks.

      Soyab

      Author's profile photo Former Member
      Former Member

      Problem resolved by logging off and restarting Eclipse.

      Author's profile photo Former Member
      Former Member

      Thank you, very helpful

      You have an idea of why we might have a Insuffisant Privelege message on the content folder, while the only access existing is the one I created with the session, DB & schema?

      31-07-2014 3-34-36 PM.png

      Same for Repositary View

      31-07-2014 3-38-13 PM.png

      If you met the same issue, I will be pleased to read your solution

      Thanks

      Author's profile photo Former Member
      Former Member

      Hello Lilya,

      you need following permissions added to your user:

      HCP_PUBLIC

      HCP_SYSTEM

      Probably you miss the step 2 from importing sample scenario - details here.

      Enjoy,

      Dobri

      Author's profile photo Former Member
      Former Member

      Hi,

      Thaks a lot but the sample scenario seems to apply only on HCP XS, doesn't it?

      Author's profile photo Vladimir Pavlov
      Vladimir Pavlov
      Blog Post Author

      Could it be that it's a HANA instance (just DB) and not HANA XS? Please check in your Cockpit.

      Author's profile photo Former Member
      Former Member

      Hi, It is a HANA instance (just DB) yes, but I'm able to see the and create tables

      Author's profile photo Former Member
      Former Member

      Hi ,

      I am getting below error while adding could system 'hanatrail.ondemand.com'

      "Could not populate schemas UI."

      pls help me to fix this.

      Exception stack trace:

      java.lang.reflect.InvocationTargetException

      at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:421)

      at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:1028)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage.fetchSchemasAndDbs(CloudSystemConnectionSchemasWizardPage.java:243)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionWizard.nextPressed(CloudSystemConnectionWizard.java:174)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionHandler$1.nextPressed(CloudSystemConnectionHandler.java:26)

      at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:428)

      at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:628)

      at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)

      .................................................

      Thanks!!

      Author's profile photo Former Member
      Former Member

      Hello Naresh,

      can you please post the whole stack trace. The real reason is not included inside this fragment.

      The problem can be:

      - proxy settings are wrong and landscape cannot be reach and validated

      - landscape name is misspelled

      - wrong user or password

      - wrong account name

      - or something else ...

      Also, please be sure that you use the latest version of the plugin.

      Best,

      Dobri

      Author's profile photo Former Member
      Former Member

      Hi Dobromir,

      Here is complete trace:

      java.lang.reflect.InvocationTargetException

      at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:421)

      at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:1028)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage.fetchSchemasAndDbs(CloudSystemConnectionSchemasWizardPage.java:243)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionWizard.nextPressed(CloudSystemConnectionWizard.java:174)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionHandler$1.nextPressed(CloudSystemConnectionHandler.java:26)

      at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:428)

      at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:628)

      at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)

      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)

      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4170)

      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)

      at org.eclipse.jface.window.Window.runEventLoop(Window.java:826)

      at org.eclipse.jface.window.Window.open(Window.java:802)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionHandler.execute(CloudSystemConnectionHandler.java:31)

      at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:290)

      at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      at java.lang.reflect.Method.invoke(Unknown Source)

      at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)

      at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:243)

      at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:224)

      at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)

      at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:167)

      at org.eclipse.core.commands.Command.executeWithChecks(Command.java:499)

      at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)

      at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:213)

      at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.executeItem(HandledContributionItem.java:850)

      at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.handleWidgetSelection(HandledContributionItem.java:743)

      at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.access$7(HandledContributionItem.java:727)

      at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem$4.handleEvent(HandledContributionItem.java:662)

      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)

      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4170)

      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)

      at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)

      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

      at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)

      at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:140)

      at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:611)

      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

      at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)

      at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)

      at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)

      at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)

      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      at java.lang.reflect.Method.invoke(Unknown Source)

      at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)

      at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)

      at org.eclipse.equinox.launcher.Main.run(Main.java:1450)

      at org.eclipse.equinox.launcher.Main.main(Main.java:1426)

      Caused by: java.lang.NullPointerException

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage$5.run(CloudSystemConnectionSchemasWizardPage.java:255)

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

      Thanks!!

      Author's profile photo Former Member
      Former Member

      The problem here is wrong proxy settings!

      Just check your proxy configuration and restart Eclipse, when you adjust them.

      The message was not good enough and in version 1.15.0 we manage to give proper error message to the user in such cases.

      1.15.0 version will be available for download in 1 week, but as I alredy say - you can continue by adjusting the proxy settings.

      Best,

      Dobri

      Author's profile photo Former Member
      Former Member

      Hi Dobromir,

      Thanks a lot for your reply.

      I changed Network connection->active provider -> Direct. ( i connect internet directly)

      but i get  new trace log now,

      seems like user authentication error.

      am using same credentials used for cockpit ->SAP HANA Cloud Platform

      followed steps:

      Below is complete error trace:

      Am i missing any?

      java.lang.reflect.InvocationTargetException

      at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:421)

      at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:1028)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage.fetchSchemasAndDbs(CloudSystemConnectionSchemasWizardPage.java:243)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionWizard.nextPressed(CloudSystemConnectionWizard.java:174)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionHandler$1.nextPressed(CloudSystemConnectionHandler.java:26)

      at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:428)

      at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:628)

      at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)

      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)

      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4170)

      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)

      at org.eclipse.jface.window.Window.runEventLoop(Window.java:826)

      at org.eclipse.jface.window.Window.open(Window.java:802)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionHandler.execute(CloudSystemConnectionHandler.java:31)

      at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:290)

      at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      at java.lang.reflect.Method.invoke(Unknown Source)

      at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)

      at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:243)

      at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:224)

      at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)

      at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:167)

      at org.eclipse.core.commands.Command.executeWithChecks(Command.java:499)

      at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)

      at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:213)

      at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.executeItem(HandledContributionItem.java:850)

      at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.handleWidgetSelection(HandledContributionItem.java:743)

      at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.access$7(HandledContributionItem.java:727)

      at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem$4.handleEvent(HandledContributionItem.java:662)

      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)

      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4170)

      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)

      at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)

      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

      at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)

      at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:140)

      at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:611)

      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

      at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)

      at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)

      at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)

      at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)

      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      at java.lang.reflect.Method.invoke(Unknown Source)

      at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)

      at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)

      at org.eclipse.equinox.launcher.Main.run(Main.java:1450)

      at org.eclipse.equinox.launcher.Main.main(Main.java:1426)

      Caused by: java.lang.RuntimeException: Connection to host 'https://hanatrial.ondemand.com' failed.

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage$5.run(CloudSystemConnectionSchemasWizardPage.java:271)

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

      Caused by: com.sap.jpaas.infrastructure.console.exception.CommandException: Authorization error - the execution was rejected.

      User P354005 is not authorized.

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

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

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

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

      at com.sap.core.persistence.commands.schema.ListSchemaConsumer.consume(ListSchemaConsumer.java:37)

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

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

      at com.sap.core.persistence.commands.schema.api.ListSchemaAndDbmsHandler.listSchemas(ListSchemaAndDbmsHandler.java:134)

      at com.sap.core.persistence.commands.schema.api.ListSchemaAndDbmsHandler.listSharedSchemas(ListSchemaAndDbmsHandler.java:94)

      at com.sap.core.persistence.commands.schema.api.ListSchemaAndDbmsHandler.listSharedSchemasAndDedicatedDbms(ListSchemaAndDbmsHandler.java:86)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemHelper.fetchDb(CloudSystemHelper.java:200)

      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage$5.run(CloudSystemConnectionSchemasWizardPage.java:249)

      ... 1 more

      Thanks!!

      Author's profile photo Former Member
      Former Member

      Yes, the error is:

      ...

      User P354005 is not authorized.

      ...

      Double check your credentials.

      Author's profile photo zongjie zhang
      zongjie zhang

      Dear Dobromir,

            I am facing this problem too, can you tell me how to configure the proxy setting ?

      Author's profile photo Former Member
      Former Member

      The issue with Naresh was wrong credential.

      If this is your case - then you should check your credentials.

      If this is not your case - please open a new thread and post your log file inside.

      Best Regards,

      Dobri

      Author's profile photo zongjie zhang
      zongjie zhang

      Thanks for your time!

      I think I find my problem in my log:

      the execution was rejected.User 'P1680829412' does not have permission'readDbInformation' in account 'kevin'

      but I just don't know how to correct it.

      my log is:

      java.lang.reflect.InvocationTargetException

        at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:423)

        at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:1059)

        at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage.fetchSchemasAndDbs(CloudSystemConnectionSchemasWizardPage.java:254)

        at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionWizard.nextPressed(CloudSystemConnectionWizard.java:197)

        at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionHandler$1.nextPressed(CloudSystemConnectionHandler.java:26)

        at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:434)

        at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:619)

        at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)

        at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

        at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)

        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)

        at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4172)

        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761)

        at org.eclipse.jface.window.Window.runEventLoop(Window.java:832)

        at org.eclipse.jface.window.Window.open(Window.java:808)

        at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionHandler.execute(CloudSystemConnectionHandler.java:31)

        at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:294)

        at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)

        at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:55)

        at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:247)

        at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:229)

        at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)

        at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:149)

        at org.eclipse.core.commands.Command.executeWithChecks(Command.java:499)

        at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)

        at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:210)

        at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.executeItem(HandledContributionItem.java:825)

        at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.handleWidgetSelection(HandledContributionItem.java:701)

        at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.access$6(HandledContributionItem.java:685)

        at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem$4.handleEvent(HandledContributionItem.java:613)

        at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

        at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)

        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)

        at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4172)

        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761)

        at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)

        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

        at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)

        at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)

        at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)

        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

        at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)

        at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)

        at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:135)

        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)

        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)

        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)

        at org.eclipse.equinox.launcher.Main.run(Main.java:1465)

      Caused by: java.lang.RuntimeException: Connection to host 'hanatrial.ondemand.com' failed.

        at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage$5.run(CloudSystemConnectionSchemasWizardPage.java:292)

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

      Caused by: com.sap.jpaas.infrastructure.console.exception.CommandException: Authorization error - the execution was rejected.

      User 'P1680829412' does not have permission 'readDbInformation' in account 'kevin'

        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.schema.ListSchemaConsumer.consume(ListSchemaConsumer.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.schema.api.ListSchemaAndDbmsHandler.listSchemas(ListSchemaAndDbmsHandler.java:134)

        at com.sap.core.persistence.commands.schema.api.ListSchemaAndDbmsHandler.listSharedSchemas(ListSchemaAndDbmsHandler.java:94)

        at com.sap.core.persistence.commands.schema.api.ListAllTunnelEndpointsHandler.listAllTunnelEndpoints(ListAllTunnelEndpointsHandler.java:44)

        at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemHelper.fetchDb(CloudSystemHelper.java:219)

        at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage$5.run(CloudSystemConnectionSchemasWizardPage.java:260)

        ... 1 more

      Author's profile photo Alexander Silgidjian
      Alexander Silgidjian

      Hi Zhang,

      Your account is most probably P1680829412trial


      Kind Regards,

      Alex

      Author's profile photo zongjie zhang
      zongjie zhang

      Thank you so much, I make a terrible mistake, just as you said my account is P1680829412trial, and I confuse my account and user name.

      Author's profile photo Niranjan Raju
      Niranjan Raju

      Hi Vladimir,

      Thanks for the blog. Very helpful. I have 3 productive instances. I am able to add 2 of them to the studio through the Add Cloud System plugin. But for the 3rd one, I get the error "The information about Trial and Productive SAP HANA instances could not be fetched from HANA Cloud Platform".

      I have tried logging off, clearing the saved passwords etc. But the error repeats. I have set the Network mode of as Manual and also set the Proxy server. Am I missing something here?

      Thanks,

      Niranjan

      Author's profile photo Niranjan Raju
      Niranjan Raju

      BTW: I just checked the error log and found this error:

      User <MyUserID> does not have permission 'readDbInformation' in account <MyAccount>

      I checked the cockpit and I am added as a member and Admin of the account. Do I need to add something more here to enable me to connect?

      Thanks,

      Niranjan

      Author's profile photo Vladimir Pavlov
      Vladimir Pavlov
      Blog Post Author

      Please double check that you have specified the correct landscape host, account and user name.

      Author's profile photo Niranjan Raju
      Niranjan Raju

      Thanks. I was supposed to use a "GUID" that was associated with my account and not the account name (which was different). Got it working.

      Thanks,

      Niranjan

      Author's profile photo Christian Key
      Christian Key

      Hi,

      I wish to load data into my HANA Cloud trial database using Data Services. Where do I find the HANA database servername so I can set up my connection to SAP HANA Cloud?

      Thanks,

      Christian

      Author's profile photo Vladimir Pavlov
      Vladimir Pavlov
      Blog Post Author

      If you need to connect with other tools (not Eclipse based), you can use the open-db-tunnel command.

      Author's profile photo Former Member
      Former Member

      In the "Add cloud Platform system' I specified

      Landscape host = hanatrial.ondemand.com

      Account name

      User name trial

      Password

      I get the following error: The information about trial and productive SAP HANA instances cannot be fetched from SAP HANA Cloud Platform.

      I tried logout from cockpit, restart kepler, and also have checked with network settings still the problem persists.

      Could you please let me where am i going wrong!!

      Thanks.

      Author's profile photo Former Member
      Former Member

      Hi Asma,

      check the .log file for the reason.

      if you can upload file here I can check it.

      regards,

      Dobri

      Author's profile photo Parminder Khabra
      Parminder Khabra

      you get this error message in "Add Cloud System" when you accidentally set the "Landscape Host" to "hana.ondemand.com" instead of "hanatrial.ondemand.com".

      Try Changing it will work

      Author's profile photo Nagarjun K
      Nagarjun K

      Hi..

           1) Is it possible to connect simple java application(running in remote machine) to SAP HANA Database(both on-permises & cloud)?. (just like connecting java application with other database like MSSQL & MySQL..)

           2) if above scenario is possible, connecting to SAP HANA Database on-permise and connecting to SAP HANA Database on cloud is same?

      Any information regarding the above queries might be useful for me. Please share. 

      Thanks & Regards,

      Nagarjun

      Author's profile photo Former Member
      Former Member

      i could not add trial instance..can any one help with this../wp-content/uploads/2015/02/1_654699.png/wp-content/uploads/2015/02/2_654700.png

      Author's profile photo Alexander Silgidjian
      Alexander Silgidjian

      Hi Amala,

      Is the problem persistent?

      Is it possible that you hit the downtime on 25th of February [1]?

      Would you check your network setting also?

      Regards,

      Alex

      SAP HANA Cloud Platform Trial update announcements

      Author's profile photo Former Member
      Former Member

      Hi Alexander,

      Yes still am having that issue 😕 ..network setting - Active provider - native...

      Any help would be much appreciated.

      Regards,

      Amala

      Author's profile photo Karthik M L
      Karthik M L

      Hi Amala,

      Update  Eclipse Platform (-> Help -> Check for Updates).

      It worked for me.


      Regards,

      Karthik M L

      Author's profile photo Former Member
      Former Member

      Hi Team,

      I had issue in connecting Hana cloud platform from eclipse. Please refer screenshot :

      I figured it out the issue is due to DB tunneling. Tried with the console using commands. But facing issue in connecting 

      Please go through the error generated by console:

      Log.jpg

      Hanacloud.jpg

      Hana.jpg

      Author's profile photo Former Member
      Former Member

      The issue is resolved without any actions from my-side. I hope there might be some updates taken place.

      Author's profile photo Former Member
      Former Member

      To things resolved this issue for me:

      • Remember to put hanatrial.ondemand.com instread of hana.ondemand.com as landscape host.
      • Run eclipse as administrator
      Author's profile photo Srinivasa Rao Janagama
      Srinivasa Rao Janagama

      Landscape host: hanatrial.ondemand.com (Not hana.ondemand.com as it appear default)

      Account Name: Sxxxxxxxtrial

      User Name: Sxxxxxxx

      Password: xxxxxx

      It should work for sure

      Author's profile photo Chandrababu Katta
      Chandrababu Katta

      HI,

      Good blog and helpful information!

      But here we are getting a problem while we are trying to connect our Ondemand.hana instance through elipse, the message is as follows " "Could not connect to the SAP HANA Cloud Platform system, Check the error log for more details"

      Its worked us for few days and then suddenly showing this error message.

      I checked for N/W settings changed all types "Direct, manual and Native" but not worked and checked for updates of eclipse - its also not worked .

      The same problem for HANA Studio also.

      Can you please help me to fix the issue asap!

      Our HANA Ondemand host is "us1.hana.ondemand.com"

      1.PNG

      Thanks,

      Chandrababu Katta

      Author's profile photo Former Member
      Former Member

      I get the same message dialog and had a look in the error log:

      java.util.concurrent.ExecutionException: com.sap.jpaas.infrastructure.console.exception.CommandException: Failed to find valid local port mapping

        at java.util.concurrent.FutureTask.report(FutureTask.java:122)

        at java.util.concurrent.FutureTask.get(FutureTask.java:188)

        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: Failed to find valid local port mapping

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

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

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

        at java.lang.Thread.run(Thread.java:745)

      Caused by: java.io.IOException: Failed to find free local ports

        at com.sap.core.persistence.commands.tunnel.connection.HanaSpecificHelper.remapIfRequired(HanaSpecificHelper.java:105)

        at com.sap.core.persistence.commands.tunnel.connection.DBSpecificHelper.getLocalMappings(DBSpecificHelper.java:35)

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

        ... 9 more

      Author's profile photo Simone Caneparo
      Simone Caneparo

      You probably need to update the hana sdk and the ui tools

      Author's profile photo Toine Pothuizen
      Toine Pothuizen

      Hi,

      unfortunately I cannot select a hana schema from the HCP.

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

      I logged in with s00...trial. It showed my schema's but after selection, the error appears.

      I have updated all Eclipse software content (22 Oct 2015).

      Any idea how to solve this?

      Best regards, Toine.

      Error Log:

      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

      ...

      Author's profile photo Former Member
      Former Member

      Hi,

      Now I'm working on HCP trial account and uploading some CSV data via your HCP Tool for Eclipse.

      Though I could upload local CSV files(actually a set of files exported from cloud that I modified) via 'Import..' context menu on 'Systems' view, but it takes a lot of time to upload some millions of data records... you know.

      But I found options of 'Import catalog objects on server' and 'Import catalog objects from current client'.CSV_IMPORT.png

      How could I utilize this option?

      Is there any way to upload files to the server (like FTP or else) before start loading to DB?

      OR any advise for faster data setup are welcome.

      Thanks in advance.

      Author's profile photo Former Member
      Former Member

      Hi, I get this error when I am trying to Add cloud system. Thanks in advance

      Capture.PNG

      This is from log

      !ENTRY com.sap.cloud.tools.eclipse.hana.tunnel 4 0 2016-02-17 17:34:56.581

      !MESSAGE Could not populate schemas UI.

      !STACK 0

      java.lang.RuntimeException: Connection to host 'hanatrial.ondemand.com' failed.

        at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionWizard.nextPressed(CloudSystemConnectionWizard.java:194)

        at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionHandler$1.nextPressed(CloudSystemConnectionHandler.java:26)

        at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:425)

        at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:619)

        at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)

        at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

        at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4362)

        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1113)

        at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4180)

        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3769)

        at org.eclipse.jface.window.Window.runEventLoop(Window.java:827)

        at org.eclipse.jface.window.Window.open(Window.java:803)

        at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionHandler.execute(CloudSystemConnectionHandler.java:31)

        at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:295)

        at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)

        at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:252)

        at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:234)

        at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)

        at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:152)

        at org.eclipse.core.commands.Command.executeWithChecks(Command.java:493)

        at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:486)

        at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:210)

        at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.executeItem(HandledContributionItem.java:799)

        at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.handleWidgetSelection(HandledContributionItem.java:675)

        at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.access$7(HandledContributionItem.java:659)

        at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem$4.handleEvent(HandledContributionItem.java:592)

        at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

        at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4362)

        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1113)

        at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4180)

        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3769)

        at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1127)

        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)

        at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1018)

        at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:156)

        at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:654)

        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)

        at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:598)

        at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)

        at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:139)

        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)

        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:669)

        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:608)

        at org.eclipse.equinox.launcher.Main.run(Main.java:1515)

      Caused by: javax.net.ssl.SSLException: hostname in certificate didn't match: <hanatrial.ondemand.com> != <*.hanatrial.ondemand.com> OR <*.hanatrial.ondemand.com>

        at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:238)

        at org.apache.http.conn.ssl.BrowserCompatHostnameVerifier.verify(BrowserCompatHostnameVerifier.java:54)

        at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:159)

        at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:140)

        at org.apache.http.conn.ssl.SSLSocketFactory.verifyHostname(SSLSocketFactory.java:561)

        at org.apache.http.conn.ssl.SSLSocketFactory.connectSocket(SSLSocketFactory.java:536)

        at org.apache.http.conn.ssl.SSLSocketFactory.connectSocket(SSLSocketFactory.java:403)

        at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:177)

        at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:144)

        at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:131)

        at org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:611)

        at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:446)

        at org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:863)

        at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:115)

        at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:57)

        at com.sap.core.utils.infrastructure.validation.LandscapeHostValidator.getHttpClient(LandscapeHostValidator.java:298)

        at com.sap.core.utils.infrastructure.validation.LandscapeHostValidator.getHttpClient(LandscapeHostValidator.java:247)

        at com.sap.core.utils.infrastructure.validation.LandscapeHostValidator.checkConnectionToLandscapeHost(LandscapeHostValidator.java:187)

        at com.sap.core.utils.infrastructure.validation.LandscapeHostValidator.isLandscapeHostValid(LandscapeHostValidator.java:563)

        at com.sap.core.utils.infrastructure.validation.LandscapeHostValidator.isLandscapeHostValid(LandscapeHostValidator.java:525)

        at com.sap.core.utils.infrastructure.validation.LandscapeHostValidator.isLandscapeHostValid(LandscapeHostValidator.java:510)

        at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionWizard.nextPressed(CloudSystemConnectionWizard.java:190)

        ... 56 more

      Author's profile photo Sagar Dhawan
      Sagar Dhawan

      Getting Error while adding Cloud System. Any Help?

       

       

      !ENTRY com.sap.cloud.tools.eclipse.hana.tunnel 4 0 2020-07-29 13:28:12.563
      !MESSAGE Could not populate schemas UI.
      !STACK 0
      java.lang.reflect.InvocationTargetException
      at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:397)
      at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:1034)
      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage.fetchSchemasAndDbs(CloudSystemConnectionSchemasWizardPage.java:261)
      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionWizard.nextPressed(CloudSystemConnectionWizard.java:197)
      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionHandler$1.nextPressed(CloudSystemConnectionHandler.java:26)
      at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:468)
      at org.eclipse.jface.dialogs.Dialog.lambda$0(Dialog.java:619)
      at org.eclipse.jface.dialogs.Dialog$$Lambda$197/0000000000000000.accept(Unknown Source)
      at org.eclipse.swt.events.SelectionListener$1.widgetSelected(SelectionListener.java:84)
      at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:252)
      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
      at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4175)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3988)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3587)
      at org.eclipse.jface.window.Window.runEventLoop(Window.java:823)
      at org.eclipse.jface.window.Window.open(Window.java:799)
      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionHandler.execute(CloudSystemConnectionHandler.java:31)
      at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:283)
      at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:97)
      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.base/java.lang.reflect.Method.invoke(Method.java:567)
      at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:58)
      at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:318)
      at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:252)
      at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:173)
      at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:156)
      at org.eclipse.core.commands.Command.executeWithChecks(Command.java:488)
      at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:487)
      at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:213)
      at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.executeItem(HandledContributionItem.java:438)
      at org.eclipse.e4.ui.workbench.renderers.swt.AbstractContributionItem.handleWidgetSelection(AbstractContributionItem.java:449)
      at org.eclipse.e4.ui.workbench.renderers.swt.AbstractContributionItem.lambda$2(AbstractContributionItem.java:475)
      at org.eclipse.e4.ui.workbench.renderers.swt.AbstractContributionItem$$Lambda$383/0000000000000000.handleEvent(Unknown Source)
      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
      at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4175)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3988)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3587)
      at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1160)
      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
      at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1049)
      at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)
      at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:660)
      at org.eclipse.ui.internal.Workbench$$Lambda$205/0000000000000000.run(Unknown Source)
      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
      at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:559)
      at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:154)
      at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:150)
      at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)
      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:137)
      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:107)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:401)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)
      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.base/java.lang.reflect.Method.invoke(Method.java:567)
      at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:657)
      at org.eclipse.equinox.launcher.Main.basicRun(Main.java:594)
      at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
      Caused by: java.lang.RuntimeException: Connection to host 'hanatrial.ondemand.com' failed.
      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage$5.run(CloudSystemConnectionSchemasWizardPage.java:304)
      at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
      Caused by: com.sap.jpaas.infrastructure.console.exception.CommandException: An unexpected internal problem occurred.
      at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.throwCommandExceptionWithContentInfoAndLog(DefaultResponseConsumingStrategy.java:90)
      at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.throwCommandExceptionWithContentInfoAndLog(DefaultResponseConsumingStrategy.java:54)
      at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.throwCommandExceptionWithContentInfoAndLog(DefaultResponseConsumingStrategy.java:49)
      at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.consume(DefaultResponseConsumingStrategy.java:43)
      at com.sap.core.tunnelcommands.framework.executor.JsonConsumingStrategy.consume(JsonConsumingStrategy.java:31)
      at com.sap.core.persistence.commands.schema.ListSchemaConsumer.consume(ListSchemaConsumer.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.schema.api.ListSchemaAndDbmsHandler.listSchemas(ListSchemaAndDbmsHandler.java:134)
      at com.sap.core.persistence.commands.schema.api.ListSchemaAndDbmsHandler.listSharedSchemas(ListSchemaAndDbmsHandler.java:94)
      at com.sap.core.persistence.commands.schema.api.ListAllTunnelEndpointsHandler.listAllTunnelEndpoints(ListAllTunnelEndpointsHandler.java:44)
      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemHelper.fetchDb(CloudSystemHelper.java:219)
      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage$5.run(CloudSystemConnectionSchemasWizardPage.java:267)
      ... 1 more
      Root exception:
      java.lang.RuntimeException: Connection to host 'hanatrial.ondemand.com' failed.
      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage$5.run(CloudSystemConnectionSchemasWizardPage.java:304)
      at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
      Caused by: com.sap.jpaas.infrastructure.console.exception.CommandException: An unexpected internal problem occurred.
      at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.throwCommandExceptionWithContentInfoAndLog(DefaultResponseConsumingStrategy.java:90)
      at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.throwCommandExceptionWithContentInfoAndLog(DefaultResponseConsumingStrategy.java:54)
      at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.throwCommandExceptionWithContentInfoAndLog(DefaultResponseConsumingStrategy.java:49)
      at com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy.consume(DefaultResponseConsumingStrategy.java:43)
      at com.sap.core.tunnelcommands.framework.executor.JsonConsumingStrategy.consume(JsonConsumingStrategy.java:31)
      at com.sap.core.persistence.commands.schema.ListSchemaConsumer.consume(ListSchemaConsumer.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.schema.api.ListSchemaAndDbmsHandler.listSchemas(ListSchemaAndDbmsHandler.java:134)
      at com.sap.core.persistence.commands.schema.api.ListSchemaAndDbmsHandler.listSharedSchemas(ListSchemaAndDbmsHandler.java:94)
      at com.sap.core.persistence.commands.schema.api.ListAllTunnelEndpointsHandler.listAllTunnelEndpoints(ListAllTunnelEndpointsHandler.java:44)
      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemHelper.fetchDb(CloudSystemHelper.java:219)
      at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage$5.run(CloudSystemConnectionSchemasWizardPage.java:267)
      ... 1 more