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/systemdbYou 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/ .
As usual, happy coding and see you on Twitter or on LinkedIn !
This is amazing Lucia! Exactly what I've been looking for, thanks!
When I run the Enable Statistics server I get an error - * 10: authentication failed SQLSTATE: 28000
However, I'm able to login with the SYSTEM User using the HANA studio. I tried to run the command with both 30015 and 30013.
Any help to resolve the error is appreciated.
Chances are the password contains some special characters and should be between quotes. Try logging in first, without the password, and then issue the command (replacing accordingly):
hdbsql -i XX -n localhost:3XX13 -u SYSTEM
<<it will ask for the password>>
Then copy and paste the alter statement.
You can also try activating the statistics server from HANA Studio (in the Admin menu, config tab, under nameserver.ini). If the problem continues, please create a question in the Q&A so that more people can help you and some others can solve the same problem if they encounter it.
Cheers!
I love the host name... 'chiquita' 😀
Quite an astute observer! It's the NUC's name because... it's chiquita! 😉
I hate I can't see who liked my comment on this platform... 🙁
Hm, should this work on the server-only version (VM template) for 2.0 SPS03? Here is what I get:
When I cat the log:
When I try to do the ALTER statements it gives me an error saying the role does not exist. So I'm wondering if this blog wouldn't apply to my case where I wanted to do *server only* VM template but get back the XS old IDE?
Hello everyone, When I try to execute the SQL code for the roles I get following errors: hdbsql SYSTEMDB=> CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::EditorDeveloper','SYSTEM'); * 389: invalid role name: sap.hana.ide.roles::EditorDeveloper SQLSTATE: HY000 hdbsql SYSTEMDB=> CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::CatalogDeveloper','SYSTEM'); * 389: invalid role name: sap.hana.ide.roles::CatalogDeveloper SQLSTATE: HY000 hdbsql SYSTEMDB=> CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::SecurityAdmin','SYSTEM'); * 389: invalid role name: sap.hana.ide.roles::SecurityAdmin SQLSTATE: HY000 Can you please help me? Regards StefanFurthermore no delivery units are imported in the first step:
SAP HANA Lifecycle Management - Update Repository 2.3.40********************************************************
Enter System Database User Name [SYSTEM]: SYSTEM
Enter System Database User (SYSTEM) Password:
Importing delivery units...No delivery units to import
Importing delivery units of plugin 'sap_afl_sdk_apl'...No delivery units to import
Update Repository done
Log file written to '/var/tmp/hdb_HXE_UpdateRepository_2018-06-13_17.01.36/hdbupdrep.log' on host 'hxehost'.
Hi Stephan,
I'm assuming you are trying this on HANA 2.0 SPS03.
Some things happened since this blog post... One of them was the deprecation of XS Classic, which is one of the reasons why the Web Editor Workbench has been moved to /hana/shared/HXE/global/hdb/content (the other reason is that it has some problems, so I advise against using it unless there is a specific feature you are looking for)
The rest of the packages are there and still installed by default so this blog post does not apply for that version.
Best,
Lucia.
Hi Lucia,
yes it is probably the case, I installed HANA Express 2 weeks ago.
I was trying to complete a text analysis tutorial from the HANA academy where I need to copy a script (linganalysis_full.hdbtextconfig) from XS classic and paste it in XSA:
https://www.youtube.com/watch?v=Z7aWYO2QD8E&index=10&list=PLkzo92owKnVzvF_ssSvuQT2WYQ-m0ZLbg
Do you know where else I can find it?
Regards
Stefan
If it's just about picking up the configuration file, you don't need the web editor workbench (really, spare yourself with all of this painful process). You should find the hdbtextconfig files in this directory in your VM:
/hana/shared/HXE/global/hdb/custom/config/lexicon/
And you could also use HANA Studio if you wanted to mimic what the video does.
Cheers,
Lucia
or do you mean that those lines look different?:
/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