Updating HANA to SPS10


Starting point                                                                                                                        


This time, now the SPS10 is GA, I will update from SPS9 to SPS10.

Here is my source version :


SPSupd1.png

The target is the one available on the market place at the time going :

SPSupd2.png

Before performing the update / upgrade                                                                       

Some questions often arise about the way to go to update to an SPS level, like :


– Q: If I am in SPS 08 and want to update to SPS 10 : then what path to follow ? Do I need intermediate updates?


A: Some notes are available to deal with these topics like the release notes of your target SPS. Here these would be

1948334 – SAP HANA Database Update Paths for Maintenance Revisions

2165826 – SAP HANA Platform SPS 10 Release Note

2193110 – SAP HANA SPS 10 Database Revision 102

– Q: Are there any updates to do to the underlying OS prior to updating HANA software ?

A: Sometimes updates of some packages are needed.

These should be specified in SAP notes like ( depending on the underlying OS ) :

2001528 – Linux: SAP HANA Database SPS 08 revision 80 (or higher) on RHEL 6 or SLES 11

At least these will be referenced in the HANA SPS relase notes.

So these are pre-requisites to read in order not to encounter any issue.

– Q: Where can I find detailed information about the update / upgrade process ?

A : For detailed instructions about how to update to the SAP HANA platform SPS 10, see the SAP HANA Master Update Guide – SAP HANA Platform SPS 10.

Before updating an SAP HANA server to SPS 10, review the Preparing for Update section of the SAP HANA Server Installation and Update Guide.

The tools                                                                                                                           



Before updating an SAP HANA server to SPS 10, review the Preparing for Update section of the SAP HANA Server Installation and Update Guide.

To perform this operation you have several tools available :

hdblcm : command line.

hddblcmgui : graphical interface started at OS level

Platform Lifecyle Management tool : which you can access from the hDB Studio provided you have a user with the necessary acces rights to do so :

SPSupd3.png

So this time, I’ll use this tool to perform the update.

SPSupd4.png

The process                                                                                                                          


– Check option

The PLM offers gives you the opportunity to perform an update check.

SPSupd_check_only1.png

In the end it will generate a log file showing you the status of th checks performed :

SPSupd_check_only2.png

You can display the logfile content or save it on your computer.

here is an extract :

SPSupd_check_only3.png

SPSupd_check_only4.png

– Prepare option


In SPS10, you have now the option to perform some 2 steps upgrade.

On preparation phase which will help in foreseeing any problem that would arise, on a technical standpoint, with the update.

In the preparation step, the currently running hana version is not impacted. Nothing changes.

The second step will be to “resume” the update , this will actually perform the upgrade of the platform to the target SPS.

The goal is to lower the downtime of the HANA system during this update operation.

I used this option :

SPSupd5.png

You give the full ppath to the update DVD material :

SPSupd6.png

SPSupd7.png

You now have the list of the detected components to be updated :

SPSupd8.png

In this screen, you click on the icon at the bottom left to access the options :

SPSupd11.png

This is where you have the choice to perform the update preparation only by ticking the box :

SPSupd_prep_only1.png

In the sum up screen you’ll see that the update will be prepared only :

SPSupd_prep_only2.png

Here is the review screen :

SPSupd_prep_only3.png

And once confirmed, the update preparation phase starts up :

SPSupd_prep_only4.png

This first step helped in showing that I would run into compatibility issues :

SPSupd_prep_only5.png

After reviewing and correcting the issues, I restarted the update in preparation mode and got the green light :

SPSupd_prep_only10.png

You can see in the logs that only the preparation was done. The process is ready to be resumed later on :

SPSupd_prep_only12.png


– Actual update


Now is the time to perform the actual update.

I restart the LCM tool and now have a screen showing me that an update is waiting to be resumed :

SPSupd_post_pre1.png

I continue and give the necessary informations :

SPSupd_post_pre2.png

SPSupd_post_pre3.png

I chose “update” and there we go  :

SPSupd_post_pre4.png

After some time ( around 23 minutes for this run on my test system ) , the system is updated :

SPSupd_post_pre7.png

Et Voilà ! The update is completed.

You can use this button to send the feedback information to SAP ( just like in an upgrade for example ) :

SPSupd_post_pre8.png

Then you can click : close and you get back to the initial screen ( with some changes that were added by the new version ) :

SPSupd_post_pre10.png

Post update tasks                                                                                                                           


As usual, you’ll have to update the HDB client on the application servers connecting to your HDB, and the HDB studio etc…

as specified in the release note :

If you upgrade from a lower SAP HANA SPS, it is recommended to update ALL other components (Studio, Modeler, DB Clients, DBSL, SLT, DS, …) to at least the minimal version of SAP HANA SPS 10.

Follow the SAP note :

SAP Note 1962472 – Redeployment of calculation views recommended when upgrading to a new SPS

The End !

Enjoy !


To report this post you need to login first.

1 Comment

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

  1. Derbal Billel

    Hi Steve,

    first of all thank you for your post;

    I don’t understand how it did work for you ? “going directly from Rev 97.00 to Rev 102.01”. In the SAP Note 194833 it is said that to go from Rev 97.00 to Rev 102.01 you have to go first to Rev 97.03 !

    I’ve tried to go to Rev 102.02 from Rev 97.03 using hdblcm command line and I’ve got this message :

    “An already installed component SAP HANA AFL (incl.PAL,BFL,OFL) is not compatible with SAP HANA Database version 1.00.102.02.1446663129. SAP HANA AFL (incl.PAL,BFL,OFL) requires SAP HANA Database with version between 1.00.097.03 inclusive and 1.00.097.4 exclusive.”

    the Solution that I found is to launch the hdbinst command line from SAP_HANA_AFL installation folder before starting the upgrade.

    Regards

    (0) 

Leave a Reply