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.SARTo 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.ZIPI 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.
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.
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 Web Developer Workbench, both can co-exist happily.
Ian:
Thank you.
Couple of questions:
1. In an HANA Express edition, some installations does not have XS Classic enabled.
How do we enable XS Classic?
2. What is the roadmap of XS Classic and XS Advance? This will help determine when to move from XS Classic to XS Advance .
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
Hello Kishore,
have finished with your installation could you please share the steps done make WEBIDE work.
Thanks,
Satyabrat
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 Kamal,
I haven’t seen this one before.
What command had you executed?
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
Hello Lan,
Thanks in advance.
Is these below files are avialable in sap hana 2.0 sp3.. my admin not able to getting the below files from sap market palce .
one of my admin saying these files supports to SP1 and SP2 and SP4 not to SP3 .. is it ture ?
present we are using HANA 2.0 SP3 hana license but getting only few below urls not able to get WEBIDE URL...can you plesse help me on this.
The link below provides a support matrix of components that are valid for the latest XSA release.
It shows that we support database versions from HANA 1.0 SPS12 to HANA 2.0 SPS4
https://help.sap.com/viewer/292437fbf7794e2cb0d323b19a38285c/SAPWEBIDE4HANA/en-US/eccdec81540042089d0a84127fe20920.html
I did check and could not see a specific SPS3 release available anymore, I expect that the latest version should be used.
Hello,
If you need to access the WebIDE, you need to upgrade the XS Engine at least to 1.0.119 in order to install HRTT version 2.11.52 and then be able to install the WebIDE version 4.4.6 that has technical version 4.4.18. Please refer to the documentation here:
https://help.sap.com/viewer/292437fbf7794e2cb0d323b19a38285c/SAPWEBIDE4HANA/en-US/eccdec81540042089d0a84127fe20920.html
Note: If you need to keep the existing version of XS Engine which is 1.0.88, then you need the following installed:
XSA HRTT: 2.5.xx
WebIDE version: 4.3.7xx
The problem is 2.5.xx is a very old version.
I hope this helps...
Thx
Hello, Ian. If you still monitor this post perhaps you can help me. Following your instructions, I downloaded the following files near SAP_HANA_DATABASE:
extracted the .SAR file near the archive and ran SAP_HANA_DATABASE/hdblcm. But it failed to detect all the components, finding only two:
Have you an idea how I can determine why it did not detect the components in the .ZIP files?
Hi Anton,
Can you share your current directory structure?
You can install the XS Advanced Runtime and then install the apps (zips) afterwards.
Thank you for the reply, Ian.
You say I can install the zipped components separately—but how? Here are the files in my directory, with my comments after a hash character:
And I try to install the applications by invoking:
It prints:
So it fails to detect the components inside the zip archives.
When I choose 1, it offers:
As you see, there is no xs option, as in your case, and I am stuck.
On the other hand, if I remove the contents of the XSA runtime from the directory, and rerun hdblcm, it does detect the other three components:
But when I choose NDB (update) it again fails to list these components, and I am stuck again.
You wrote that knowing exactly which files are required can be tricky. Can it be that I have the wrong versions? If so, how can I find the right ones?
Hi Anton,
I would first try extracting the EXTAPPSER00P_101-70001316.SAR into a sub-directory.
I don't expect it is a version issue as the installer is not checking those dependencies just yet.
Here's the matrix of software components. https://help.sap.com/viewer/292437fbf7794e2cb0d323b19a38285c/SAPWEBIDE4HANA/en-US/eccdec81540042089d0a84127fe20920.html
You can install the zips manually with the xs client (xs install), once you have installed the main XSA server component. There's an example of that command near the end of the blogpost.
What am I to do after extracting the XSA archive into a subdirectory—specify that subdirectory in hdblcm as an additional component location?
Anyway, a version of XSA is already installed in my system. I can even login to a webpage titled HANA XS Advanced Runtime on premise, so updating the runtime is not very urgent. When, however, I try to install those additional ZIP components with:
it fails with a JavaScript exception:
It is not very polite thus to throw raw unhandled exceptions at the user. Shall I report it this to SAP support, or can you help me with it?
Trying to obtain a list of components with fails with a similar exception.
are there any WebIDE tutorials created before today not relevant to the trial account unless coming with a disclaimer that it is only working in production accounts?
if this blog post was never relevant to trial accounts just ignore my comment.
this is not meant as a April Fools' joke, but
cheers.
greg
Hi Greg,
This blog was for on-premise XSA and not the BTP / SAP Cloud Platform WebIDE.
The SAP Business Application Studio would be the recommended tool for all accounts now.
Cheers, Ian.
Hi Ian,
Can you elaborate on where XSA and WebIDE should be installed? e.g. in a three tier on-premise landscape with a HANA Cockpit "on top".
Thank you!
BR
Bjarke
Why do you require that everything be done in the directory of the HANA media? The XSA distribution includes its own copy of hdblcm. Is it inadequate for the task?
Hi Anton,
This was just my experience back in 2018. The installer I was using wouldn't identify the zips.
Maybe that has improved now?
Probably. With the latest version, I can easily install XSA with the following invocation:
where xsadistr_path is the location of the extracted .SAR file with the main XSA distribution. In order then to install such XSA components as Runtime Tools and WebIDE, I used:
with the original ZIP files downloaded from SAP.
Hello,
how to check exact version of HRTT and WEBIDE?
Hi Ian,
thank you for this great blog! Exactly what I needed!
Best Regards,
Hannes