Upgrading SAP HANA, express edition to SPS04

[lsubatin]

If you've been patiently waiting for the release of SAP HANA, express edition 2.0 SPS04 and are now ready to upgrade your existing HXE instance, this blog post is for you.

I have a similar blog post for an upgrade between revisions here in the context of following the openSAP course and getting a hold of the Cloud Application Prog...

The same prerequisites apply, only a bit more exaggerated:

• If this is a serious/important machine to you, back everything up. Make sure you can restore everything so that you won't go around chasing me on social media if something goes horribly wrong. I personally make a copy of the virtual machine if I can.


• This will take time. For me, in the cloud with 40GB of RAM allocated only to this VM it took 1:30hs.


• Add more RAM if you have the chance. If you get an "HTTP communication error" in the middle, lack of resources are a very likely cause. Playing game son you PC while the VM is upgrading on it is not a good idea.


• Make sure you will not run out of disk in the process (a command like df -h can give you a hint - plan to use at least 6GB )

The steps are easy...

You will need to install libatomic1

You will need to be a sudoer for this, By default, in the downloadable virtual machine, hxeadm is a sudoear. In the cloud machines, you need to go back to being root or your admin user (command exit).

sudo zypper addrepo http://download.opensuse.org/distribution/leap/15.0/repo/oss/ oss

sudo zypper install libatomic1

 

Run the update checker

This will connect to the download repository and start downloading different packages.

If you are not hxeadm, become hxeadm (sudo su – hxeadm 😞

export PATH=${PATH}:/hana/shared/HXE/xs/sapjvm_8/bin

/usr/sap/HXE/home/bin/HXECheckUpdate_linux.bin -a

Inflate files

You will now extract the zipped files... (add any other .tgz files you downloaded)

cd /usr/sap/HXE/home/Downloads

tar -xvzf hxe.tgz

tar -xvzf hxexsa.tgz 

You can remove the files you downloaded to save space

rm /usr/sap/HXE/home/Downloads/hxe.tgz

rm /usr/sap/HXE/home/Downloads/hxexsa.tgz

Upgrade time!

You also need to be a sudoer now. If you are hxeadm and in a cloud VM, command "exit" will take you back to your root user.

sudo /usr/sap/HXE/home/Downloads/HANA_EXPRESS_20/hxe_upgrade.sh

You will be asked for the passwords of your different admin users (for hxeadm, HXEHana1 is the default password if you haven't changed ... but you should have changed it):



 

Play time!

After at least an hour and a lot of console output, you should get a nice message



Remember you need to see "1/1" after a started app before you can connect to it:

Troubleshooting

If something goes wrong:

1. Gather error messages:
   
   
   
   1. From the output and the logs. The logs from installation can be found in a file similar to: /var/tmp/hdb_HXE_hdblcm_update_2019-08-02_23.32.28/xs_install_components.log and /var/tmp/hdb_HXE_UpdateRepository_2019-08-02_23.45.28/hdbupdrep.log
   
   
   2. If you get a message that says "to see installation logs use...", do as it says
   
   
   3. In some cases, command  xs logs --recent deploy-service  can have some useful info
   
   
   
   


2. Google for your error messages (remove special characters and IDs... you may not be the first one with this problem)


3. If you cannot find a response, document what you have done, where (a downloadable VM, a binary install in an alternative OS, a cloud image..), the error messages in those logs, how many attempts you've done and any other information that may help the community help you. With all of this info, create a question in the community and tag it SAP HANA, express edition.

Hope it all goes smoothly and you have lots of fun!

Lucia Subatin.