Please note SUM for SAP HANA is no longer support in SP6 and is replaced with HLM
My name is Man-Ted and I’m currently on the SAP HANA support team and I’ve been on the team since September 2012. Our team as a collective has been noticing a rise in a certain area of SAP HANA, SUM for SAP HANA. As part of my training for support I took it upon myself to learn and setup SUM for SAP HANA on our local environment. This blog will document the steps I did to setup our environment as well a walk through of the product along with troubleshooting one can do.
So what is SUM for SAP HANA?
SUM stands for Software Update Manager, this tool allows users to download and upgrade SAP HANA components through the SAP HANA Studio. SUM for SAP HANA was not available until SAP HANA SP3.
So does that mean I need SUM for SAP HANA to upgrade my HANA system?
SUM for SAP HANA is the only supported method for users to upgrade their SAP HANA system. Previously upgrades were done using hdbupd, but this only upgrades the system and not the system landscape metadata (lm_structure)
How do I get SUM?
SUM for SAP HANA will be pre-installed for users unless they had SAP HANA SPS02 as there was no SUM for SAP HANA during the SPS02 release.
You can verify if SUM for SAP HANA is installed on you system by checking if /usr/sap/<SID>/SUM exists.
There’s no SUM folder
If the SUM folder is not present you will have to install SUM for SAP HANA, to do this please follow SAP Note 1793303 (please note this note is for single node systems). The SAP Note has a script that will assist in installing LCM, SUM and your SAP Host Agent, but you must have SAPCAR and SAP HANA sever already installed on your system. The following will be the steps that I had to do for this script.
Have the following files downloaded from the SMP to you are going to installing SUM for SAP HANA, keep them in .SAR format (please note that if you have either LCM or SAP Host Agent already installed it’s fine the script will not install that component, but you will still need the SAR files present)
- SAP HANA Studio
- SAP Host Agent
- LM Structure
- SUM for SAP HANA
Download the script file from SAP Note 1793303, extract the download and place the above downloads into the script folder (the folder in the example below is named ‘install’) and edit the install.properties file in the folder, it will look like the following (please note that the italic text is only sample data)
#### User-defined parameters
# The SID of the system
# The instance number
## SAP HANA edition (HANA_Platform / HANA_EnterpriseEdit)
## Optional parameters
# SAPLOCALHOST as defined in system profiles
# If not set here, the script will try to detect it
# Path to SAPCAR
# If not set here, the script will try to find it
# Installation number
# Required for download from SMP
# Set it here, if not set in /usr/sap/<SID>/SYS/global/hdb/metadata/installation.properties
Once set run the install.sh script
To verify if the script went ok check to see if the following folders exist
How do I start SUM for SAP HANA?
So once you have SUM for SAP HANA setup properly your SAP HANA studio will always try to connect or start SUM. To start SUM for SAP HANA you need to enter in your key store password (this keystore was set during the installation of SUM for SAP HANA)
If it is running the screen will look like this
By default the keystore password has to be entered in each time before starting SUM/LCM, optionally a keystore file can be used. (A keystore file should only be used if the security on the file system that has SUM for SAP HANA installed can be trusted). To start SUM for SAP HANA execute ./sum.sh, it should look like the following:
If you are going to use a keystore file please read the below from documentation:
- Create a text file and name it catalina.properties.
- Store the password in there, using the content: keystore.password=****** (where ****** is the key store password).
- Save the file in directory <SUM_DIR>/config. (Make sure that this file is readable only by <SID>adm user)
So How Do I Use SUM for SAP HANA/Lifecycle Manager (LCM)?
First things first, how are we going to connect the Service Market place?
This portion is under the assumption you have already downloaded and configured SUM for SAP HANA and it is now running
Before loading the LCM we will need to set up how we will get checking for updates, please do the following before loading the LCM
Inside HANA Studio select Window-> Preferences
In the ‘Preferences’ Window you can select either stack.xml (you get this from the Software Download Center from the SMP) or you can enter in your SMP information.
In my example I will be using the SMP, select “Use SMP configuration” and enter in your S-user ID that you would use to download files from the SMP.
Now that the SMP information is setup Lifecycle Management can connect to the Service Market Place. (Please note, make sure that SUM for SAP HANA is already running or you have setup your keystore, refer to the ‘How do I start SUM for SAP HANA?’ section)
Right click on your System and select “Lifecycle Management” and the studio will either try to start or connect to the SUM for SAP HANA service.
During the initial load the LCM will check to see if there is a new revision of SUM for SAP HANA available, if there is no update login using the sapadm user:
Once in the LCM it should look like this:
As you can see from the above there are various options for users, here is a quick explanation of each option:
Apply Support Package Stack – This will update all the SAP products that are deployed on this system.
Apply Single Support Packages – This option allows users to select which specific SAP product and to which version (available on the SMP) they would like to up date
Deployment of HANA Content – Updates from a DVD zip on the local file system
SAP Service MarketPlace – This states that SUM for SAP HANA will connect to the SMP to download the patch update. After the file is downloaded the file will get unarchived and will install.
Downloaded content on HANA system – If the SAR file is already downloaded and on the system you would select this option and point to where the file is. After clicking next it will un-archive and install the patch.
After clicking next, LCM will check for updates
Once that’s done you should see the what new updates are available for your SAP HANA system. If there are no new updates you will see under “Target version” you will see “not available”
If there are updates you can now select if you would like your software
And you can pick and choose which products you would like update, in this case we only wanted to upgrade our SAP HANA database server:
After you click ‘Download’ a progress bar of the download will appear
Once the software is downloaded it will extract and install the product, if it is successful the following screen will appear:
SUMthing has failed me!
In this section I will discuss some errors you could encounter with SUM for SAP HANA
The first errors that may occur is when trying to load the LCM
This error indicates that the SUM for SAP HANA service is not running, to resolve this you can set up a keystore file or login to your system and start SUM for SAP HANA
If a keystore file is set and the following error occurs:
This means the password defined in your keystore file is incorrect.
Check the LCM settings under Windows-> Preferences, there is either an error with the login or proxy settings.
After the file downloads successfully you run into an error during the installation process. So as you can see this error page really tells us nothing, fortunately there’s a link to the error log on the page. If you made it this far the error is either due to SAPCAR not being able to unarchive the file or an error occurred during the execution of the installation script. To determine the error please check the logs located in the following directory <SUM_DIR>/log
If you can’t understand the logs please open a support ticket with SAP, via service.sap.com, with the logs attached.