Skip to Content
Author's profile photo Denys van Kempen

SAP HANA 2.0 SPS 02 What’s New: Installation and Update – by the SAP HANA Academy


In the upcoming weeks, we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA 2.0 Support Package Stack (SPS) 02.

The topic of this blog is Installation and Update (Platform Lifecycle Management).

For the previous versions of this blog, see

For the full SAP HANA 2.0 SPS 02 blog list, see


Tutorial Video


What’s New?

High Availability Support for XS Advanced Installation

XSA integrates with the standard failover procedures of SAP HANA (xs_standby role). For XSA apps to continue to be served on the same URL after failover, a failover router (reverse proxy) needs to be setup. Doing so will impact the installation of XSA components as the installer (hdblcm) can no longer establish a connection to the default domain.

A workaround would be to temporarily map the default domain back to the XSA web dispatcher but this may not always be possible.

As of SPS 02, three new parameters can now be passed to hdblcm to specify the path to the certificate and key file of the default domain, and the path to an additional trust certificate for the reverse proxy: xs_cert_pem, xs_cert_key, and xs_trust_pem respectively.

How to do this is documented in


Updating SAP HANA AFL Components (Changed)

Application functions are similar in concept to database procedures but then written in C++, not SQLScript, and called from outside the database. They are bundled in AFL’s, application function libraries.

AFL components are not included with a standard SAP HANA delivery but come as an archive (SAR file) and require separate installation. A typical installation of an AFL component requires a restart of the database and hence downtime.

Starting with SPS 02, a new flag is introduced in the manifest file:

online-upgrade-plugin: 1

If this flag is present, no database restart is performed (online upgrade).

Note 2198403 – AFL and corresponding components list all the available AFL components:

  • APL (Automated Prediction Library)
  • BFL (Business Function Library)
  • DQ  (SAP HANA Data Quality Library)
  • EML (External Machine Learning Library)
  • GEN (SAP HANA AFL Shipment and general AFL topics)
  • PAL (SAP HANA Predictive Analysis Library)
  • POS (SAP HANA On-Shelf Availability)
  • SAL (SAP HANA Self Service Analytics Library) or UAL (Universal Analytics Library)
  • SCA (SAP HANA Supply Chain Algorithm Library)
  • SOP (SAP HANA Sales & Operations Planning)
  • RME (Response Management Engine)
  • TEC (SAP HANA AFL Technology and SDK)
  • TRP (Transportation Resource Planning)
  • UDF (SAP HANA Unified Demand Forecast)

The first AFL’s that support online upgrades will become available shortly.



On the SAP HANA Academy, there is a full playlist covering all aspects of installation and update



For more information, see

SAP Help Portal

SAP Notes


Thank you for watching

The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.

For the full library, see SAP HANA Academy Library – by the SAP HANA Academy

For the full list of blogs, see Blog Posts – by the SAP HANA Academy


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Mani Mandadi
      Mani Mandadi


      Thanks Denys Van Kempen.

      Im installing HANA Cockpit 2.0 SP4 using hdblcmgui  on Linux 12 Sp1, experiencing an issue at "assigning additional roles to the local host" , getting below error,

      load-initial-content call failed.


      Error Step "Configure UAA SAML Trust"

      your reply will be much appreciation.







      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Mani,

      All I can say is that during the phase where SSO is setup (SAML trust for XS User Account and Authentication) something went wrong with uploading content (from the installation media / file system to some XS container / VM).

      Does not help much, does it?

      For this type of issues, best to contact SAP support.

      Make sure all prerequisites are met (hardware, operating system, etc. - see the installation guide).

      I just installed latest version of SAP HANA cockpit 2.0 SP 04 and it went smoothly. No issues.



      Author's profile photo Himanshu Pandey
      Himanshu Pandey

      Can we just upgrade the node runtime available in XSA??

      For example i have two node.js runtime installed i.e. 4.8 and 6.11 by default in XSA, can i update to latest 8.9?

      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Himanshu,

      To update the application runtimes, you would use the latest version of the SAP EXTENDED APP SERVICES 1 component which you can download from SAP ONE Support Portal Downloads section.

      This includes the latest supported runtime available. The version of the application runtimes is documented in the corresponding release note of that patch collection, for example 2582204 - XS RUNTIME 1 Patch Collection 40 (build 1.0.71) / PL 71).

      In this case, the node.js runtimes 4.8.16 and 6.12.1 are included (but not 8.9).


      Denys / SAP HANA Academy

      Subscribe to our YouTube Channel
      Join us on LinkedIn
      Follow us on Twitter
      Github code samples

      Author's profile photo Himanshu Pandey
      Himanshu Pandey

      thanks for the information Denys.

      Author's profile photo Vinod Mandavkar
      Vinod Mandavkar

      Thank you Danys Van Kempen,

      I need to install UDF-AFL on HANA 2.0 Revision 23. I am unable to find UDF-AFL installation file on SAP Service Marketplace for the above mentioned HANA Version. UDF-AFL is now part of "SAP RTL AFL FOR SAP HANA"?


      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Vinod,

      I am not familiar with the many different components "powered by HANA" like the Unified Demand Forecast Application (UDF). Best to check the documentation

      Note 2377894 mentions SAP RTL AFL FOR SAP HANA is a component in the CAR RETAIL APPL BUNDLE 2.0 back-end product version of SAP Customer Activity Repository applications bundle 2.0.


      Author's profile photo Dominik Kacprzak
      Dominik Kacprzak


      I have short question about transporting Hana Modeler development between Hana 2.0 and Hana 1.0. Is it safe? Is there any compatibility check? One of the system was upgraded.





      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Dominik,

      For this type of questions, I would suggest contacting SAP Support. There may be a specific upgrade path documented in an SAP Note.


      Denys van Kempen / SAP HANA Academy