Skip to Content

Obsolete: The SAP HANA Cloud Platform Trial landscape now provides MDCbased tenants which can be used as productive SAP HANA instances. For further information on Trial HANA MDC development, see SAP HANA Multitenant Database Containers (MDC) scenarios now on trial landscape and SAP HANA: Development.

To report this post you need to login first.

62 Comments

You must be Logged on to comment or reply to a post.

  1. Christian Paulus

    Thanks Stoyan, this helped a lot to understand the current situation in regards to native HANA development on HANA Cloud. This is good stuff and I will surely try it out myself.

    Do your plans include lifecycle aspects like import/export of HANA Delivery Units to my schema/repo package?

    (0) 
    1. Emil Aleksandrov

      Hi Christian,

      Yes, we are looking into SAP HANA import/export DU functionality. As this is currently functionality that requires Administrative privileges we are thinking how to wrap it and enable it for HANA Cloud users.

      Best regards,

      Emil

      (0) 
  2. Rui Nogueira

    Thanks a lot Stoyan for sharing this! These are great news!!

    I’ll be on summer vacation from next week on and will take this as an opportunity to dive into the SAP HANA Studio and see how it can talk to my SAP HANA Cloud Platform account. Together with the newly available Mac version of the SAP HANA Studio Developer Edition I’ll be completely prepared 🙂

    Best,

    Rui

    (0) 
  3. Manoj Aswani

    I tried the above tutorial. But got stuck at one place i.e. while testing the remote servlet access. I have also authorized my user i.e. – p1678012516trial with the role that I specified in web.xml of application. And when I am trying to login with this user while accessing the servlet it is not authenticating. The password that I am using is same as that of I use to login in SAP HANA Cloud Service. Repeated trial ended up in following error. Please help in getting out of this problem. I used FORM based authentication also in place of BASIC and the result was same.

    HTTP Status 403 – Access to the requested resource has been denied


    type Status report

    message Access to the requested resource has been denied

    description Access to the specified resource has been forbidden.


    SAP

    (0) 
    1. Dimitar Tenev

      Hi Manoj,

      p1678012516trial” is yout account id. Do assign the role “jdbc_remote_access_admin” to your user id “p1678012516“.

      Best regards,

      Dimitar

      (0) 
      1. Marcos Rocha

        Hi Dimitar,

        I got the same error as Manoj describe and can´t assign the role to user “i2232211”, but only to the user “i2232211trial”.

        Do you have any other idea?

        Best,

        Marcos

        (0) 
        1. Stoyan Manchev Post author

          Hi Marcos,

          actually you are assigning role “jdbc_remote_access_admin” from application “hihana” which is part of account “i2232211trial” to the user “i2232211”. After that you have to login with “i2232211”, not with i2232211trial“.

          (0) 
  4. Frank Schuler

    Hello Stoyan,

    thank you for this excellent blog.

    We got easily to a servelt that seems to work through the browser (the Request URL: https://hihanas000XXXXXXXtrial.hanatrial.ondemand.com/dbaccess-beta-0.3.0/ and Driver URL: jdbc:remotedb:https://hihanas000XXXXXXXtrial.hanatrial.ondemand.com:443/dbaccess-beta-0.3.0/RemotingServlet are slightly different from your blog but correct according to help.sap.com).

    However SAP HANA Studio fails to connect with the message “An exception stack trace is not available.”

    Would you know a way to get to the root cause of this issue?

    Very best regards and many thanks in advance

    (0) 
    1. Stoyan Manchev Post author

      Hi Frank,

      I noticed that Remote Access Tool documentation is changed. I will adapt the blog accordingly.

      About error you got, it is hard to find out what is wrong from this message 🙂

      To get more information do the following:

      1. Add your Remote System to the SAP HANA Studio

      2. Got to <workspace forlder>\.metadata and see what was lastly written in .log file

      Best regards

      Stoyan

      (0) 
      1. Frank Schuler

        Thank you Stoyan.

        the .log file says

        !ENTRY com.sap.ndb.studio.navigator 4 1 2013-08-19 11:25:25.982

        !MESSAGE [hihanas0007397050trial https://hihanas000XXXXXXXtrial.hanatrial.ondemand.com:443/dbaccess-beta-0.3.0/remotingservlet 00 (S0007397050)] Error when refreshing system

        !SUBENTRY 1 com.sap.ndb.studio.navigator 4 0 2013-08-19 11:25:25.982

        !MESSAGE SAPControl request failed

        !STACK 0

        com.sap.ndb.studio.sapcontrol.SAPControlException: SAPControl request failed

        at com.sap.ndb.studio.sapcontrol.operations.SAPControlOperation.execute(SAPControlOperation.java:118)

        at com.sap.ndb.studio.sapcontrol.SAPControl.getInstanceProperties(SAPControl.java:507)

        at com.sap.ndb.studio.sapcontrol.SAPControl.collectProperties(SAPControl.java:583)

        at com.sap.ndb.studio.sapcontrol.SAPControl.open(SAPControl.java:372)

        at com.sap.ndb.studio.sapcontrol.SAPControlManager.getSAPControl(SAPControlManager.java:130)

        at com.sap.ndb.studio.sapcontrol.SAPControlManager.getSAPControl(SAPControlManager.java:82)

        at com.sap.ndb.studio.sapcontrol.SAPControlManager.needCredentials(SAPControlManager.java:55)

        at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.executeTrySAPControl(SAPSystemObjectUpdate.java:123)

        at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.execute(SAPSystemObjectUpdate.java:69)

        at com.sap.ndb.studio.navigator.operations.UpdateSAPSystemOperation.execute(UpdateSAPSystemOperation.java:72)

        at com.sap.ndb.studio.datamodel.controler.DataModelOperationJob.run(DataModelOperationJob.java:70)

        at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)

        Caused by: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Bad URL: Invalid authority field: [https:

        at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.call(Unknown Source)

        at com.sap.ndb.studio.sapcontrol.operations.SAPControlOperation.execute(SAPControlOperation.java:94)

        … 11 more

        !SUBENTRY 1 com.sap.ndb.studio.navigator 4 4 2013-08-19 11:25:25.982

        !MESSAGE Internal error

        !STACK 0

        Many thanks in advance again

        Frank

        (0) 
        1. Stoyan Manchev Post author

          Hi Frank,

          the exception you have posted is “expected” behavior, because this is one of the Remote Access Tool limitations – SAP Control is not supported.

          Can you please check your proxy settings – http and https proxies should be configured (if you are behind proxy).

          Best regards

          Stoyan

          (0) 
        2. Frank Schuler

          Hello Stoyan,

          strangely the access works intermittedly. However there is always a red cross on the system, even when the connection works and the exception is

          com.sap.ndb.studio.jdbc.JDBCConnectionStatus: In method getAccessdata: The password must be specified.

          Do you have any idea where this might come from?

          Very best regards and many thanks in advance again

          Frank

          (0) 
          1. Stoyan Manchev Post author

            Hi Frank,

            the red cross that you see on the system is some known limitation – because SAP Control is not working. But this in no way will stop you working as usual with your db schema and repository.

            As Remote Access Tool is in beta, it has some limitations – as the one you have noticed. Currently will are working on new connectivity model that will fill all the gaps you see while working with Remote Access Tool.

            (0) 
  5. Sampathkumar Subramaniam

    Hi Stoyan,

    I have the below problem in Remote Database Access tool even after proxy configuration.

    Could not open connection to ‘hihanap1937023077trial https://hihanap1937023077trial.hanatrial.ondemand.com:443/dbaccess-beta-0.3.0/remotingservlet 00′

    java.util.concurrent.ExecutionException: com.sap.ndb.studio.jdbc.JDBCConnectionStatus: Could not connect: 401 Unauthorized

    any idea how to fix this?

    Thanks a lot in advance.

    Regards,

    Sampath.

    (0) 
  6. Apoorv Bhargava

    Thanks Stoyan for sharing this very helpful blog.

    I am relatively new to HANA Cloud world and curious to understand the difference between this servlet approach vs XSJS approach.

    In past, I used XSJS to connect to data base and get the data from tables which seems to similar to this servlet approach.

    It would be very helpful if you share some info o this

    (0) 
    1. Jordan Jordanov

      Hi Apoorv,

      There are some similarities in XSJS and JAVA Servlets.

      In both cases you can connect to the DB and expose your business logic as a serivce in the web.

      The difference is in the setup – with XS you use only HANA as dev and runtime environment and you don’t need additional servers. Taking in mind the locallity of the XS Engine in the HANA DB you can expect also better berformance for your HANA Native applications. From the other hand side JAVA applications are far more powerful when it comes to integration with other systems and consumption of external services due to the various libraries available for that.

      Note that XS applications will be supported in the SAP HANA Cloud soon. We are currently working on that.

      Best Regards

      Jordan

      (0) 
      1. Ajay Chinta

        Hi Jordan,

        As a part of the support of HANA native development on the cloud, will there be support for exposing OData services from the HANA Cloud tables? If yes, there two advantages I can think of.

        1. We would save a lot of development effort if we are able to use OData services with SAP UI5.
        2. We might be able to deploy the same application on HANA One or HANA Cloud with minor (if any) changes.

        Can you please let us know if SAP planning for OData from HANA db tables on HCP?

        Regards

        Ajay

        (0) 
        1. Jordan Jordanov

          Hi Ajay,

          The plan is to enable HANA XS Development and to support more or less all features of HANA including OData Services.

          Deploying applications on SAP HANA Cloud will have some specifics though.

          For the beginning you will not be able to import DUs directly in HANA but will have to use HANA Development Perspective in the Studio and activate your projects from there.

          Let’s wait for the official delivery. It will come with the appropriate documentation.

          Best Regards

          Jordan

          (0) 
          1. Ajay Chinta

            Hi Jordan,

            This is good news. Can you please let know how long it might take for SAP to release this?Even an approximate indicator regarding the timeline would help.

            Regards

            Ajay

            (0) 
            1. Emil Aleksandrov

              Hi Ajay,

              The first version of how you can build and run HANA XS application in SAP HANA Cloud will come within weeks on TRIAL landscape. We will update this blog as well.

              Best regards,

              Emil

              (0) 
  7. Frank Schuler

    Hello Stoyan,

    SAP HANA Studio does not show a _SYS_BIC schema but only a SYS and a _SYS_REPO for my SAP HANA Cloud system. Therefore I cannot find my generated column view.

    Thank you very much for your help in advance again

    Frank

    (0) 
        1. Stoyan Manchev Post author

          Hi Frank,

          after execution of this procedure you should be able to see a column view in _SYS_BIC schema and be able to select data from it.

          Can you tell me what is the package name in which you have created the calculation view?

          best regards

          Stoyan

          (0) 
          1. Frank Schuler

            Hello Stoyan,

            we started from scratch and observed the following:

            1. When trying to activate calculation view SO_CV, SAP HANA Studio reports “There are no inactive objects in your workspace to be activated”
            2. When running “ALL “HCP”.”HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS” the result is “Statement ‘CALL “HCP”.”HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS”‘ successfully executed in 430 ms 173 µs  (server processing time: 0 ms 0 µs) – Rows Affected: 0

            Are we missing something?

            Very best regards

            Frank

            (0) 
              1. Bence Toth

                Hi,

                I had the same issue with Studio v58. As I am an SAP employee I could upgrade Studio to the latest build v69.

                It has solved both problems:

                – Popup from “inactive objects” has disappeared

                – “HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS” has worked, _SYS_BIC schema & views are visible.

                IMO: Upgrade to latest available build from SDN (v60)

                (1) 
  8. praveen Kodi

    Hello SAP HANA Team,

    We are using SAP HANA Instance on Cloud Share. We are using windows platform for migrating source system (SQL Server 2008) to target system SAP HANA. But, for the last 3 days we are facing connection issues on Cloud share instance. We are not able to connect Cloud Share. So, we lost our production for the last 3 days.

    How to resolve the connection issues from Cloud Share to SAP HANA?

    Looking for best optimized solution.

    Best Regards,

    Praveen Kodi

    (0) 
    1. Jordan Jordanov

      Hi Praveen,

      Cloud Share Platform is not directly related to the SAP HANA Cloud.

      Unfortunatelly the names are getting similar and this can easily confuse you.

      In few words: Cloud Share, together with Amazon Web Services are providing IaaS, they give you a virtual image with pre-installed HANA DB.

      SAP HANA Cloud is PaaS where you can consume some of the existing Cloud services like the Document Service. You can create and run also Java Applications, it’s not just the HANA DB Instance.

      (0) 
  9. Prajesh K

    Hello Stoyan,

       can we use this for PROD landscape (neo.ondemand.com) with own account? I tried to include the jar file to my application and deployed it in the server. But I couldn’t find even the authorization role in the account page at my application level (role was included in the web.xml).

    (0) 
  10. Ashok Kumar M

    Hi Stoyan,

    Since the cloud platform is on top of HANA, can I access the HANA XS engine from cloud platform?

    If yes, could you please share some information?

    Best Regards,

    Ashok.

    (0) 
    1. Stoyan Manchev Post author

      Hi Ashok,

      currently this functionality is available on our internal landscape PROD(neo.ondemand.com).

      Emil Alexandrov have put links for the documentation in his comment above.

      Stoyan

      (0) 
  11. Satya Sreenivasan

    Hi Stoyan

    I tried the above tutorial. I’m able to activate the calculation view and see the result of the SELECT query from HANA Studio, however, I am getting a 404 “Requested resource not found” error on running the application. Am I missing something?

    TIA

    (0) 
  12. Manjunath Babu Rayampalli

    what is the solution for known limitation

    • Data Preview menu is not working from the SAP HANA Modeler or the SAP HANA Development perspective

    • as i am facing that for Attribute view while doing data privew, it says either project is not shared or your not connected to the DB.

    • Connection is there, i ahve crosschecked for same.

    • Any comments on this?
    (0) 
  13. Vikas Madaan

    Hi,

    I am having productive instance on hana.ondemand.com. I am using both the options HANA studio and DB tunnel to connect to the HANA DB on Cloud.

    It is possible to open the DB tunnel in background. We are integrating client tools with HANA DB on Cloud. Command Promt looks odd to the users and not all the users have Studio installed on their local machine. I saw new open-db-tunnel has background option but it is not working for me. Please help.

    Thanks!

    Vikas

    (0) 
  14. Navneet Jha

    Hi

    What will be the MY_PACKAGE name in the code?
    I am little bit confused here. I gave the package name like:

    “p1940477959trial.hana066”

    Am I correct?

    (0) 
    1. Jordan Jordanov

      Hi Navneet,

      Indeed, it’s confusing.

      You can always execute the query below to get the metadata relevant for your own dev user.

      SELECT * FROM “HCP”.”HCP_DEV_METADATA”

      Package name is also returned.


      Best Regards

      Jordan

      (0) 
  15. Madhu Sudan Reddy B

    Hi,

    I have account in hanatrail ondemnad – p1941559136trial. I created a HANA instance and want use the same in my local eclipse. So when try to do the same I am prompted with Account Id, User Name and Password. I am entering p1941559136trial as Account ID.

    What should be the user ID and PWD?  I used the credentials used to login to hana ontrial but does not work. Can you please help with this?

    Regards,

    Madhu

    (0) 
  16. Dionisio Ambrona

    Hi,

    I’ve managed to create my first calculation view in my SAP HANA Cloud instance following this blog, so many thanks for this: it allowed me to see the data modeling tools for HANA in Eclipse at last!

    However, now I have a problem just at the end of step 4, as the view seems OK but it retrieves no data, even when source tables do contain data that matches the join criteria. I have activated it and run OK the call “HCP”.”HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS” procedure, but even so there is no data found.

    Also sentence:

    SELECT * FROM “_SYS_BIC”.”s0007765223trial.mysaphanatrialinstance.hihana/SO_CV”

    finds no data.

    Any idea on what could be wrong?

    Thank you!

    (0) 
  17. Dionisio Ambrona

    Hi,

    for step 5 I also have problems. The servlet run returns:

    Failed executing SQL: SELECT TOP 10 COMPANY_NAME, GROSS_AMOUNT, NET_AMOUNT FROM “_SYS_BIC”.”s0007765223trial.hihana.web/SO_CV” ORDER BY GROSS_AMOUNT DESC

    Error message: Borrow prepareStatement from pool failed

    This I tried with different values for MY_PACKAGE, all of them failing:

    “s0007765223trial.s0007765223trial.hihana.web”

    “s0007765223trial.mysaphanatrialinstance.hihana”

    “s0007765223trial.hihana.web”

    Is it because the previous error of no data found in the view? Or maybe the MY_PACKAGE value is wrong? How can we know what is the right value for MY_PACKAGE?

    Thank you!

    (0) 
    1. Dionisio Ambrona

      Hi,

      as that was not working, I created a new calculation view and subtituted it in the select in the servlet code. However, the response is again an error. On check the server log, I see the exception is “Could not find table/view in schema“, but as screenshot shows the view is in that schema.

      I found this blog outside SCN that suggests a capital letter table name issue, but seems not the case. I will continue to investigate that thread in that blog for further options to solve this.

      http://stackoverflow.com/questions/29974507/sap-hana-invalid-table-name

      2016.01.07_View.not_found.jpg

      (0) 

Comments are closed.