Not able to add Cloud system from Eclipse (SAP HANA Development ) also have to get Raspberry Pi data in to IoT table and get these table into HANA Schema and

[ashutosh_shrivastava4]

Hi All,

I am adding HANA cloud system and getting error. I am performing below steps--

1> Open Eclipse.Go to Window-->perspective-->open perspective-->select SAP HANA Development--> Right click and Add cloud system--> Fill Account name followed by trail and user name and password.

Getting Error-- Authorization Error-- the execution was rejected.

i repeated the same steps with other perspectives as well -- "SAP HANA Administration  console" and "SAP HANA modeler", but getting same error each time. attaching error screenshot

Second question-  I have created Schema- HANA (<share>) and Database HANA MDC (<Trail>) in SAP HCP cockpit. please suggest how to get IoT tables data in to Schema/ Database in order to report unstructured data.

Project Aim is getting Raspberry Pi data in to IoT table and get these table into HANA Schema and further do reporting on unstructured data..

Any idea , is this Aim achievable ?

Thanks in advance..

Thanks,

Ashutosh

[Murali_Shanmu · Accepted solution]

Hi Ashutosh,

Once HANA MDC is created,  were you able to login into Web development Workbench / HANA Cockpit ?

With regard to using IoT Tables, please have a look at this article. I have shown the process I followed.

Note: lot of the device metadata does not reside within your account. The best way to obtain this info is to use IoT OData APIs.

Cheers,

Murali

[ashutosh_shrivastava4 · Accepted solution]

Hi Mulri,

I am not able to log in with my SCN credential or HCP user (starts with p)  to Web development Workbench.

[ashutosh_shrivastava4 · Accepted solution]

Hi Murli,

could you please suggest --

which credential i need to use to open "Web development Workbench."

OR

Why i am not able to Add the cloud system ?

Both issues are related to each other ?

I am following yours suggested Blog and Rui Nogueira blog.

But since 1 week i have stuck with Adding cloud issue.

Thanks,

Ashutosh

[Murali_Shanmu · Accepted solution]

Ok, Let's start from the beginning and deal with the first question.

You have created an MDC database in your trial account providing a password for your SYSTEM user.

For now, to eliminate other possible issues, connect to HCP account using your internet connection (rather than trying to do this from your office for which you need to give a proxy).

Login to your MDC "SAP HANA Cockpit" with your SYSTEM user. You will get a message "You are not authorized to open the SAP HANA Cockpit."

Click on the "OK" button. Your SYSTEM user will be automatically assigned roles 'sap.hana.admin.roles::Administrator'.

Once you are in the cockpit, click on "Manage roles & users" tile. Select your SYSTEM user and provide additional roles. I usually assign all the available roles under "sap.hana.ide....." to the SYSTEM user.

Now try to launch "HANA Web-based Development Workbench". You should be able to access the Editor as SYSTEM user.

Once you are able to get this far, try to connect to MDC database using SYSTEM user from HANA Studio.

[ashutosh_shrivastava4 · Accepted solution]

Hi Murli, Thanks for reply.

Issue has not been yet resolved.

Login to your MDC "SAP HANA Cockpit" with your SYSTEM user. You will get a message "You are not authorized to open the SAP HANA Cockpit."

I have created one MDC database named "xyz" .

when i am clicking on SAP HANA web based development workbench. its opens a new window that asks for credentials, where i am entering my HCP cockpit user name and password, that gives error-- Logon failed, Wrong credential.

Click on the "OK" button. Your SYSTEM user will be automatically assigned roles 'sap.hana.admin.roles::Administrator'.

There is no OK button.

Once you are in the cockpit, click on "Manage roles & users" tile. Select your SYSTEM user and provide additional roles. I usually assign all the available roles under "sap.hana.ide....." to the SYSTEM user.

I am in Cockpit and i dint find anywhere "Manage roles & Users",

I found Authorization and assign "sap.hana.ide.roles" and "sap.hana.admin.roles::administrator".

also i assign these roles to iotmms as well--

but nothing worked..

On the other hand i am in Eclipse--

1> I open SAP HANA Administration console perspective--> right click under system and selecting add cloud system.

2> Filling Account name,user name and password--> next--> Getting error. (see attached)

Please suggest , how to move further..

Thanks,

Ashutosh..

[Murali_Shanmu · Accepted solution]

Hi Ashutosh,

Before clicking the link "SAP HANA web based development workbench", did you try opening the link "SAP HANA Cockpit" with the SYSTEM user and password you provided when creating the MDC Database (as mentioned in my previous response).

When you are in the Web based tool, you do not need to use your HCP account username and password. You can use your SYSTEM user or any other DB user which you create later on.

[anton_levin · Accepted solution]

Maybe a step-by-step instruction on how to use HCP IoT Services with MDC will help you. First part is how to setup MDC iot-starterkit/src/apps/xs/consumption at master · SAP/iot-starterkit · GitHub

[ashutosh_shrivastava4 · Accepted solution]

Hi Murli ,

I am getting same logon screen either I click on SAP HANA COCKPIT  or SAP HANA WEB BASED DEVELOPMENT WORKBENCH.

I am providing the exactly same password which I entered during creation of MDC.

I also tried with my SCN/HCP credentials,  but nothing worked.

One more strange thing.. I have only one Database (xyz MDC database ),  when I am trying to create one more MDC database, system is not allowing me. Showing msg  ' you have reached the maximum number of SAP HANA tenant database in the account. Please delete or reuse existing ones.

On the other hand I am able create more than one HANA shared schema.

Regards,

Ashutosh

[Murali_Shanmu · Accepted solution]

Not sure what really is wrong at your end. I just created one an hour ago. Try to delete the database and recreate another MDC database. This time make a note of the password you provide for the SYSTEM user. Once the database is created, try to access the "SAP HANA Cockpit" with SYSTEM user.

For trial accounts, you can only create one MDC Database and it will be available for only 7 days.

[ashutosh_shrivastava4 · Accepted solution]

Hi Murli,

Thanks a lot for your suggestion. I was doing some silly mistakes due to that i was not able to connect with SAP HANA cockpit / SAP HANA web based development workbench.

I deleted old database and created a new one.

I went through SAP HANA Cockpit and SYSTEM user assigned roles 'sap.hana.admin.roles::Administrator'..

Then gone through SAP HANA web based development workbench --> Editor--->assigned System user to all roles -- sap.hana.ide---suggested in your previous comment .

Now I am in Editor -->Expand System Schema--> Expand Tables . i dont see any table.

I came back to SAP HCP cockpit--

checked the binding-

I went to iotmms Application URL in SAP HCP --

Now i a in MMS cockpit--

In display stored message, i can see there are five tables--

How i can get these table in System schema Tables (as shown on above, currently there is no table under system schema)

Adding cloud system from Eclipse is still not resolved.

Thanks,

Ashutosh

[anton_levin · Accepted solution]

You have s typo in Account name. It should be "trial", not "trail"

[ashutosh_shrivastava4 · Accepted solution]

Hi Anton,

Thanks for quick help.

Now i am getting below error--

Thanks,

Ashutosh

[anton_levin · Accepted solution]

Your DB user is "SYSTEM"

[ashutosh_shrivastava4 · Accepted solution]

Hi Anton,

I changed the database user to system and providing the password (given at creation of database).

Error is same as above post-- could not connect to SAP HANA cloud platform system. check the error log for more details.

Thanks,

Ashutosh

[anton_levin · Accepted solution]

Then I suggest to check the logs like prompt message says. Should be visible in your Eclipse "Markers" or "Error Logs" view I guess.

[ashutosh_shrivastava4 · Accepted solution]

Hi Anton,

Could you please check below Error screen shot--

First line says--

A database tunnel cannot be opened for HANA databases in state 'STOPPED'.

When i see connectivity in  HCP cockpit. There is no connection under SAP HANA cloud connector.

Not sure is this a right way to see the tunnel ...

Below is the Eclipse Error log in details--

!ENTRY org.apache.log4j 4 0 2016-07-05 10:40:52.490

!MESSAGE com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy  - Failed to connect to the backend: bad request

!ENTRY org.apache.log4j 4 0 2016-07-05 10:40:52.502

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

!ENTRY org.apache.log4j 4 0 2016-07-05 10:40:52.505

!MESSAGE com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy  - statusCode: 400 Bad Request

!ENTRY org.apache.log4j 4 0 2016-07-05 10:40:52.507

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

!ENTRY org.apache.log4j 4 0 2016-07-05 10:40:52.509

!MESSAGE com.sap.core.tunnelcommands.framework.executor.DefaultResponseConsumingStrategy  - content: A database tunnel cannot be opened for HANA databases in state 'STOPPED'.

!ENTRY com.sap.cloud.tools.eclipse.hana.tunnel 4 0 2016-07-05 10:40:56.562

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

!STACK 0

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

A database tunnel cannot be opened for HANA databases in state 'STOPPED'.

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

Caused by: com.sap.jpaas.infrastructure.console.exception.CommandException: Failed to connect to the backend: bad request

A database tunnel cannot be opened for HANA databases in state 'STOPPED'.

  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.persistence.commands.tunnel.api.OpenDbTunnelConsumer.consume(OpenDbTunnelConsumer.java:34)

  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)

Thanks,

Ashutosh

[anton_levin · Accepted solution]

I think the error message is more then explanatory. Your MDC DB is stopped (it stops automatically after 12 hours after creation). Please, go to HCP Cockpit -> Databases & Schemas -> select your MDC DB and start it again.

[ashutosh_shrivastava4 · Accepted solution]

Hi,

My DB was stopped and i started it before writing to you..

Is there anything extra i need to do after restarting the DB.

Eclipse error log--

Thanks,

Ashutosh

[anton_levin · Accepted solution]

No. At least, not what I know. I suggest to search the community for similar issue first and if not exists, open a separate thread describing your steps. I believe, community members will reply.

[ashutosh_shrivastava4 · Accepted solution]

Hi,

Just now i found something strange, I went to Eclipse-->help-->Install new software

I get below error--

But i can see the the available software by clicking "already installed " link..

Is this behavior is  fine ?

Eclipse error---

shall i reinstall the eclipse..

Thanks,

Ashutosh

[anton_levin · Accepted solution]

I do not think re-installation is required. Mars software repository is still available SAP Development Tools for Eclipse - Mars Software Repository

To me, your eclipse cannot reach it (and also hanatrial.ondemand,com endpoint). Did you resolve your issues with proxy settings discussed below in this thread?

[ashutosh_shrivastava4 · Accepted solution]

Hi,

i am connected with home network and my LAN setting is --

my Eclipse Network connection--

Thanks,

Ashutosh

[anton_levin · Accepted solution]

Your settings do not match. In LAN settings you have proxy as "https.proxyhost:8080" and in eclipse "Proxy:8080"

Please, figure out first what is correct.

[ashutosh_shrivastava4 · Accepted solution]

Hi,

Thanks a lot for your immediate and constant support..

I am able to get connect with home network. In Eclipse --> Network connection-- Direct

LAN setting---> Uncheck proxy setting.

How ever i am not getting my IoT table under CATALOG-->SYSTEM-->Tables.

SAP HCP cockpit IoT Tables--

Thanks,

Ashutosh..

[anton_levin · Accepted solution]

Thar is because your mms java app is not bound to MDC DB. Please, double check the starterkit link I have alreafy posted. How-to do the binding is described there at the very beginning.

[ashutosh_shrivastava4 · Accepted solution]

Hi Anton,

I doubled check, i dont see anything fishy.

Assigned the below roles under granted roles tab--

sap.hana.xs.ide.roles::EditorDeveloper

rolesap.hana.xs.ide.roles::Developer

sap.hana.xs.debugger::Debugger

sap.hana.xs.admin.roles::HTTPDestViewer

sap.hana.xs.admin.roles::HTTPDestAdministrator

sap.hana.xs.admin.roles::TrustStoreViewer

sap.hana.xs.admin.roles::TrustStoreAdministrator

IoT having tables---

IoT tables are not reflecting in SAP HANA Web based development work bench and in Eclipse as well.

I am referring blog--

iot-starterkit/src/apps/xs/consumption at master · SAP/iot-starterkit · GitHub

Is it necessary to perform  HANA XS Development steps?

Thanks,

Ashutosh

[anton_levin · Accepted solution]

Your system is called "moon", "moon" is also shown (I see it on a screenshot) as custom logon. Do you have DB user "moon"? You should use user "SYSTEM" for custom logon. Tables will appear in user schema afterwards (schema has the same name as the user - SYSTEM)

Re-do your binding and do not forget to re-start iotmms.

[ashutosh_shrivastava4 · Accepted solution]

Hi,

I deleted the the old db and created a new one where Database user is -- System..

Restarted the iotmms..

Now i can see the IoT fields in Eclipse as well as SAP HANA Web based development work bench..

Thanks a lot.

Ashutosh

[ashutosh_shrivastava4]

Hi Anton,

Today morning i came across a strange thing. Application URL of iotmms is not working.

Error--Access to the requested resource is not authorized (HTTP 401).

So, i am getting same error when try to access MMS- cockpit.

However Deployment is happening without error..

I have already assigned the roles--

IoT-User

IoT-MMS-User

I reassigned the roles, logout and log in.. but dint work...

Thanks,

Ashutosh

[anton_levin]

Missing roles would result in HTTP 403 error and not 401. To me it seems like the Trust settings were modified on your account.

P.S. Please, familiarise yourself with the SCN Rules of Engagements http://scn.sap.com/docs/DOC-18590 and especially #14 Don't hijack threads.

[ashutosh_shrivastava4]

Sorry.

Opening new discussion..

Thanks,

[kirankola]

Hi Ashuthosh,

Check your proxy settings.

Regards,

Kiran

[ashutosh_shrivastava4]

Hi Kiran,

Please see my Network connection setting in attachment.

[kirankola]

Ashtosh,

Try 8080 for both HTTP and HTTPS.

Regards,

Kiran

[ashutosh_shrivastava4]

Hi Kiran,

Its showing Invalid port number.

I am entering 8080 by clicking Edit button.

Screenshot attached.

Thanks,

Ashutosh

[kirankola]

You are including port no in the host input. Change following for HTTP:

- Host: proxy

- Port: 8080

repeat for HTTPS. These are standard ports. You can check with your LAN settings if they are different.

Regards,

Kiran

[ashutosh_shrivastava4]

Hi Kiran,

Still issue is not resolved.

I am in Office network and here post is 80 and address is blank.

Bydefault we use automatic configuration script. For home network we simply uncheck the box and do not check the box of proxy server.(For luck i have check the Proxy server box)

Please suggest if am doing something wrong

Please have a look on attached screen short

Thanks,

Ashutosh