Skip to Content

After Making the Web IDE work on my local HANA platform on Revision 121 and SAP to Unveil SAP HANA 2, I wanted to make it work on this newest release again.

To start with, I download the installation files:

And install a small HANA 2 system on a virtual machine similar to the one that runs the HANA, express edition:

I choose to install all components including HANA AFL, HANA Database Client, HANA Smart Data Access, HANA Studio and most importantly HANA XS Advanced Runtime:

Importantly, I chose a multiple database container installation, to keep the footprint as small as possible:

Next, I provide passwords for important users, chose my Customer Space and most importantly chose that Application URLs are based on ports:

Finally, I chose to install all All XS Advanced Components:

And kick-off the installation:

This can take a while but eventually finishes successfully:

Next, I log into HANA Studio, connect to my system and create a XS Advanced development user:

Then I determine the URL of the XS Advanced Administration tool:

And connect to create first a WEBIDE_ADMINISTRATOR:

And second a WEBIDE_DEVELOPER Role Collection:

The WEBIDE_ADMINSTRATOR Role Collection gets assigned to the XSA_ADMIN user:

For development, I create a New User Based on my existing XSA_DEV User:

This gets assigned the WEBIDE_DEVELOPER as well as the XS_CONTROLLER_USER Role Collections (details can be found in the SAP Web IDE for SAP HANA – Installation and Upgrade Guide):

With this I make my XSA_ADMIN user the Manager of my Organization:

And both my XSA_ADMIN as well as my XSA_DEV user Developers in the PROD Space, as well as my XSA_ADMIN the respective Manager:

From the Application Monitor:

I launch the Space Enablement to enable my PROD space for development by deploying builders:

To start XSA development, I determine the URL of my Web IDE:

With this I log into my local Web IDE and start Developing with XS Advanced: A TinyWorld Tutorial by Chaim Bendelac, which deploys successfully:

Finally, I check my PROD Space in the XS Advanced Administration Organization and Space Management and see the di-builder Application deployed:

As well as my tinyworld-hdi-container:

To report this post you need to login first.

6 Comments

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

  1. Francisco Marquez

    Great post Frank, thanks. I also managed to get insights into the space enablement thanks to your article.

    I’d like to know the differences with an “out of the box” Hana 2 express VM installation. I completed all the installation and setup steps, as per the guidelines, but even with a vanilla installation the user XSA_DEV cannot “save” or “run” a basic project (just a folder and an HTML file) in Webide. There are no errors in the logs or console. It does not matter to which space the project is assigned (SAP, or Development).

    Frankly I’m mystified, as I thought that the VM was preconfigured to start Webide development already…

     

    Any insight will be very helpful!

    (0) 
    1. Frank Schuler Post author

      Hello Francisco,

      I am sorry to hear about your trouble trying to develop on the HANA 2, express edition. At the time of my blog, there was of course no HANA 2, express edition, but I have been using it since it has become available without issues.

      For test purposes, I just did a fresh optimised installation, and the XSA_DEV developer can develop, build and deploy fine in the SAP space. Out of the box, user XSA_DEV is not configured to develop in the development space.

      Perhaps you are facing a certificate issue. If you like, please have a look at my blog Tips & tricks for an optimized HANA 2.0, express edition installation on an Intel 6th generation NUC.

      Best regards

      Frank

      (0) 
      1. Francisco Marquez

        Thanks Frank, you are totally right. I already added xsa_dev to the development space, and I found my issue. It seems that it was a basic misunderstand on my side of how Web Ide operates. I needed the .yaml file to include the type of project. It runs and deploys just fine!

        I’m now “fighting” some small browser related issues.

        Your post about the NUC is very interesting! I’m also running a similar configuration (ESXi 6.5 and a different NUC model). Great development server!

        Thanks again

        (0) 
  2. Xin Qian

    Hi Frank,

    I was trying to install HAHA2 with Web IDE on our local server(version is SUSE Linux Enterprise Server for SAP Applications 12 SP1).

    I follow the steps and all components install successfully. However, when I try to login XSA-Admin({“key”:”xsa-admin”,”value”:”https://xx.xxx.xx.xx:51019″}), it pass the uaa service, but Web IDE can not be launched. (it was showing “Internal Server Error”).

    Hope you could give me some suggestions, or would you please help to review the log, see if anything wrong.

    The following is the installation log, since each steps is successfully, I remove some details, making the log not too long:

     

    SAP HANA Lifecycle Management – SAP HANA Database 2.00.000.00.1479874437
    ************************************************************************

    14:25:59.864 – INFO: Start Date: 2017-09-15 – hdblcm


    14:29:42.730 – INFO: Installing components…
    14:29:42.745 – INFO: ———————————————————–
    14:29:42.745 – INFO: Installing SAP HANA Database…
    14:29:42.745 – INFO: ———————————————————–
    14:29:42.745 – INFO: Creating directory ‘/hana/data/TA1’
    14:29:42.745 – INFO: Creating directory ‘/hana/log/TA1’
    14:29:42.747 – INFO: Starting external program /hana/docs/xiaojun/DATA_UNITS/HDB_SERVER_LINUX_X86_64/hdbinst
    14:29:42.747 – INFO: Command line is: /hana/docs/xiaojun/DATA_UNITS/HDB_SERVER_LINUX_X86_64/hdbinst –db_mode=multidb –hostname=nkgl50849577a –number=00 –logpath=/hana/log/TA1 –skip_modify_sudoers=off –sid=TA1 –workergroup=default –max_mem=0 –install_hostagent=on –autostart=off –sapmnt=/hana/shared –userid=1001 –isc_mode=ssl –groupid=79 –db_isolation=low –restrict_max_mem=off –system_usage=development –nostart=off –skip_hostagent_calls=off –home=/usr/sap/TA1/home –datapath=/hana/data/TA1 –remote_execution=ssh –shell=/bin/sh –instlog_dir=/var/tmp/hdb_TA1_hdblcm_install_2017-09-15_14.25.57 -b -a /hana/docs/xiaojun/DATA_UNITS/HDB_SERVER_LINUX_X86_64/server –read_password_from_stdin=xml –isc_mode=ssl
    14:29:43.861 – INFO: Output line 1: SAP HANA Database installation kit detected.
    14:29:44.443 – INFO: Output line 10:
    14:29:44.443 – INFO: Output line 11: Summary before execution:
    14:29:44.443 – INFO: Output line 12: Installation Path: /hana/shared
    14:29:44.443 – INFO: Output line 13: SAP HANA System ID: TA1
    14:29:44.443 – INFO: Output line 14: Instance Number: 00
    14:29:44.443 – INFO: Output line 15: Database Mode: multiple_containers
    14:29:44.443 – INFO: Output line 16: Database Isolation: low
    14:29:44.444 – INFO: Output line 17: System Usage: development
    14:29:44.444 – INFO: Output line 18: System Administrator Home Directory: /usr/sap/TA1/home
    14:29:44.444 – INFO: Output line 19: System Administrator Login Shell: /bin/sh
    14:29:44.444 – INFO: Output line 20: System Administrator User ID: 1001
    14:29:44.444 – INFO: Output line 21: ID of User Group (sapsys): 79
    14:29:44.444 – INFO: Output line 22: Location of Data Volumes: /hana/data/TA1
    14:29:44.444 – INFO: Output line 23: Location of Log Volumes: /hana/log/TA1
    14:29:44.444 – INFO: Output line 24: Local Host Name: nkgl50849577a
    14:29:44.444 – INFO: Output line 25: Enable the installation or upgrade of the SAP Host Agent: Yes
    14:29:44.445 – INFO: Output line 26: Worker Group: default
    14:29:44.445 – INFO: Output line 27: Inter Service Communication Mode: ssl
    14:29:44.445 – INFO: Output line 28:
    14:29:44.450 – INFO: Output line 29: Checking installation…
    14:35:08.663 – INFO: END: Install SAP HANA Database (start: 14:29:42.745 duration: 00:05:25.918)
    14:35:08.663 – INFO: ———————————————————–
    14:38:43.763 – INFO: END: Install SAP HANA Studio (start: 14:36:43.545 duration: 00:02:00.217)
    14:38:43.763 – INFO: ———————————————————–
    14:38:43.787 – INFO: Installing SAP HANA Smart Data Access…
    14:38:44.003 – INFO: ———————————————————–
    14:38:44.003 – INFO: END: Install SAP HANA Smart Data Access (start: 14:38:43.787 duration: 00:00:00.215)
    14:38:44.003 – INFO: ———————————————————–
    14:38:44.017 – INFO: Installing SAP HANA XS Advanced Runtime…
    14:38:44.017 – INFO: ———————————————————–
    14:38:44.035 – INFO: Writing XS Advanced space OS users to user config…
    14:38:44.037 – INFO: …
    14:39:40.117 – INFO: ———————————————————–
    14:39:40.117 – INFO: END: Installation of SAP HANA XS Advanced Runtime finished (start: 14:38:44.017 duration: 00:00:56.099)
    14:39:40.117 – INFO: ———————————————————–
    14:39:40.130 – INFO: Assigning Additional Roles to the Local Host…
    14:39:40.130 – INFO: ———————————————————–
    14:39:40.132 – INFO: Starting external program /hana/shared/TA1/global/hdb/install/bin/hdbmodify
    14:39:40.132 – INFO: Command line is: /hana/shared/TA1/global/hdb/install/bin/hdbmodify -b –add_roles=nkgl50849577a:role=xs_worker –read_password_from_stdin=xml –instlog_dir=/var/tmp/hdb_TA1_hdblcm_install_2017-09-15_14.25.57 –system_user=SYSTEM –org_manager_user=XSA_ADMIN –import_xs_content=on –skip_modify_sudoers=off
    14:39:41.272 – INFO: 。。。
    14:45:49.133 – INFO: ———————————————————–
    14:45:49.133 – INFO: END: Assign Additional Roles to the Local Host finished (start: 14:39:40.130 duration: 00:06:09.002)
    14:45:49.133 – INFO: ———————————————————–
    14:45:49.134 – INFO: Registering SAP HANA Database Components on Local Host…
    14:45:49.134 – INFO: ———————————————————
    14:45:57.371 – INFO: END: Register SAP HANA Database Components on Local Host finished successfully (start: 14:45:49.134 duration: 00:00:08.237)
    14:45:57.371 – INFO: ———————————————————–
    14:45:57.372 – INFO: Installing XS Advanced Components…
    14:45:57.372 – INFO: ———————————————————–
    14:45:58.656 – INFO: …
    14:46:01.449 – INFO: Installing XSAC FILEPROCESSOR 1.0…
    14:46:01.449 – INFO: ———————————————————
    14:49:59.357 – INFO: END: Installation of XSAC FILEPROCESSOR 1.0 finished (start: 14:46:01.449 duration: 00:03:57.907)
    14:49:59.357 – INFO: ———————————————————
    14:49:59.358 – INFO: Installing SAP HANA Runtime Tools 2…
    14:49:59.358 – INFO: ———————————————————
    14:49:59.360 – INFO: Switching to user id 1001 and group id 79.
    14:49:59.360 – INFO: Starting external program /hana/shared/TA1/xs/bin/xs
    14:49:59.360 – INFO: Command line is: /hana/shared/TA1/xs/bin/xs install /hana/docs/xiaojun/DATA_UNITS/XSAC_HRTT_20/XSACHRTT00_0.ZIP -o ALLOW_SC_SAME_VERSION -e /hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/sap-xsac-shine-1.2.2-XSACSHINE02_2.mtaext,/hana/docs/xiaojun/DATA_UNITS/XSAC_SAP_WEB_IDE_20/sap-xsac-devx-4.0.18.mtaext
    14:50:00.078 – INFO: Output line 1:
    14:50:00.083 – INFO: Output line 2: Running installation in org “orgname” / space “SAP” as XSA_ADMIN…
    14:50:05.013 – INFO: …
    14:52:46.725 – INFO: Switching back to root user.
    14:52:46.726 – INFO: ———————————————————
    14:52:46.726 – INFO: END: Installation of SAP HANA Runtime Tools 2 finished (start: 14:49:59.358 duration: 00:02:47.367)
    14:52:46.726 – INFO: ———————————————————
    14:52:46.727 – INFO: Installing XS Monitoring 1…
    14:54:14.371 – INFO: ———————————————————
    14:54:14.371 – INFO: END: Installation of XS Monitoring 1 finished (start: 14:52:46.727 duration: 00:01:27.643)
    14:54:14.371 – INFO: ———————————————————
    14:54:14.372 – INFO: Installing Develop and run portal services for custome apps on XSA…
    14:54:14.372 – INFO: ———————————————————
    14:54:14.373 – INFO: Switching to user id 1001 and group id 79.
    14:54:14.374 – INFO: Starting external program /hana/shared/TA1/xs/bin/xs
    14:54:14.374 – INFO: Command line is: /hana/shared/TA1/xs/bin/xs install /hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/XSACPORTALSERV00_0.zip -o ALLOW_SC_SAME_VERSION -e /hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/sap-xsac-shine-1.2.2-XSACSHINE02_2.mtaext,/hana/docs/xiaojun/DATA_UNITS/XSAC_SAP_WEB_IDE_20/sap-xsac-devx-4.0.18.mtaext
    14:54:15.098 – INFO:
    14:55:00.657 – INFO: Output line 98: Installation of archive file ‘[/hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/XSACPORTALSERV00_0.zip]’ finished successfully.
    14:55:00.657 – INFO: Output line 99: To see installation logs execute ‘xs display-installation-logs 809 -scv’.
    14:55:00.665 – INFO: Output line 100:
    14:55:00.713 – INFO: Program terminated with exit code 0
    14:55:00.713 – INFO: Switching back to root user.
    14:55:00.713 – INFO: ———————————————————
    14:55:00.713 – INFO: END: Installation of Develop and run portal services for custome apps on XSA finished (start: 14:54:14.372 duration: 00:00:46.341)
    14:55:00.713 – INFO: ———————————————————
    14:55:00.714 – INFO: Installing SAP Web IDE Web Client…
    14:55:00.714 – INFO: ———————————————————
    14:55:00.716 – INFO: Switching to user id 1001 and group id 79.
    14:55:00.717 – INFO: Starting external program /hana/shared/TA1/xs/bin/xs
    14:55:00.717 – INFO: Command line is: /hana/shared/TA1/xs/bin/xs install /hana/docs/xiaojun/DATA_UNITS/XSAC_SAP_WEB_IDE_20/XSACSAPWEBIDE00_0.ZIP -o ALLOW_SC_SAME_VERSION -e /hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/sap-xsac-shine-1.2.2-XSACSHINE02_2.mtaext,/hana/docs/xiaojun/DATA_UNITS/XSAC_SAP_WEB_IDE_20/sap-xsac-devx-4.0.18.mtaext
    14:55:01.418 – INFO: …
    15:00:49.435 – INFO: Output line 250: Software component XSAC_SAP_WEB_IDE (sap.com) ‘SAP Web IDE Web Client’ successfully registered.
    15:00:49.435 – INFO: Output line 251: Process [install] finished successfully.
    15:00:49.437 – INFO: Output line 252: Performance /hana/docs/xiaojun/DATA_UNITS/XSAC_SAP_WEB_IDE_20/XSACSAPWEBIDE00_0.ZIP: UploadFiles 13.8 s (13806 ms), Installation 5 m 24 s (324355 ms).
    15:00:49.438 – INFO: Output line 253: Installation of archive file ‘[/hana/docs/xiaojun/DATA_UNITS/XSAC_SAP_WEB_IDE_20/XSACSAPWEBIDE00_0.ZIP]’ finished successfully.
    15:00:49.439 – INFO: Output line 254: To see installation logs execute ‘xs display-installation-logs 919 -scv’.
    15:00:49.447 – INFO: Output line 255:
    15:00:49.487 – INFO: Program terminated with exit code 0
    15:00:49.487 – INFO: Switching back to root user.
    15:00:49.488 – INFO: ———————————————————
    15:00:49.488 – INFO: END: Installation of SAP Web IDE Web Client finished (start: 14:55:00.714 duration: 00:05:48.773)
    15:00:49.488 – INFO: ———————————————————
    15:00:49.489 – INFO: ———————————————————
    15:00:49.489 – INFO: Installing XS Services 1…
    15:00:49.489 – INFO: ———————————————————
    15:00:49.491 – INFO: Switching to user id 1001 and group id 79.
    15:00:49.491 – INFO: Starting external program /hana/shared/TA1/xs/bin/xs
    15:00:49.491 – INFO: Command line is: /hana/shared/TA1/xs/bin/xs install /hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/XSACSERVICES03_2.ZIP -o ALLOW_SC_SAME_VERSION -e /hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/sap-xsac-shine-1.2.2-XSACSHINE02_2.mtaext,/hana/docs/xiaojun/DATA_UNITS/XSAC_SAP_WEB_IDE_20/sap-xsac-devx-4.0.18.mtaext
    15:00:50.225 – INFO: …
    15:04:39.102 – INFO: Output line 201: Software component XSAC_SERVICES (sap.com) ‘XS Services 1’ successfully registered.
    15:04:40.159 – INFO: Output line 202: Process [install] finished successfully.
    15:04:40.161 – INFO: Output line 203: Performance /hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/XSACSERVICES03_2.ZIP: UploadFiles 3.12 s (3124 ms), Installation 3 m 42 s (221605 ms).
    15:04:40.162 – INFO: Output line 204: Installation of archive file ‘[/hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/XSACSERVICES03_2.ZIP]’ finished successfully.
    15:04:40.162 – INFO: Output line 205: To see installation logs execute ‘xs display-installation-logs 1347 -scv’.
    15:04:40.170 – INFO: Output line 206:
    15:04:40.213 – INFO: Program terminated with exit code 0
    15:04:40.213 – INFO: Switching back to root user.
    15:04:40.214 – INFO: ———————————————————
    15:04:40.214 – INFO: END: Installation of XS Services 1 finished (start: 15:00:49.489 duration: 00:03:50.725)
    15:04:40.214 – INFO: ———————————————————
    15:04:40.215 – INFO: ———————————————————
    15:04:40.215 – INFO: Installing SAPUI5 FESV2 XSA 1 – SAPUI5 SDK 1.38…
    15:04:40.215 – INFO: ———————————————————
    15:04:40.217 – INFO: Switching to user id 1001 and group id 79.
    15:04:40.217 – INFO: Starting external program /hana/shared/TA1/xs/bin/xs
    15:04:40.217 – INFO: Command line is: /hana/shared/TA1/xs/bin/xs install /hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/XSACUI5FESV238_10.zip -o ALLOW_SC_SAME_VERSION -e /hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/sap-xsac-shine-1.2.2-XSACSHINE02_2.mtaext,/hana/docs/xiaojun/DATA_UNITS/XSAC_SAP_WEB_IDE_20/sap-xsac-devx-4.0.18.mtaext
    15:04:40.922 – INFO: Output line 1:
    15:04:40.927 – INFO: Output line 2: Running installation in org “orgname” / space “SAP” as XSA_ADMIN…
    15:04:47.612 – INFO: …
    15:06:23.330 – INFO: Output line 120: Software component XSAC_UI5_FESV2 (sap.com) ‘SAPUI5 FESV2 XSA 1 – SAPUI5 SDK 1.38’ successfully registered.
    15:06:23.330 – INFO: Output line 121: Process [install] finished successfully.
    15:06:23.332 – INFO: Output line 122: Performance /hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/XSACUI5FESV238_10.zip: UploadFiles 5.24 s (5242 ms), Installation 1 m 32 s (91711 ms).
    15:06:23.333 – INFO: Output line 123: Installation of archive file ‘[/hana/docs/xiaojun/DATA_UNITS/XSA_CONTENT_10/XSACUI5FESV238_10.zip]’ finished successfully.
    15:06:23.333 – INFO: Output line 124: To see installation logs execute ‘xs display-installation-logs 1673 -scv’.
    15:06:23.341 – INFO: Output line 125:
    15:06:23.397 – INFO: Program terminated with exit code 0
    15:06:23.397 – INFO: Switching back to root user.
    15:06:23.398 – INFO: ———————————————————
    15:06:23.398 – INFO: END: Installation of SAPUI5 FESV2 XSA 1 – SAPUI5 SDK 1.38 finished (start: 15:04:40.215 duration: 00:01:43.183)
    15:06:23.398 – INFO: ———————————————————
    15:06:23.399 – INFO: Getting Product Installer logs…
    15:06:23.399 – INFO: Switching to user id 1001 and group id 79.
    15:06:23.399 – INFO: Starting external program /bin/bash
    15:06:23.399 – INFO: Command line is: /bin/bash -c “‘/hana/shared/TA1/xs/bin/xs’ logs product-installer –last 1000 > ‘/var/tmp/hdb_TA1_hdblcm_install_2017-09-15_14.25.57/xs_install_components.log’”
    15:06:27.643 – INFO: Program terminated with exit code 0
    15:06:27.643 – INFO: Switching back to root user.
    15:06:27.644 – INFO: Log file written to ‘/var/tmp/hdb_TA1_hdblcm_install_2017-09-15_14.25.57/xs_install_components.log’
    15:06:27.645 – INFO: Switching to user id 1001 and group id 79.
    15:06:27.645 – INFO: Starting external program /hana/shared/TA1/xs/bin/xs
    15:06:27.645 – INFO: Command line is: /hana/shared/TA1/xs/bin/xs logout
    15:06:28.353 – INFO: Output line 1:
    15:06:28.354 – INFO: Output line 2: Logging out…
    15:06:28.354 – INFO: Output line 3: OK
    15:06:28.373 – INFO: Output line 4:
    15:06:28.387 – INFO: Program terminated with exit code 0
    15:06:28.387 – INFO: Switching back to root user.
    15:06:28.388 – INFO: ———————————————————–
    15:06:28.388 – INFO: END: Install XS Advanced Components finished (start: 14:45:57.372 duration: 00:20:31.015)
    15:06:28.388 – INFO: ———————————————————–
    15:06:28.389 – INFO: ———————————————————–
    15:06:28.389 – INFO: Creating Component List…
    15:06:28.389 – INFO: ———————————————————–
    15:06:28.425 – INFO: Parsing /hana/shared/TA1/exe/linuxx86_64/hdb/PD.XML…
    15:06:28.426 – INFO: Reading product information…
    15:06:28.427 – INFO: Reading product instances information…
    15:06:28.432 – INFO: Processing PD.XML in directory ‘/hana/shared/TA1/exe/linuxx86_64/hdb’…
    15:06:28.432 – INFO: Parsing /hana/shared/TA1/exe/linuxx86_64/hdb/PD.XML…
    15:06:28.432 – INFO: Reading product information…
    15:06:28.433 – INFO: Reading product instances information…
    15:06:28.436 – INFO: Found product ‘SAP NEWDB 2.0’.
    15:06:28.436 – INFO: Found product instance ‘SAP HANA SDA database drivers for federation’.
    15:06:28.436 – INFO: Found product instance ‘SAP HANA Application Function Libraries’.
    15:06:28.436 – INFO: Found product instance ‘SAP HANA database server’.
    15:06:28.436 – INFO: Found product instance ‘XS Advanced Runtime’.
    15:06:28.436 – INFO: Detected product information for product ‘SAP NEWDB 2.0’
    15:06:28.454 – INFO: ———————————————————–
    15:06:28.454 – INFO: END: Creating Component List (start: 15:06:28.389 duration: 00:00:00.064)
    15:06:28.454 – INFO: ———————————————————–
    15:06:31.414 – INFO: SAP HANA Database System installed

     

    Thanks

    Xin

    (0) 

Leave a Reply