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:
- Gather error messages:
- 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
- If you get a message that says "to see installation logs use...", do as it says
- In some cases, command xs logs --recent deploy-service can have some useful info
- Google for your error messages (remove special characters and IDs... you may not be the first one with this problem)
- 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.