Skip to Content
Technical Articles

Installing XSA & WebIDE for HANA 2

To use XSA, first you must download the additional XSA components from SAP Support – Software Downloads – these packages are in addition to the base HANA Platform.
Knowing exactly which files are required can be tricky, so I have captured those below.
I used HANA 2.00.23 (HANA 2 SP2 Rev 23).

Search Words Description Filename (as at 22-Jan-2018)
EXTAPPSER Extended App Services – This is the main XSA server run time component EXTAPPSER00P_71-70001316.SAR
HRTT HANA Run Time Tools, required for WebIDE XSACHRTT02_6.zip
XSACMONITOR XS Monitoring, required for WebIDE XSACMONITORING05_2.zip
WEBIDE The New SAP WEB IDE 2 XSACSAPWEBIDE02_0.zip

The filenames above will change depending on the exact service pack and patch level available, I would usually recommend using the latest and greatest when possible.

Now that you have downloaded the 4 files, you only need to extract the EXTAPPSER00P_71-70001316.SAR, leave the .zip files whole.

sapcar -xvf EXTAPPSER00P_71-70001316.SAR

To install XSA you should place these files within the parent directory tree of the original HANA media (usually called SAP_HANA_DATABASE).

I now have the following structure

/hana/media/SAP_HANA_DATABASE
/hana/media/xsa/package
/hana/media/XSACHRTT03_62-70002322.ZIP
/hana/media/XSACMONITORING01_0-70002324.ZIP
/hana/media/XSACSAPWEBIDE02_6-80002257.ZIP

I can then execute the hdblcm command below and it finds all the previously downloaded packages.

/hana/media/SAP_HANA_DATABASE/hdblcm
/hana/media # SAP_HANA_DATABASE/hdblcm

SAP HANA Lifecycle Management - SAP HANA Database 2.00.023.00.1513691289
************************************************************************

Scanning software locations...
Detected components:
    SAP HANA Database (2.00.023.00.1513691289) in /hana/media/SAP_HANA_DATABASE/server
    SAP HANA XS Advanced Runtime (1.0.71.299115) in /hana/media/xsa/packages
    SAP HANA tools for accessing catalog content, data preview, SQL console, etc. (2.003.62) in /hana/media/XSACHRTT03_62-70002322.ZIP
    XS Monitoring 1 (1.005.8) in /hana/media/XSACMONITORING01_0-70002324.ZIP
    SAP Web IDE Web Client (4.002.6) in /hana/media/XSACSAPWEBIDE02_6-80002257.ZIP


Choose an action

  Index | Action             | Description
  ------------------------------------------------------------------------------------------------------------------------
  1     | IH2 (update)       | 2.00.023.00.1513691289
        |                    | mo-3fda111e5.mo.sap.corp (Database Worker (worker), XS Advanced Runtime Worker (xs_worker))
        |                    | 
  2     | install            | Install new system
  3     | extract_components | Extract components
  4     | Exit (do nothing)  | 

Enter selected action index [4]: 1


Choose components to be installed or updated:

  Index | Components | Description
  -------------------------------------------------------------------------------------------------------------------
  1     | all        | All components
  2     | server     | Update SAP HANA Database from version 2.00.023.00.1513691289 to version 2.00.023.00.1513691289
  3     | xs         | Update SAP HANA XS Advanced Runtime from version 1.0.71.299115 to version 1.0.71.299115

Enter comma-separated list of the selected indices [1]: 3
Retrieving Organization Name For Space "SAP" ...
Retrieving XS Advanced Admin User ...
Retrieving XS Runtime Database Name ...
Enter System Administrator (ih2adm) Password: 
Enter System Database User Name [SYSTEM]: 
Enter System Database User (SYSTEM) Password: 
Enter Organization Name For Space "SAP" [orgname]: 
Enter XS Advanced Admin User [XSA_ADMIN]: 
Enter XS Advanced Admin User Password: 

Choose XS Advanced components to be installed or updated:

  Index | XS Advanced Components | Description
  -------------------------------------------------------------------------------------------------------------------------------------------------------------
  1     | all                    | All components
  2     | none                   | No components
  3     | xsac_hrtt              | Update SAP HANA tools for accessing catalog content, data preview, SQL console, etc. from version 2.3.62 to version 2.003.62
  4     | xsac_monitoring        | Update XS Monitoring 1 from version 1.5.8 to version 1.005.8
  5     | xsac_sap_web_ide       | Update SAP Web IDE Web Client from version 4.2.6 to version 4.002.6

Enter comma-separated list of the selected indices [3,4,5]: 

When I ran the command above I had already installed XSA and the XSA Apps (zip files).
If you look closely there’s an issue with the versioning, an extra 00 being inserted.  The version installed is the same as the version in the .zip files.

Once installed we can go to your URL similar to https://mo-3fda111e5.mo.sap.corp:30030/ to see the various ports each XSA app is running on.

There an alternative way to manage and install XSA apps such as the WebIDE.  They can be installed with the xs client, from either the HANA server or a desktop machine.  I won’t cover all the apps here, but you can see the main syntax below.

LONM60272984A:bin i049374$ ./xs login -a https://mo-3fda111e5.mo.sap.corp:30030/ --skip-ssl-validation 

API_URL: https://mo-3fda111e5.mo.sap.corp:30030/
The authenticity of host 'mo-3fda111e5.mo.sap.corp' is not validated!
USERNAME> XSA_ADMIN
PASSWORD> 
Authenticating...
ORG: orgname

Existing spaces: 
0.	PROD
1.	SAP
SPACE> 1
SPACE: SAP
API endpoint:   https://mo-3fda111e5.mo.sap.corp:30030/ (API version: 1)
User:           XSA_ADMIN
Org:            orgname
Space:          SAP

LONM60272984A:bin i049374$ ./xs install ~/Downloads/XSACPORTALSERV02_0-80002098.ZIP

Running installation in org "orgname" / space "SAP" as XSA_ADMIN...
File upload starts...
Upload into container starts...
Container ID: ba8ee8b7-f451-45c9-a5dd-ad4a7e972c0f
                     
Software Component   
-------------------------------------
name                 XSAC_PORTAL_SERV
vendor               sap.com
version              1.2.0
-------------------------------------

Upload into container finished successfully
Validation starts...
Summary of what will be installed:
Software component XSAC_PORTAL_SERV (sap.com) 1.2.0
Validation finished successfully

Hopefully this gives you a quick guide to getting XSA and WebIDE installed.
This is just my experience, you should also refer to the official documentation.

Official SAP Help – Installing SAP Web IDE

10 Comments
You must be Logged on to comment or reply to a post.
  • Hi Ian,

     

    Thanks for the detailed blog, I am facing below issue during hana runtime tools installtion.

     

    XSACHRTT04_54-70002322.ZIP      SP04 Patch54 for SAP HANA RUNTIME TOOLS 2.0

     

    xs install /hana/log/webide/XSACHRTT04_54-70002322.ZIP

    Running installation in org “orgname” / space “SAP” as XSA_ADMIN…

    Installation failed.
    ERR com.sap.cloud.lm.sl.slp.client.communication.NotFoundException: Not Found

     

    Could you please help me here.

     

    Thanks and Regards

    Sampath R.

  • Hi Sampath,

    I have not seen this error before, but you can check to see what packages/services are currently installed with the command below.

    ./xs s
    ./xs space SAP

    If you see HRTT you can then try to remove it.

     

  • Hello Ian,

     

    We upgraded our Hana DB to hana2sp03. Our Web IDE is still 10 version. If we can upgrade Web IDE to 2.0 without having to install XSA please ? I mean if Web IDE can be upgraded to 2.0 with XS Classic please ?

     

    Thanks

     

    • Hi Hari,

      No, this is not possible the new WebIDE requires XSA.  You still have the old XS Classic (XSC) one and can continue to use it, but we would recommend switching over to XSA whenever possible.

      We do not replace or remove the XSC WebIDE, both can co-exist happily.

  • Hi Ian

    Thank you for the great post.

    Recently I did updated the Webide on HANA 2.0 SPS03 (xs v1.0.82) environment and i used the following installation commands to update it.

    xs install XSACHRTT07_33-70002322.ZIP       –> executed successfully.

    xs install XSACSAPWEBIDE03_7-80002257.ZIP –e sap-xsac-devx.mtaext  –> executed successfully.

    with this we are able to update HRTT from Version: 2.5.36 to  Version: 2.7.33 and WebIDE from 4.3.23 to 4.3.33

    we downloaded the mta file from 2510063 – SAP Web IDE for SAP HANA 2.0 SPS 03 – Central Release Note

    even though there were no issues reported with the above two statements we are not able to load WebIDE and not able to see the SPACE in “di-space-enablement-ui” of XSA.

    appreciate if you have any recommendations or quick tips here.

    Thanks in advance

    kishore

     

      • Hi Satyabrat

        I was able to fix the WebIDE issues by restarting the di-core with the following commands

        xs restage di-core

        xs restart di-core

        where as di-core was not running after updating the WebIDE, no where it was updating the logs regarding the di-core , I did a  manual validation.

         

        note:-

        HRTT has a dependency with WEBIDE. HRTT 2.6.xx is the corresponding version for WEBIDE SPS03 and the minimum version for WEBIDE 4.3.33 is 2.6.62. You can fine the minimum recommended version of HRTT for SPS03 WEBIDE 4.3.33: note 2510063.

        you can downgrade HRTT by uninstalling it and reinstalling the correct version again if any mismatch.

        xs uninstall XSAC_HRTT

        xs install XSACHRTT06_62-70002322.ZIP

        If the problem remains then reinstall WEBIDE and install it again:

        xs uninstall XSAC_SAP_WEB_IDE

        xs install <webide zip file>

         

        hope these options might help you.

         

        Regards

        Kishore

         

  • Hi Ian,

    I did followed the installation steps as per your guidance for XSA , however was struck with error Directory ” ” doest exist. did many times installation and uninstallation back and forth with no luck. Can you please let me if you have any solution for this? Please find the log for your reference. it quits with this error Assigning Additional Roles to the Local Host failed

     

    23:35:40.608 – INFO: Output line 1:
    23:35:40.609 – INFO: Output line 2:
    23:35:40.609 – INFO: Output line 3: SAP HANA Lifecycle Management – hdbmodify_addlocalroles 2.3.57
    23:35:40.609 – INFO: Output line 4: ***************************************************************
    23:35:40.609 – INFO: Output line 5:
    23:35:40.610 – INFO: Output line 6: Reconfiguring SAP HANA system failed!
    23:35:40.610 – INFO: Output line 7: Running in batch mode
    23:35:40.610 – INFO: Output line 8: Directory ” does not exist
    23:35:40.611 – INFO: Output line 9:
    23:35:40.766 – INFO: Program terminated with exit code 1
    23:35:40.767 – INFO: ———————————————————–
    23:35:40.767 – INFO: END: Assign Additional Roles to the Local Host failed (start: 23:35:38.421 duration: 00:00:02)
    23:35:40.767 – INFO: ———————————————————–
    23:35:40.768 – INFO: Assigning Additional Roles to the Local Host failed
    23:35:40.781 – INFO: Execution Summary:
    23:35:40.781 – INFO:
    23:35:40.782 – INFO: Step Name | Runtime
    23:35:40.782 – INFO: ————————————————————————
    23:35:40.782 – INFO: Installing SAP HANA XS Advanced Runtime | 00:03:31
    23:35:40.782 – INFO: Assigning Additional Roles to the Local Host | 00:00:02
    23:35:40.782 – INFO: Updating SAP HANA Database Instance Integration on Local Host | n/a
    23:35:40.782 – INFO: Updating Component List | n/a
    23:35:40.782 – INFO: Installing XS Advanced Components | n/a
    23:35:40.782 – INFO:
    23:35:40.784 – ERR : Update of SAP HANA Database components failed.
    23:35:40.784 – INFO: Summary of critical errors
    23:35:40.784 – ERR : Update of SAP HANA Database components failed.
    23:35:40.767 – ERR : Assigning Additional Roles to the Local Host failed

      • Hi Ian,

         

        I just executed ./hdblcm from command level from installation media and facing this issue. Also tried ./hdblcmgui and getting same error during installation. LCM will complete the intallation first step and while adding Additional Roles XS_WORKER to host it will through an error Directory ” doesnt exist. I also gave the trace to find a clue if it really looks for any directory. I havent found any as such specifying the same. But i can see something specifying about sapmnt.

        Parameter ‘sapmnt’ (Target) is set with default value = ‘<not defined>’

         

        Please find the log for your reference.

         

        17:01:53.444 – INFO: Starting external program /sbin/ip
        17:01:53.444 – INFO: Command line is: /sbin/ip addr
        17:01:53.452 – INFO: Output line 1: 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
        17:01:53.452 – INFO: Output line 2: link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
        17:01:53.452 – INFO: Output line 3: inet 127.0.0.1/8 scope host lo
        17:01:53.452 – INFO: Output line 4: valid_lft forever preferred_lft forever
        17:01:53.453 – INFO: Output line 5: inet6 ::1/128 scope host
        17:01:53.453 – INFO: Output line 6: valid_lft forever preferred_lft forever
        17:01:53.453 – INFO: Output line 7: 2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
        17:01:53.453 – INFO: Output line 8: link/ether 00:0c:29:7f:9c:7e brd ff:ff:ff:ff:ff:ff
        17:01:53.453 – INFO: Output line 9: inet 192.168.29.189/24 brd 192.168.29.255 scope global eth0
        17:01:53.453 – INFO: Output line 10: valid_lft forever preferred_lft forever
        17:01:53.453 – INFO: Output line 11: inet6 2405:201:d801:878c:e1f5:2681:5031:4540/64 scope global temporary deprecated dynamic
        17:01:53.453 – INFO: Output line 12: valid_lft 2229sec preferred_lft 0sec
        17:01:53.453 – INFO: Output line 13: inet6 2405:201:d801:878c:20c:29ff:fe7f:9c7e/64 scope global mngtmpaddr dynamic
        17:01:53.454 – INFO: Output line 14: valid_lft 2229sec preferred_lft 2229sec
        17:01:53.454 – INFO: Output line 15: inet6 fe80::20c:29ff:fe7f:9c7e/64 scope link
        17:01:53.454 – INFO: Output line 16: valid_lft forever preferred_lft forever
        17:01:53.454 – INFO: Program terminated with exit code 0
        17:01:53.455 – INFO:

        SAP HANA Lifecycle Management – hdbmodify_addlocalroles 2.3.57
        ***************************************************************

        17:01:53.456 – INFO: Start Date: 2019-03-20 – hdbmodify 0032
        17:01:53.456 – INFO: Log File ID: hdbmodify_2019-03-20_17.01.51_22702
        17:01:53.456 – INFO: Checking configuration
        17:01:53.457 – INFO: Parameter ‘sapmnt’ (Target) is set with default value = ‘<not defined>’
        17:01:53.457 – ERR : Directory ” does not exist
        17:01:53.457 – ERR : Running in batch mode
        17:01:53.458 – ERR : Reconfiguring SAP HANA system failed!
        17:01:53.459 – INFO: Summary of critical errors