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
1.19 Updated section 0

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

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&putty.png

      • 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+:

/wp-content/uploads/2014/06/imdb_ls_1_21_609551.png

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

  • Lumira Server v1.17-1.20:

prepare 01.png

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:

prepare+02.1.png

And also prepare other required components:

  • For Lumira Server v1.21+:

prepareUAFL.png

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:

prepare+02.2.png

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:
/wp-content/uploads/2014/06/01_m_486145.png

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

/wp-content/uploads/2014/06/02_486177.gif

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“: /wp-content/uploads/2014/06/05_486178.gif
  • 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:

/wp-content/uploads/2014/06/07_486252.gif

Next is to select the required components:

  • For Lumira Server v1.21+:

/wp-content/uploads/2014/06/components_v122_selected_630889.png

  • For Lumira Server v1.17-1.20:

/wp-content/uploads/2014/06/08_486254.gif

/wp-content/uploads/2014/06/09_486255.gif

/wp-content/uploads/2014/06/10_486256.gif

/wp-content/uploads/2014/06/11_486257.gif

/wp-content/uploads/2014/06/12_486258.gif

/wp-content/uploads/2014/06/13_486259.gif

/wp-content/uploads/2014/06/14_486260.gif

/wp-content/uploads/2014/06/15_486261.gif

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 <SID>adm <instance> host, e.g.:

deploy-UAFL.png

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: http://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:

u prepare afl.gif

Run script hdblcmgui:

/wp-content/uploads/2014/06/01_m_486145.png

Click “Add Component Location” button in below screen:

/wp-content/uploads/2014/06/02_486177.gif

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

/wp-content/uploads/2014/06/05_486178.gif

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

/wp-content/uploads/2014/06/u4_486269.gif

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

/wp-content/uploads/2014/06/u5_486270.gif

Select all required components:

/wp-content/uploads/2014/06/u6_486271.gif

/wp-content/uploads/2014/06/10_486256.gif

/wp-content/uploads/2014/06/u8_486272.gif

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:

/wp-content/uploads/2014/06/install_lifecyclemanager_486339.gif

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):

/wp-content/uploads/2014/06/lm_role_609480.png

  • Download and save Lumira Server zip file to a temporary location, e.g. C:\tmp\51049111.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 Files\sap\hdbclient:

CmdAsAdministrator.png

  • Run hdbalm.bat -u user -h host -p 8000 install <path to Lumira Server zip file>:

/wp-content/uploads/2014/06/halm_609450.png

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

To report this post you need to login first.

6 Comments

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

  1. Suneet Agera

    Hi Xing,

    I installed a Lumira Server but faced errors during visualization: command not found: aom. Checking around I found this is because the UA AFL is not installed.

    Tried following the instructions above to install the Universal Analytics AFL 1.0.
    Right now, on the SAP Service Marketplace Support Packages and Patches page, only a file is available under

    There is nothing under

    Also the file is a SAR file, not a zip.

    NETTUAFL302_1-80000558.SAR

    When this is un-sared using SAPCAR, no file called afldeploy is there. There is only a aflundeploy and a file called hdbinst.

    I am not clear from the post above how to run hdbinst. I tried

    ./hdbinst –hlm_archive=/IMDB/NETTUAFL302_1-80000558.SAR

    But got an error.

    Any suggestions?

    Regards

    Suneet

    (0) 
    1. Xing Jin Post author

      Hi Suneet,

      The SAR file you found is the correct one and Yes you need to extract the SAR file into a folder.  Before install the UAFL, ensure the HANA system doesn’t have SAL AFL as they conflict with each other.

      To install/upgrade the UAFL on top of an existing HANA, you can choose either of below methods:

      1. Use the UAFL supplied hdbinst, for example:

      • mkdir /IMDB/NETTUAFL302_1-80000558
      • cd /IMDB/NETTUAFL302_1-80000558
      • ../SAPCAR -xvf ../NETTUAFL302_1-80000558.SAR
      • ./hdbinst
      • The installer runs and prompts “Enter SAP HANA System ID: “
      • If you answer correctly, the installer will install the package, stop HANA system, activate the plugins, restart the HANA system. In the end you should see “Installation done”

      2. Use the original HANA DB installer’s hdblcmgui (by which the HANA DB was installed), for example:

      • mkdir /IMDB/NETTUAFL302_1-80000558
      • cd /IMDB/NETTUAFL302_1-80000558
      • ../SAPCAR -xvf ../NETTUAFL302_1-80000558.SAR
      • cd /IMDB/IMDB_SERVER100_85_0/SAP_HANA_DATABASE
      • ./hdblcmgui
      • click “Add Component Location” button, and then choose the exact directory where the UAFL was extracted, i.e. /IMDB/NETTUAFL302_1-80000558
      • Select option “Search for components in subfolders
      • The installer should be able to detect the UAFL software package.
      • If yes, continue the installation. You can reference the screenshots in section 3.1 and 3.2.

      The afldeploy tool you mentioned only exists in older version of UAFL which packaged as a .zip file.

      B.R.,

      `xing

      (0) 
      1. Suneet Agera

        Hello Xing,

        Thanks for your reply.

        I followed your steps and installed the UAFL using the command ./hdbinst

        The installation happened very fast (which surprised me). The installation did not restart the HANA DB, so I restarted it manually by logging in as hdbadm.

        However, I still faced the error in my Lumira server visualization suggesting that UAFL actually did not get installed.

        https://www.dropbox.com/s/w3rciui3m2zbfj9/1.jpg?dl=0

        So, as per the appendix section of Preflight Checklist for Installing Lumira Server , I go to check if UAFL is installed as a plugin and of course, its not!

        https://www.dropbox.com/s/p73l3bq7ktcoll0/2.jpg?dl=0

        Last of all, just to be sure, I go again to install the UAFL, and when installing I get a message that the installation is up to date.

        https://www.dropbox.com/s/1yr6rm8sabt2pz5/3.jpg?dl=0

        Any suggestions, what could be going wrong here?

        Greatly appreciate your response.

        Regards

        Suneet

        P.S. Posted links as the scn did not allow me to post embed images in this post for some wierd reason.

        (0) 
        1. Xing Jin Post author

          Hi Suneet,

          Which HANA revision are you based on? From one of your screenshots it seems you are probably on Rev. 80.  The UAFL v1.301/1.302 requires Rev. 82 or higher – please take a look at this sap note (which is accessible at UAFL’s download page via the Info link):

          If the Rev. # is not an issue, I found there is a SCN thread which exposes similar error screen:

          B.R.,

          `xing

          (0) 
          1. Suneet Agera

            Hello Xing,

            Thanks a lot! Bang on, looks like I missed the HANA revision part.

            We have been working with Rev. 80. I guess we have to upgrade to Rev 80+, or we need to use SAP AFL instead of UAFL.

            Thanks for your support. We will keep you posted.

            Regards

            Suneet

            (0) 
          2. Suneet Agera

            Hello Xing,

            I used a HANA server of revision 90, HANA Studio 2.0.2, SAP Universal Analytics AFL 1.0 (1.304), and Lumira Server 1.25. The installation went as a dream. Thank you so much for your help.

            To check if Lumira Server is working, I tried launching http://<myhanaserverIP:8000/sap/bi/launchpad and it opened and displayed the analytic views that were created in the HANA system. But when I click on any of them, it goes to the Visualize tab, and takes a very long time to load anything and ultimately gives a message saying Internal Server Error, with only a Close button for user interaction.

            Any way to debug further?

            Regards

            Suneet

            (0) 

Leave a Reply