Technical Articles

Lucia Subatin

August 8, 2019 3 minute read

Upgrading SAP HANA, express edition to SPS04

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 Programming model wizard.

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:
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
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.

12 Comments

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

Praveer Kumar Sen

August 13, 2019 at 2:28 am

Hi Lucia,

Thanks for providing details steps to upgrade HXE addition.

On upgrading process I am getting below error message. Can you please help me to resolve the below issue and continue with upgrade process.

Regards,

Praveer.

Lucia Subatin

Blog Post Author

August 13, 2019 at 2:30 am

Hi Praveer, did you download and unzip eml.tgz too? Is this a local VM or cloud?

Praveer Kumar Sen

August 13, 2019 at 2:47 am

Hi Lucia,

This is in local VM.

eml.tgz got downloaded in “/usr/sap/HXE/home/bin/HXECheckUpdate_linux.bin -a” step along with other required packages.

Regards,

Praveer.

Praveer Kumar Sen

August 13, 2019 at 5:31 pm

Hi Lucia,

I have downloaded and unzip eml.tgz, but still getting the same error.

Regards,

Praveer

Lucia Subatin

Blog Post Author

August 16, 2019 at 1:50 am

Hi Praveer,

We've been unable to reproduce this issues. Can you please share the output of:

HDB version
cat /usr/sap/HXE/SYS/global/hdb/hxe_info.txt
sudo /hana/shared/HXE/hdblcm/hdblcm --action check_installation
md5sum /usr/sap/HXE/home/Downloads/eml.tgz

Thanks,

Lucia.

Steffen Schmidt

August 16, 2019 at 7:01 am

Hi,

I had the exactly the same issue. To fix it I downloaded the eml.tgz with the Download Manager that you use to download the VM image. Then I copied the archive into the Downloads folder of the VM and extracted it.

Then the upgraded worked.

Best Regards,

Steffen

Radu Simen

February 13, 2020 at 9:42 pm

This tutorial worked 100% for upgrading SPS04 to latest version with the following comment : I have SHINE installed so I had to download, copy, inflate SHINE also before the upgrade because there is an warning to skip it. After updating HDB, I saw that SHINE update did not upgraded anything whatsoever so the warning may be ignored

SAP BASIS

May 25, 2020 at 4:20 pm

Hi guys!

EDIT: (see solution below)

hxeadm@hxehost:/usr/sap/HXE/home/bin> HXEDownloadManager_linux.bin -d /usr/sap/HXE/home/Downloads/ "linuxx86_64" "installer" hxe.tgz
Connecting to download server...
hxeadm@hxehost:/usr/sap/HXE/home/bin> HXEDownloadManager_linux.bin -d /usr/sap/HXE/home/Downloads/ "linuxx86_64" "installer" hxexsa.tgz
Connecting to download server...

Trying to do the Upgrade in a local VM based setup. Can’t find the updater in bin

hxeadm@hxehost:/usr/sap/HXE/HDB90> ls /usr/sap/HXE/home/bin/
change_key.sh 
create_tenantdb.sh 
HXEDownloadManager_linux.bin 
hxe_gc.sh 
hxe_telemetry.sh 
register_cockpit.sh
hxeadm@hxehost:/usr/sap/HXE/HDB90>

hxeadm@hxehost:/usr/sap/HXE/HDB90> HDB -version
HDB version info:
version: 2.00.020.00.1500920972
branch: fa/hana2sp02
git hash: 7f63b0aa11dca2ea54d450aa302319302c2eeaca
git merge time: 2017-07-24 20:29:32
weekstone: 0000.00.0
compile date: 2017-07-24 20:35:12
compile host: ld4551
compile type: rel

hxeadm@hxehost:/usr/sap/HXE/HDB90> cat /usr/sap/HXE/SYS/global/hdb/hxe_info.txt
[hxe_version]
HANA, express edition=2.00.020.01.20170829.3
#
HDB_AFL=2.00.020.00
HDB_LCM=2.00.020.00
HDB_SERVER=2.00.020.00
#
XSA_RT=1.0.63
XSAC_COCKPIT=2.3.7
XSAC_HRTT=2.2.6
XSAC_MONITORING=1.5.2
XSAC_PORTAL_SERV=1.1.1
XSAC_SAP_WEB_IDE=4.2.0
XSAC_SERVICES=1.5.3
XSAC_UI5_FESV3=1.44.18
#
[hxe_installation]
INSTALL_TYPE=OVA
INSTALL_DATE=Fri Sep 29 11:42:50 UTC 2017
hxeadm@hxehost:/usr/sap/HXE/HDB90> /hana/shared/HXE/hdblcm/hdblcm -action check_installation


SAP HANA Lifecycle Management - SAP HANA Express Edition 2.00.020.00.1500920972
*******************************************************************************


System Properties:
HXE /hana/shared/HXE HDB_ALONE
HDB90
version: 2.00.020.00.1500920972
host: hxehost (Database Worker (worker), XS Advanced Runtime Worker (xs_worker))
edition: SAP HANA Express Edition
plugins: afl

Enter System Administrator (hxeadm) Password:

Summary before execution:
=========================

SAP HANA Express Edition
Check Parameters
Execution Scope: system
Property File: /hana/shared/HXE/global/hdb/install/support/hdbcheck.xml

Do you want to continue? (y/n): y

Checking SAP HANA Express Edition System installation ...
Checking SAP HANA system 'HXE'...
Checking programs (check pending)...
Checking system administrator 'hxeadm'...
Checking local directories...
Checking global directories...
Checking directories of SAP HANA options...
Checking volumes...
SAP HANA Express Edition System checked.
Log file written to '/var/tmp/hdb_HXE_hdblcm_check_installation_2020-05-25_18.16.17/hdblcm.log' on host 'hxehost'.

SAP BASIS

May 26, 2020 at 4:50 pm

UPDATE (fix below)

note 2786650 - ERR Error: Could not retrieve the download URL for Node.js: Error: certificate has expired

XSA reset-certificate
Stopping XSA …
Starting XSA …
OK

Cross your fingers and re-run updater...

Seems to do in our case. Good luck!

The update didn’t went well:

xs apps

FAILED: Request has invalid access token: revocable signature mismatch.

cat /usr/sap/HXE/SYS/global/hdb/hxe_info.txt

Still shows old version

Install check looks nice, version info shows patch version

hxeadm@hxehost:/usr/sap/HXE/home/bin> HDB -version
HDB version info:
version: 2.00.045.00.1575639312
branch: fa/hana2sp04
machine config: linuxx86_64
git hash: af3aabc5a5cdb94ecbc7c07d0997d0bd4ae0046b
git merge time: 2019-12-06 14:35:12
weekstone: 0000.00.0
cloud edition: 0000.00.00
compile date: 2019-12-06 15:29:38
compile host: ld5144
compile type: rel

I guess it’s because one part of the update failed:

 [31] Uploading files for application auditlog-db
Update content of XS Advanced Runtime failed

Output line 166: [31] com.sap.xs2rt.installation.util.InstallationException: Updating of application Audit-Log Service (DB) failed.
Output line 214: | [34] Update of Auditlog Broker bindings | 01:00:00.000 | 01:00:00.000 | 0 ns | not run |
Output line 224: com.sap.xs2rt.installation.util.InstallationException: Updating of application Audit-Log Service (DB) failed.
Update of SAP HANA Express Edition components failed.
Update of SAP HANA XS Advanced Runtime failed
[31] Caused by: com.sap.xs2rt.client.exceptions.XsClientException: Staging of app "auditlog-db" failed
Caused by: com.sap.xs2rt.client.exceptions.XsClientException: Staging of app "auditlog-db" failed
Installation failed
error installing
Cannot install
Custom event postInstall failed
Update content of XS Advanced Runtime failed
Starting external program /hana/shared/HXE/xs/installation-scripts/installation/update-content

 Output line 147: [31] Staging application auditlog-db
Output line 148: [31] 5/26/20 5:53:33.937 PM [STG/3] OUT Node.js
Output line 149: [31] 5/26/20 5:53:34.161 PM [STG/3] OUT Node.js buildpack version 4.1.0
Output line 150: [31] 5/26/20 5:53:34.163 PM [STG/3] OUT Available Node.js runtimes: node6.11,node10.17,node4.8,node8.15
Output line 151: [31] 5/26/20 5:53:34.189 PM [STG/3] ERR Error: Could not retrieve the download URL for Node.js: Error: certificate has expired (connecting to hxehost:39030)
Output line 152: [31] 5/26/20 5:53:34.189 PM [STG/3] ERR Error: Could not retrieve the download URL for Node.js: Error: certificate has expired (connecting to hxehost:39030)
Output line 153: [31] 5/26/20 5:53:34.189 PM [STG/3] ERR at Request._callback (/hana/shared/HXE/xs/app_working/stager/cache/64cc4cdd-5965-4999-b4c3-b2cd5cc7750e/lib/utils.js:68:16)
Output line 154: [31] 5/26/20 5:53:34.189 PM [STG/3] ERR at self.callback (/hana/shared/HXE/xs/app_working/stager/cache/64cc4cdd-5965-4999-b4c3-b2cd5cc7750e/node_modules/request/request.js:185:22)
Output line 155: [31] 5/26/20 5:53:34.189 PM [STG/3] ERR at emitOne (events.js:116:13)
Output line 156: [31] 5/26/20 5:53:34.189 PM [STG/3] ERR at Request.emit (events.js:211:7)
Output line 157: [31] 5/26/20 5:53:34.189 PM [STG/3] ERR at Request.onRequestError (/hana/shared/HXE/xs/app_working/stager/cache/64cc4cdd-5965-4999-b4c3-b2cd5cc7750e/node_modules/request/request.js:881:8)
Output line 158: [31] 5/26/20 5:53:34.190 PM [STG/3] ERR at emitOne (events.js:116:13)
Output line 159: [31] 5/26/20 5:53:34.190 PM [STG/3] ERR at ClientRequest.emit (events.js:211:7)
Output line 160: [31] 5/26/20 5:53:34.190 PM [STG/3] ERR at TLSSocket.socketErrorListener (_http_client.js:401:9)
Output line 161: [31] 5/26/20 5:53:34.190 PM [STG/3] ERR at emitOne (events.js:116:13)
Output line 162: [31] 5/26/20 5:53:34.190 PM [STG/3] ERR at TLSSocket.emit (events.js:211:7)
Output line 163: [31] [STG/3] ERR Execution of bin/compile failed (exit value 1)
Output line 164: [31] [STG/3] ERR Failed to stage app 'auditlog-db' [Org 'HANAExpress', Space 'SAP']: Execution of bin/compile failed (exit value 1).
Output line 165: [31] ERROR:
Output line 166: [31] com.sap.xs2rt.installation.util.InstallationException: Updating of application Audit-Log Service (DB) failed.
Output line 167: [31] at com.sap.xs2rt.installation.impl.hana.content.components.AuditLogServiceDbStep.update(AuditLogServiceDbStep.java:162)
Output line 168: [31] at com.sap.xs2rt.installation.steps.InstallationStep.updateAndMeasure(InstallationStep.java:171)
Output line 169: [31] at com.sap.xs2rt.installation.procedures.InstallationProcedure.executeStep(InstallationProcedure.java:123)
Output line 170: [31] at com.sap.xs2rt.installation.procedures.InstallationProcedure.perform(InstallationProcedure.java:218)
Output line 171: [31] at com.sap.xs2rt.installation.impl.hana.content.HanaContentInstallUpdateProcedure.main(HanaContentInstallUpdateProcedure.java:122)
Output line 172: [31] Caused by: com.sap.xs2rt.client.exceptions.XsClientException: Staging of app "auditlog-db" failed

There is an error with the certificate validity?

How to fix the upgrade?

Laszlo Thoma

January 19, 2022 at 9:28 am

Hi Lucia,

I am using the preconfigured VMware image of the SAP HANA Express Edition.
SAP HANA, Express Edition 2.0 SPS05 server-plus-apps version.
SUSE Linux Enterprise Server for SAP Applications 12 SP2.
Downloaded the hxexsa.ova file from the official SAP site.

Yesterday I had done the SAP HANA, Express Edition upgrade from 2.00.054 to 2.00.057 version based on your technical article.

Can you recommend other disk clean-up option like this in the article?

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

I am thinking like content in the folder (HANA_EXPRESS_20), can it be deleted after successful upgrade:

/usr/sap/HXE/home/Downloads/HANA_EXPRESS_20

Is there any additional file system folder which can be checked after upgrade to save some disk space?

During the upgrade in my case disk usage went from 80 GB to 110 GB.

Thanks for your answer.

Laszlo

Denys van Kempen

January 21, 2022 at 10:10 am

Hi Laszlo,

As Lucia Subatin (active account) might be busy at Google, here is my comment

You can delete both the compressed source files (tgz) and the expanded archives after a successful upgrade.

Concerning disk space management, suggest to check the (F)AQ on the topic

https://answers.sap.com/tags/73555000100800000651

Laszlo Thoma

January 21, 2022 at 10:31 am

Hi Denys,

I am appreciate for your help.

Regards,

Laszlo

Technical Articles

Upgrading SAP HANA, express edition to SPS04

The steps are easy…

You will need to install libatomic1

Run the update checker

Inflate files

Upgrade time!

Play time!

Troubleshooting

Assigned Tags