Skip to Content
0
Aug 16, 2023 at 08:33 PM

Problems with SAP HANA Express 2.0 SPS 6, Virtual Machine Image installation

220 Views Last edit Aug 17, 2023 at 06:33 AM 11 rev

I spent a whole working day trying to install SAP HANA Express - unfortunately in vain. The image (2.00.061.00.20220519.1) does not seem to have been updated for over a year. In the meantime, certificates and passwords (e.g. for the users XSA_DEV, TEL_ADMIN) have expired. Even if you try to update the certificates, reactivate the users and manually reset the passwords, the scripts still fail at certain points. Yes, you can somehow get part of SAP HANA to run, but only part.

It is sad that SAP offers an experimentation and learning platform that is not usable unless you get into a lot of technical details.

Are there any alternatives available?

EDIT:
Here is a list of things I tried - in this sequence:

HDB start
XSA reset-certificate
 
hdbsql -u system -n hxehost:39013
alter user XSA_ADMIN activate user now;
alter user XSA_ADMIN password <new password>;
alter user XSA_DEV activate user now; 
alter user XSA_DEV password <new password>;
alter user TEL_ADMIN activate user now;
alter user TEL_ADMIN password <new password>;

hdbsql -u system -n hxehost:39015
alter user TEL_ADMIN activate user now;
alter user TEL_ADMIN password <new password>;

register_cockpit.sh --action change_pwd -d SystemDB
register_cockpit.sh --action change_pwd -d HXE 

After the steps were completed I renamed the "/usr/sap/HXE/home/.init_boot" file to avoid the server to restart config after every system restart.

I can use most of the services now and both, SystemDB and HXE are registered with the cockpit.
To avoid running into troubles again, I will try deactivating password expiration for all the technical users.

hdbsql -u system -n hxehost:39013
alter user XSA_ADMIN disable password lifetime;

INSTALLING ADDTIONAL PACKAGES:

And in case someone is trying to install additional packages:
HXEDownloadManager_linux.bin will always run into connection problems if executed from within the virtual machine.
However, you can use an SFTP client like WinSCP to connect to the hxehost using the hxeadm system user and upload the packages into the directories listed in the "Getting Started" document.

CONNECTION PROBLEMS:

If you are having problems with the internet connection of the virtual machine (no IP address), it is most likely caused by trying to use Bridging with a WIFI network adapter (your WIFI router will not allow to register two MAC-addresses for one connection). Use a LAN adapter instead and bridge this one.