Friday, 12 October 2018

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  
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.

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA WebIDE

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.

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA WebIDE

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 1.2.0
Validation finished successfully

No comments:

Post a Comment