Missing XS Classic in HANA express? Here’s how to get it back
Whether you got the server-only SAP HANA, express edition, instance from the launcher at the Google Cloud Platform, downloaded the virtual machine or installed the binaries manually, you might have noticed the “XS Engine is up and running” splashscreen is there but the rest of the XS Classic features are not.
If you are still getting ready to get started with XS Advanced, the good news is that you can easily enable XS Classic in your HXE instance because the packages are there and available for installation.This of course applies to versions 2.0 SP00 and SP01 of SAP HANA, express edition and will translate to your instance eating up more resources.
First, you need to run hdbuprep aiming the the proper content directory, where <<HXE_SID>> stands for HXE (or whatever System ID you are using). As root, in a console in the operating system:
/hana/shared/<<HXE_SID>>/global/hdb/install/bin/hdbupdrep --content_directory=/hana/shared/<<HXE_SID>>/global/hdb/auto_content /hana/shared/<<HXE_SID>>/global/hdb/install/bin/hdbupdrep --content_directory=/hana/shared/<<HXE_SID>>/global/hdb/auto_content/systemdb
You will be prompted for SYSTEM’s password twice (once per command) before the installation finishes:
Then, enable statistics server (replace XX with your instance number, which will probably be 90 or 00):
sudo su - hxeadm hdbsql -i XX -n localhost:3XX13 -u SYSTEM -p <SYSTEM user password> "alter system alter configuration('nameserver.ini','SYSTEM') SET ('statisticsserver','active') = 'true' with reconfigure"
While you are still in the SQL prompt, add the proper roles to SYSTEM and change the webdispatcher config:
CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::EditorDeveloper','SYSTEM'); CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::CatalogDeveloper','SYSTEM'); CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::SecurityAdmin','SYSTEM'); CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::TraceViewer','SYSTEM'); ALTER SYSTEM ALTER CONFIGURATION ('webdispatcher.ini', 'system') SET('profile', 'wdisp/system_auto_configuration') = 'true' WITH RECONFIGURE;
The Web-based Development Workbench should now be at http://hostname:80XX/sap/hana/ide/ .