In this blog I am going to show how I prepare a HANA system before installing a Lumira Server on top.

Note: this HANA system is only used as my sandbox for test purpose and is not intended for production environment use because many other important aspects, such as performance, sizing, clustering, etc., are not considered in this blog.

0. Latest Update

Lumira Version Blog Change History Highlights
1.22 Updated section 0, 2, 3.1
  • There is no fundamental change for the server install workflow from previous version.
  • However, one small change is the new way to deploy UAFL.
1.21 Updated section 0, 2, 3, 4, 5

There are two major changes in this release:

  • UAFL is to replace SAL AFL
  • HALM is to replace HLM (SAP HANA Lifecycle Manager) to deploy Lumira Server

Note: SAL AFL and HLM are still supported in this release but ONLY UP TO THIS RELEASE.  They are kept for one more release for upgraded scenario consideration.

1.20 Updated section 0
  • There is no fundamental change for the Lumira 1.20 server install workflow
  • Lumira 1.20 requires an updated list of SAP HANA components – detailed in 7.D. Preflight Checklist for Installing Lumira Server
1.19 Updated section 0

There is no fundamental change for the Lumira 1.19 server install workflow.  However, there are a few changes:

  • Lumira 1.19 requires an updated list of SAP HANA components – detailed in 7.D. Preflight Checklist for Installing Lumira Server
  • Lumira 1.19 no longer requires a version downgrade for the SAP UI5.
1.18 Added section 5.1

There is no fundamental change for the Lumira 1.18 server install workflow.  However, there are a few changes:

  • Lumira 1.18 requires an updated list of SAP HANA components – detailed in 7.D. Preflight Checklist for Installing Lumira Server
  • Lumira 1.18 requires a version downgrade for the SAP UI5 component that is shipped with SAP HANA rev. 81 – detailed in section 5.1.
1.17 Original post

1. Get My Systems and Utilities Ready

In the system landscape of this blog, I have two boxes:

  • A SUSE Linux 11 SP1 box
    • In the box, I have installed:
      • SAPCAR – a SAR file archiver and compressor

Warning: This is important. Please use the latest version of SAPCAR (e.g. release 720). If an older version of SAPCAR is used (e.g. release 700), SAP HANA Lifecycle Manager may throw wierd errors, e.g. “verification of manifest /usr/sap/hostctrl/work/SIGNATURE.SMF failed” because older versions couldn’t properly extract SIGNATURE.SMF files from .SAR files.

    • And I am going to install a HANA database server and all required components by Lumira Server on the box
  • A Windows box
    • In the box, I have installed:
      • PuTTy – a terminal emulator. X11 forwarding is configured to work with PuTTy:

      • Xming – an X11 display server.
    • And I am going to install a HANA studio and a HANA client on the box

ℹ Refer to 7.A and 7.B for detailed information on SAP HANA and SAP LUMIRA hardware and software requirements.

ℹ Refer to 7.C for detailed information on a short guide to SAPCAR.

2. Prepare Software Packages

7.D. Preflight Checklist for Installing Lumira Server lists all SAP software components required for installing Lumira Server.

Depending on if there’s an existing HANA database server and what components have already been available on that HANA, some components may not be required. For this blog, I have a few different scenarios, so I downloadedall the required components listed.

To make it simple, I created a subdirectory /IMDB on my Linux box as a working folder, and then transferred them into /IMDB:

  • For Lumira Server v1.21+:

Note: The UAFL (i.e. NETTUAFL…) may be packaged in either zip or SAR file.

  • Lumira Server v1.17-1.20:

The downloaded .tar and .SAR files won’t be recognized and used until they are properly prepared.  To prepare the downloaded HANA database server files:

And also prepare other required components:

  • For Lumira Server v1.21+:

Note: If the UAFL is packaged as a SAR file, use “SAPCAR” to extract the file instead of “unzip”, e.g.:

../SAPCAR -xvf ../NETTUAFL301_0-70000202.SAR

  • For Lumira Server v1.17-1.20:

Note: The SAP HANA Lifecycle Manager SAR file is also copied into the extracted folder.

3. Install HANA and Required Components

As the first step, I installed HANA Studio and HANA Client on my Windows box.  This installation is very straightforward so I am not going to say too much about it.  Please refer to SAP HANA Studio Installation and Update Guide and SAP HANA Client Installation and Update Guide available from 7.G.SAP HANA Platform – SAP Help Portal Page

Next, I have a few choices to prepare HANA on my Linux box:

  • Fresh Install – It utilizes the hdblcm(gui) script to install SAP HANA and all required components in one installation.
  • Incremental Install and Upgrade Install – They also utilize the hdblcm(gui) script but either to install incrementally or to upgrade from a previous version of HANA.  Sometimes a fresh installation only partially succeeded.  After troubleshooting, an incremental install could be performed to correct the installation.
  • Incremental Install via hdbsetup/hdbinst – Those scripts is the old ways to install HANA.  Special consideration should be given to SAP HOST AGENT.

3.1 Fresh Install

HANA provides several scripts for installation. hdblcm is a text only version of hdblcmgui while hdblcmgui is the most convenient way of install although an X11 display server is required on my Windows box.

Run script hdblcmgui:

If the X11 display server and PuTTY are configured properly, after a HANA splash screen, below screen is prompted:

Click “Add Component Location” button, and then choose the directory where the downloaded software packages are extracted and prepared (for example, /IMDB):

  • Select option “Search for components in subfolders“:
  • Make sure all required components are shown:
    • Lumira Server 1.21+:
      • SAP HANA Database
      • Universal Analytics Function Library – Note: Universal Analytics Function Library (UAFL) v 1.300 (released for Lumira v1.21) is packaged in a zip file which may not be shown up here. Therefore, an extra manual step is required to install UAFL v 1.300, which is described below near the end of section 3.1.
    • Lumira Server 1.17-1.20:
      • SAP HANA Database
      • SAP SAL AFL FOR HANA
      • SAP HANA Lifecycle Manager

Now select to install new system:

Next is to select the required components:

  • For Lumira Server v1.21+:

  • For Lumira Server v1.17-1.20:

Click “Install” button in the Review and Confirm screen. Once the installation is done, a message “installation finished successfully” is prompted.

[Note: Below part is only for UAFL that is packaged in a zip file (e.g. UAFL v1.300 with Lumira Server v1.21)]

If a UAFL is required but couldn’t be installed in the previous steps (this happens when, for example, UAFL v1.300 is packaged in a zip file), it is time to deploy the UAFL component manually through a command line. Run ./afldeploy sal adm host, e.g.:

To verify the UAFL is installed successfully, from HANA Studio, right click on the instance, then select “Configuration and Monitoring” -> “Open Administration”.  “SAP_AFL_SDK_UAL” should be listed besides “Installed Plug-ins”.  Refer to this screenshot: https://scn.sap.com/servlet/JiveServlet/showImage/102-56111-6-609449/check-uafl.png

3.2 Incremental Install and Upgrade Install

ℹ Helpful information for upgrading to v1.21
One important thing is to know SAL AFL and UAFL cannot co-exist.  Although SAL AFL and HLM are still supported in v1.21, they probably will not be supported in v1.22.  Sooner or later, migrating from SAL AFL to UAFL is necessary. Then the desired sequence is to uninstall SAL AFL first before installing UAFL.

The steps of incremental install (e.g. install HANA database server first and then install other components) and upgrade install (i.e. upgrade from an older version of HANA system) are similar.  The only difference is that, with upgrade install, I need to upgrade other plugin components as well, even if they are not required by Lumira Server.

To illustrate this, in below example, I have a HANA r72 with a plugin HANA AFL (which is not required by Lumira Server) installed.  I will perform an upgrade install to upgrade the system to HANA r80 with all required components for Lumira Server 1.17.

Because the HANA AFL plugin component in HANA r72 won’t work on HANA r80, I need to download a newer version of HANA AFL, transfer, and prepare it in the working folder /IMDB along with other required components:

Run script hdblcmgui:

Click “Add Component Location” button in below screen:

Choose the directory where the downloaded software packages are extracted and prepared (see part 2), then select option “Search for components in subfolders“:

Below screen shows the minimum required component list for Lumira Server 1.17 plus SAP HANA AFL:

Select “Update existing system” and choose the target system:

Select all required components:

Click “Update” button in the Review and Confirm screen to finish. Once it is done, a message “update finished successfully” is prompted.

3.3 Incremental Install via hdbsetup/hdbinst

If an existing HANA database server is installed through the hdbsetup/hdbinst scripts, special consideration should be given to SAP HOST AGENT when an incremental install is needed.

Unlike the hdblcm/hdblcmgui scripts, the hdbsetup/hdbinst scripts didn’t install SAP HOST AGENT when a HANA database server is installed.  Therefore, if there’s no existing SAP HOST AGENT on the system, I have to install a SAP HOST AGENT.

Below screen shows how I perform an incremental install of SAP HANA Lifecycle Manager on an existing HANA database server where I also have to install a copy of SAP HOST AGENT:

Note: I found the install succeeded even there’s an error message – “chmod: invalid mode: ‘493’”.

Once I have installed SAP HANA Lifecycle Manager and SAP HOST AGENT, I could further install other required components by Lumira Server with hdbsetup/hdbinst scripts.

4. Verify Required Prerequisite Components

Please check out Appendix: Check If a Product or Component Has Been Installed, Preflight Checklist for Installing Lumira Server.

5. Next Step

5.1 [For Lumira 1.18 + SAP HANA rev. 81 Only] Downgrade SAP UI5

The version of the SAP UI5 component that is shipped with SAP HANA rev. 81 (SAP UI5 v1.22) is incompatible with the SAP Fiori launchpad component from Lumira Server 1.18.  A downgrade to v1.20.6 is required in order to use the SAP Fiori launchpad.  To downgrade, follow the instructions attached in SAP Note 2044187 – SAP Lumira Server 1.18: Downgrade UI5 Instructions which is also summarized here:

  • Extract the downloaded .zip file and locate the .tgz file (SAPUI5_1-1.20.6.tgz).
  • In SAP HANA Studio, click File -> Import -> SAP HANA Content -> Delivery Unit
  • Select the correct HANA instance
  • Select the extracted .tgz file then click Next and Finish buttons to proceed
  • Once the import job is done, open SQL console and run select * from _sys_repo.delivery_units to verify the downgrade.  E.g. SAPUI5_1, VERSION=1, VERSION_SP=20, VERSION_PATCH=6.

5.2 Deploy Lumira Server

Once all required components have been installed and verified, it’s ready to deploy and configure Lumira Server.

For Lumira Server v1.21 and above, HALM is the official way to deploy Lumira Server.  The support of SAP HANA Lifecycle Manager is going to be deprecated soon.  The way to use HALM is quite simple:

  • In HANA Studio, assign role ‘sap.hana.xs.lm.roles::Administrator’ to the user to be used in hdbalm command (e.g. user ‘SYSTEM’ is used in below example):

  • Download and save Lumira Server zip file to a temporary location, e.g. C: mp51049111.zip
  • Make sure HANA Client is installed, e.g. to the default location.
  • Open Command Prompt as administrator and CD to the path where HANA Client is installed, e.g. C:Program Filessaphdbclient:

  • Run hdbalm.bat -u user -h host -p 8000 install :

For Lumira Server v1.20 and below, the SAP HANA Lifecycle Manager plays an important role for deploying Lumira Server.  As there are some excellent blogs about this next step already been posted on SCN, I am not going to repeat here. So please search onSAP BusinessObjects Lumira (e.g. such blogs are listed in 7.F. Update SAP Lumira Server 1.17 & New Features and 7.E How to install SAP Lumira Server, Publish Datasets and Stories both by M. van Foeken ).

For examples on configuring SAP Lumira Server, please also refer to 7.F. and 7.E.

6. Troubleshoot Error Messages

Due to the SCN blog attachment size limitation, I put this part in:

Prepare a HANA System for Lumira Server Install – Troubleshoot Error Messages

7. References

A. Product Availability Matrix (PAM) – SAP HANA Platform EDIT. 1.0

B. Product Availability Matrix (PAM) – SAP LUMIRA 1.0

C. List, Extract, Compress using SAPCAR

D. Preflight Checklist for Installing Lumira Server

E. How to install SAP Lumira Server, Publish Datasets and Stories by M. van Foeken

F. Update SAP Lumira Server 1.17 & New Features by M. van Foeken

G. SAP HANA Platform – SAP Help Portal Page

New NetWeaver Information at SAP.com

Very Helpfull

User Rating: Be the first one !