Upgrade your HANA, express edition to HANA 2
As soon as I learned about SAP to Unveil SAP HANA 2, I wanted to get my hands on it, and with the release of the HANA 2, express edition this is in fact very easy. Had I not previously registered with SUSE to Secure my HANA, express edition, I would have just started from scratch with a new Virtual Machine Image. But since I have and would like to preserve it, I take a different approach:
- Increase memory to 8 GB
- Download Binary Installer
- Create temporarily user
- Uninstall HANA 1
- Install HANA 2
- Connect to HANA 2 Cockpit
In order to allow for the upgrade to HANA 2, I have to increase the memory of my virtual machine to 8 GB:
Then I download the Binary Installer with the HANA, Express Edition Download Manager 2.0:
And unpack it into a temporary location:
Next I create myself a temporary user, since user hxeadm will be temporarily deleted in the process:
Leveraging my temporary user, I uninstall HANA 1:
And subsequently install HANA 2 from the temporary location with instance number 00 to reuse my HANA Studio settings and browser bookmarks:
The base install can take a while, but eventually the resident hdblcm and AFL get installed:
So that the installation finishes successfully. Interestingly, the HANA 2, express edition comes already with a tenant database:
In HANA Studio, I can log into my 2.00.000.00 system including the AFL:
To explore the HXE tenant database, I connect the system to my standalone HANA 2 Cockpit and in fact see a second database Not running:
So I attempt to start it:
And in fact, after a short while, it is running just fine:
So that I can connect and monitor it from my standalone HANA Cockpit as well:
From here I will continue to explore the further options. Please send me any of your own discoveries and feedback.
Very best regards and thank you in advance
Frank
Hi Frank,
I have tested HANA Express 2.0, and I've found that some roles no longer exist.
"sap.hana.admin.roles::Administrator" and "sap.hana.admin.roles::Monitoring".
HANA Express 2.0 HANA Express 1.0.12
Missing those roles, prevent the activation of some delivery unit that need it.
Example: When importing the "Smart Data Integration" delivery unit, it stops by activation with error:
Can you confirm that you have the same error?
Ayman
Hello Ayman,
what version of Agile Data Preparation are you trying to install? As far as I know, according to SAP Note 2330955 - SAP Agile Data Preparation Version 1.0 SP 11 Release Notes, and especially the SAP Agile Data Preparation On Premise and all its patches Product Availability Matrix (PAM), there is no ADP release for HANA 2.0 yet.
Best regards
Frank
Hi Frank,
It was SDI version 1.0 SP02 Patch 03. I know this was for HANA 1.0, but I just tried to test it on my HANA Express 2.0 test env.
I have found that the problem with roles is normal, as in “What’s New in the SAP HANA Platform 2.0 (Release Notes)” Document under “2.2.2 SAP HANA Database Security (New and Changed) / Authorization (New and Changed)”
….
The following roles delivered in the these DUs are therefore no longer available:
○ sap.hana.admin.roles::*
○ sap.hana.admin.cockpit.sysrep.roles::SysRepAdmin
○ sap.hana.backup.roles::*
○ sap.hana.security.base.roles::*
○ sap.hana.security.cockpit.roles::*
○ sap.hana.admin.cockpit.sysdb.roles::SysDBAdmin
Still, it does not work for me even with the new version SDI 2.0 (which is available https://support.sap.com/content/dam/library/ssp/infopages/pam-essentials/TIP/PAM_HANA_SDI_2_0.pdf) because it requires “dpserver”, which is not possible to add it to the HANA Express 2.0 version.
Thanks,
Ayman
Hi,
HANA express is a multitenant system so you would need to add the dpserver to a tenant. Can you confirm that this is not possible?
The roles are removed because with HANA 2, cockpit is no longer embedded into HANA but runs on a separate system (HANA express). So to administer HANA express with HANA cockpit, you need two systems. Have you tried installing SDI cockpit part into the cockpit system and the HANA part into the tenant on the HANA system?
D
I can confirm the same problem when trying to add a DP server to the tenant of a newly installed HXE 2.0. It would be quite unfortunate if SAP now disallow the use of SDI.
ALTER DATABASE HXE ADD ‘dpserver’
Feature not available in HANA Digital Edition
Thanks Adriaan,
Interesting: "HANA Digital Edition". There is no reference to this "edition" in any public documentation.
According to blog Enable Smart Data Integration on your HANA, express edition, SDI could be enabled for HANA 1 but appears no longer to work for HANA 2.
Another reference to this digital edition is mentioned in blog Getting started with Predictive on SAP HANA, express edition; here updating express to the latest version solved the issue.
You try to download the latest version of the express VM (the download is updated regularly).
However, according to the Feature Scope Description document for express, SDI is not supported.
https://www.sap.com/documents/2016/09/3e24cc42-8a7c-0010-82c7-eda71af511fa.html
Hi Frank,
this is an older post but the best match i found for our intended upgrade.
We are on Hana 1 Express SP12 and need to upgrade to HANA 2 Express since we do not have the MERGE INTO command in HANA 1. Is the method you desribe here really an "upgrade" (i.e. databases are migrated and still working after the upgrade with V2 functionality) or is this more a "reinstall" of HANA (so we also could start from scratch)?
So far i did not find an elegant upgrade method for a "plain HANA Express" developer, since one does not have an S-User and thus cannot download update images from the sap store and use the lifecycle management functions?
Or did i miss here something completely?
Thanks,
Markus