Skip to Content
Author's profile photo Lucia Subatin

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

As usual, happy coding and see you on or on LinkedIn !

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      This is amazing Lucia! Exactly what I've been looking for, thanks!

      Author's profile photo Srini Sathyamurthy
      Srini Sathyamurthy

      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.

      Author's profile photo Lucia Subatin
      Lucia Subatin
      Blog Post Author

      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!

      Author's profile photo Henrique Pinto
      Henrique Pinto

      I love the host name... 'chiquita' 😀

      Author's profile photo Lucia Subatin
      Lucia Subatin
      Blog Post Author

      Quite an astute observer! It's the NUC's name because... it's chiquita! 😉

      Author's profile photo Henrique Pinto
      Henrique Pinto

      I hate I can't see who liked my comment on this platform... 🙁

      Author's profile photo Mike Howles
      Mike Howles

      Hm, should this work on the server-only version (VM template) for 2.0 SPS03?  Here is what I get:

       

      hxeadm@hxehost:/usr/sap/HXE/HDB90> /hana/shared/HXE/global/hdb/install/bin/hdbup drep --content_directory=/hana/shared/HXE/global/hdb/auto_content

      SAP HANA Lifecycle Management - Update Repository 2.3.40
      ********************************************************

      Enter System Database User Name [SYSTEM]:
      Enter System Database User (SYSTEM) Password:
      Importing delivery units...
      No delivery units to import
      Update Repository done
      Log file written to '/var/tmp/hdb_HXE_UpdateRepository_2018-04-17_07.50.20/hdbupdrep.log' on host 'hxehost'.

      When I cat the log:

      hxeadm@hxehost:/usr/sap/HXE/HDB90> cat /var/tmp/hdb_HXE_UpdateRepository_2018-04-17_07.50.20/hdbupdrep.log
      07:50:21.088 - INFO: Installing signal handler
      07:50:21.088 - INFO: Handler for signal INT
      07:50:21.088 - INFO: Handler for signal PIPE
      07:50:21.088 - INFO: Handler for signal ABRT
      07:50:21.088 - INFO: Handler for signal FPE
      07:50:21.088 - INFO: Handler for signal QUIT
      07:50:21.088 - INFO: Handler for signal SYS
      07:50:21.088 - INFO: Handler for signal TRAP
      07:50:21.088 - INFO: Handler for signal TERM
      07:50:21.088 - INFO: -----------------------------------------------------------
      07:50:21.088 - INFO: System Information
      07:50:21.088 - INFO: -----------------------------------------------------------
      07:50:21.089 - INFO: Operating System: Linux
      07:50:21.089 - INFO: Architecture : X86-64
      07:50:21.089 - INFO: Version : 4.4.120
      07:50:21.089 - INFO: Subversion : 92.70-default
      07:50:21.089 - INFO: C Runtime : GLIBC 2.22
      07:50:21.089 - INFO: Cpu features : sse sse2 sse4.1 sse4.2 cmpxchg16b
      07:50:21.089 - INFO: Host Name : hxehost
      07:50:21.089 - INFO: Distribution : SLES_SAP 12.2
      07:50:21.089 - INFO: -----------------------------------------------------------
      07:50:21.089 - INFO: END: System Info
      07:50:21.089 - INFO: -----------------------------------------------------------
      07:50:21.103 - INFO: -----------------------------------------------------------
      07:50:21.103 - INFO: Installer Information
      07:50:21.103 - INFO: -----------------------------------------------------------
      07:50:21.103 - INFO: using installed Installer
      07:50:21.103 - INFO: Version is 2.3.40 (git hash: 9a5c298e16ad)
      07:50:21.103 - INFO: GitHash is 9a5c298e16ad
      07:50:21.103 - INFO: Platform is linuxx86_64
      07:50:21.103 - INFO: Perl version is v5.26.1
      07:50:21.103 - INFO: Running as console application
      07:50:21.103 - INFO: ---------------------------------------------------------
      07:50:21.103 - INFO: Program Call Information
      07:50:21.103 - INFO: ---------------------------------------------------------
      07:50:21.103 - INFO: Caller program name is hdbupdrep
      07:50:21.103 - INFO: Command line arguments: --content_directory=/hana/shared/HXE/global/hdb/auto_content
      07:50:21.103 - INFO: Current directory: /hana/shared/HXE/HDB90
      07:50:21.103 - INFO: Installer directory: /hana/shared/HXE/global/hdb/install/bin/instruntime
      07:50:21.103 - INFO: Pid is 14795
      07:50:21.103 - INFO: Effective uid 1001
      07:50:21.103 - INFO: Real uid 1001
      07:50:21.103 - INFO: Effective gid 79 16 33 79 1000
      07:50:21.103 - INFO: Real gid 79 16 33 79 1000
      07:50:21.103 - INFO: ---------------------------------------------------------
      07:50:21.103 - INFO: END: Program Call Information
      07:50:21.103 - INFO: ---------------------------------------------------------
      07:50:21.103 - INFO: ---------------------------------------------------------
      07:50:21.103 - INFO: Environment Dump
      07:50:21.103 - INFO: ---------------------------------------------------------
      07:50:21.103 - INFO: ASAN_OPTIONS = alloc_dealloc_mismatch=0:log_path=/usr/sap/HXE/HDB90/hxehost/trace/AddressSanitizer_Crashdump:handle_segv=0:allow_user_segv_handler=1:abort_on_error=1:check_initialization_order=1:detect_leaks=0:detect_odr_violation=0:use_sigaltstack=0:allocator_may_return_null=1
      07:50:21.104 - INFO: ASAN_SYMBOLIZER_PATH = /usr/sap/HXE/HDB90/exe/llvm-symbolizer
      07:50:21.104 - INFO: COLORTERM = 1
      07:50:21.104 - INFO: CPU = x86_64
      07:50:21.104 - INFO: CSHEDIT = emacs
      07:50:21.104 - INFO: DAT_BIN_DIR = /usr/sap/HXE/HDB90/exe/dat_bin_dir
      07:50:21.104 - INFO: DIR_EXECUTABLE = /usr/sap/HXE/HDB90/exe
      07:50:21.104 - INFO: DIR_INSTANCE = /usr/sap/HXE/HDB90
      07:50:21.104 - INFO: DIR_SYSEXE = /usr/sap/HXE/SYS/exe/hdb
      07:50:21.104 - INFO: FROM_HEADER =
      07:50:21.104 - INFO: GPG_TTY = /dev/pts/0
      07:50:21.104 - INFO: G_BROKEN_FILENAMES = 1
      07:50:21.104 - INFO: G_FILENAME_ENCODING = @locale,UTF-8,ISO-8859-15,CP1252
      07:50:21.104 - INFO: HISTSIZE = 1000
      07:50:21.104 - INFO: HOME = /usr/sap/HXE/home
      07:50:21.104 - INFO: HOST = hxehost
      07:50:21.104 - INFO: HOSTNAME = hxehost
      07:50:21.104 - INFO: HOSTTYPE = x86_64
      07:50:21.104 - INFO: INPUTRC = /usr/sap/HXE/home/.inputrc
      07:50:21.104 - INFO: LANG = en_US.UTF-8
      07:50:21.104 - INFO: LD_BIND_NOW = 1
      07:50:21.104 - INFO: LD_LIBRARY_PATH = /hana/shared/HXE/global/hdb/install/bin/instruntime
      07:50:21.104 - INFO: LESS = -M -I -R
      07:50:21.104 - INFO: LESSCLOSE = lessclose.sh %s %s
      07:50:21.104 - INFO: LESSKEY = /etc/lesskey.bin
      07:50:21.104 - INFO: LESSOPEN = lessopen.sh %s
      07:50:21.104 - INFO: LESS_ADVANCED_PREPROCESSOR = no
      07:50:21.104 - INFO: LOGNAME = hxeadm
      07:50:21.104 - INFO: LS_COLORS = no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.xz=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
      07:50:21.104 - INFO: LS_OPTIONS = -N --color=tty -T 0
      07:50:21.105 - INFO: MACHTYPE = x86_64-suse-linux
      07:50:21.105 - INFO: MAIL = /var/spool/mail/hxeadm
      07:50:21.105 - INFO: MANPATH = /usr/local/man:/usr/share/man
      07:50:21.105 - INFO: MINICOM = -c on
      07:50:21.105 - INFO: MORE = -sl
      07:50:21.105 - INFO: NNTPSERVER = news
      07:50:21.105 - INFO: OLDPWD = /usr/sap/HXE/HDB90
      07:50:21.105 - INFO: OMP_NUM_THREADS = 1
      07:50:21.105 - INFO: OSTYPE = linux
      07:50:21.105 - INFO: PAGER = less
      07:50:21.105 - INFO: PATH = /usr/sap/HXE/HDB90/exe/krb5/bin:/usr/sap/HXE/HDB90/exe/krb5/sbin:/usr/sap/HXE/HDB90/hxehost:/usr/sap/HXE/HDB90:/usr/sap/HXE/HDB90/exe:/usr/sap/HXE/HDB90/exe/mdc:/usr/sap/HXE/HDB90/exe/Python/bin:/usr/sap/HXE/HDB90/exe/dat_bin_dir:/usr/sap/HXE/home:/usr/sap/HXE/home/bin:/usr/local/bin:/usr/bin:/bin:/usr/games
      07:50:21.105 - INFO: PROFILEREAD = true
      07:50:21.105 - INFO: PS1 = hxeadm@hxehost:$PWD>
      07:50:21.105 - INFO: PWD = /usr/sap/HXE/HDB90
      07:50:21.105 - INFO: PYTHONHOME = /usr/sap/HXE/HDB90/exe/Python
      07:50:21.105 - INFO: PYTHONPATH = /usr/sap/HXE/SYS/global/hdb/custom/python_support:/usr/sap/HXE/HDB90/exe/python_support:/usr/sap/HXE/HDB90/hxehost:/usr/sap/HXE/HDB90/exe:/usr/sap/HXE/HDB90/exe/testscripts:/usr/sap/HXE/HDB90/exe/Python/lib/python2.7
      07:50:21.105 - INFO: PYTHONSTARTUP = /etc/pythonstart
      07:50:21.105 - INFO: SAPSYSTEMNAME = HXE
      07:50:21.105 - INFO: SAP_RETRIEVAL_PATH = /usr/sap/HXE/HDB90/hxehost
      07:50:21.105 - INFO: SECUDIR = /usr/sap/HXE/HDB90/hxehost/sec
      07:50:21.105 - INFO: SHELL = /bin/bash
      07:50:21.105 - INFO: SHLVL = 1
      07:50:21.105 - INFO: TERM = xterm
      07:50:21.105 - INFO: TINSTANCE = 90
      07:50:21.105 - INFO: TSAN_OPTIONS = exitcode=0:log_path=/usr/sap/HXE/HDB90/hxehost/trace/ThreadSanitizer_Report
      07:50:21.105 - INFO: USER = hxeadm
      07:50:21.105 - INFO: XDG_CONFIG_DIRS = /etc/xdg
      07:50:21.105 - INFO: XDG_DATA_DIRS = /usr/share
      07:50:21.105 - INFO: XKEYSYMDB = /usr/X11R6/lib/X11/XKeysymDB
      07:50:21.105 - INFO: XNLSPATH = /usr/X11R6/lib/X11/nls
      07:50:21.105 - INFO: _ = /hana/shared/HXE/global/hdb/install/bin/hdbupdrep
      07:50:21.105 - INFO: ---------------------------------------------------------
      07:50:21.105 - INFO: END: Environment Dump
      07:50:21.105 - INFO: ---------------------------------------------------------
      07:50:21.105 - INFO: -----------------------------------------------------------
      07:50:21.105 - INFO: END: Installer Information
      07:50:21.105 - INFO: -----------------------------------------------------------
      07:50:21.107 - INFO:

      SAP HANA Lifecycle Management - Update Repository 2.3.40
      ********************************************************

      07:50:21.107 - INFO: Start Date: 2018-04-17 - hdbupdrep
      07:50:21.107 - INFO: Log File ID: hdbupdrep_2018-04-17_07.50.20_14795
      07:50:21.107 - INFO: Checking configuration
      07:50:21.107 - INFO: Parameter 'content_directory' (ContentDir) is given via command line option, value = '/hana/shared/HXE/global/hdb/auto_content'
      07:50:21.107 - INFO: Parameter 'sid' (SID) is set with default value = 'HXE'
      07:50:21.120 - INFO: Performing secondary system check
      07:50:21.120 - INFO: Checking system replication mode
      07:50:21.121 - INFO: Starting external program /usr/sap/HXE/HDB90/exe/hdbnsutil
      07:50:21.121 - INFO: Command line is: /usr/sap/HXE/HDB90/exe/hdbnsutil -sr_state
      07:50:23.275 - INFO: Output line 1:
      07:50:23.275 - INFO: Output line 2: System Replication State
      07:50:23.275 - INFO: Output line 3: ~~~~~~~~~~~~~~~~~~~~~~~~
      07:50:23.275 - INFO: Output line 4:
      07:50:23.275 - INFO: Output line 5: online: true
      07:50:23.275 - INFO: Output line 6:
      07:50:23.275 - INFO: Output line 7: mode: none
      07:50:23.275 - INFO: Output line 8: done.
      07:50:23.305 - INFO: Program terminated with exit code 0
      07:50:23.305 - INFO: System replication mode is: none
      07:50:23.305 - INFO: Parameter 'user_store_key' (UserStoreKey) is not set
      07:50:23.762 - INFO: Parameter 'system_user' (SystemUser) is set by user (confirmed the default value), value = 'SYSTEM'
      07:50:26.688 - INFO: SYSTEM user password verified.
      07:50:26.689 - INFO: License check successfully performed.
      07:50:26.690 - INFO: Parameter 'system_user_password' (SQLSysPasswd) is set by user, value = '***'
      07:50:26.691 - INFO: Parameter 'delivery_unit' (DeliveryUnit) is not set
      07:50:26.696 - INFO: -----------------------------------------------------------
      07:50:26.696 - INFO: Importing delivery units...
      07:50:26.696 - INFO: -----------------------------------------------------------
      07:50:26.697 - INFO: Taking trace directory snapshot of '/hana/shared/HXE/HDB90/hxehost/trace/HXE'
      07:50:26.697 - INFO: Taking trace directory snapshot of '/hana/shared/HXE/HDB90/hxehost/trace'
      07:50:26.697 - INFO: Performing secondary system check
      07:50:26.698 - INFO: Checking system replication mode
      07:50:26.700 - INFO: Starting external program /hana/shared/HXE/HDB90/exe/hdbnsutil
      07:50:26.700 - INFO: Command line is: /hana/shared/HXE/HDB90/exe/hdbnsutil -sr_state
      07:50:28.920 - INFO: Output line 1:
      07:50:28.920 - INFO: Output line 2: System Replication State
      07:50:28.920 - INFO: Output line 3: ~~~~~~~~~~~~~~~~~~~~~~~~
      07:50:28.920 - INFO: Output line 4:
      07:50:28.920 - INFO: Output line 5: online: true
      07:50:28.920 - INFO: Output line 6:
      07:50:28.920 - INFO: Output line 7: mode: none
      07:50:28.920 - INFO: Output line 8: done.
      07:50:28.950 - INFO: Program terminated with exit code 0
      07:50:28.950 - INFO: System replication mode is: none
      07:50:28.951 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/AHCO_INA_SERVICE.tgz
      07:50:28.951 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/HANA_DT_BASE.tgz
      07:50:28.952 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/HANA_TA_CONFIG.tgz
      07:50:28.952 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/HANA_UI_INTEGRATION_1_SVC.tgz
      07:50:28.953 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/HANA_UI_INTEGRATION_2_CONTENT.tgz
      07:50:28.953 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/HANA_XS_BASE.tgz
      07:50:28.954 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/HANA_XS_DBUTILS.tgz
      07:50:28.954 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/HANA_XS_LM.tgz
      07:50:28.954 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/HDC_ADMIN.tgz
      07:50:28.955 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/HDC_BACKUP.tgz
      07:50:28.955 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/HDC_SEC_CP.tgz
      07:50:28.956 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/HDC_XS_BASE.tgz
      07:50:28.956 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/HDC_XS_LM.tgz
      07:50:28.956 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/SAPUI5_1.tgz
      07:50:28.957 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/XHANA_SEC_CP.tgz
      07:50:28.957 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/YHANA_BACKUP.tgz
      07:50:28.958 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/YHANA_HDBLCM.tgz
      07:50:28.958 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/YHANA_SEC_BASE.tgz
      07:50:28.959 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/ZHANA_ADMIN.tgz
      07:50:28.959 - INFO: Selected for import: /hana/shared/HXE/global/hdb/auto_content/ZHANA_WKLD_ANLZ.tgz
      07:50:28.960 - INFO: Connecting to database SYSTEMDB@hxehost:39013 encryption=off
      07:50:28.967 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/AHCO_INA_SERVICE.tgz (HCO_INA_SERVICE 6.1.003) skipped, same or newer version 6.1.003 already imported.
      07:50:28.967 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/HANA_DT_BASE.tgz (HANA_DT_BASE 1.3.27) skipped, same or newer version 1.3.27 already imported.
      07:50:28.967 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/HANA_TA_CONFIG.tgz (HANA_TA_CONFIG 2.0.3) skipped, same or newer version 2.0.3 already imported.
      07:50:28.967 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/HANA_UI_INTEGRATION_1_SVC.tgz (HANA_UI_INTEGRATION_SVC 1.11.1) skipped, same or newer version 1.11.1 already imported.
      07:50:28.968 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/HANA_UI_INTEGRATION_2_CONTENT.tgz (HANA_UI_INTEGRATION_CONTENT 1.11.1) skipped, same or newer version 1.11.1 already imported.
      07:50:28.968 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/HANA_XS_BASE.tgz (HANA_XS_BASE 2.0.3) skipped, same or newer version 2.0.3 already imported.
      07:50:28.968 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/HANA_XS_DBUTILS.tgz (HANA_XS_DBUTILS 1.11.9) skipped, same or newer version 1.11.9 already imported.
      07:50:28.968 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/HANA_XS_LM.tgz (HANA_XS_LM 1.6.18) skipped, same or newer version 1.6.18 already imported.
      07:50:28.968 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/HDC_ADMIN.tgz (HDC_ADMIN 2.0.1) skipped, same or newer version 2.0.1 already imported.
      07:50:28.968 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/HDC_BACKUP.tgz (HDC_BACKUP 2.0.1) skipped, same or newer version 2.0.1 already imported.
      07:50:28.968 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/HDC_SEC_CP.tgz (HDC_SEC_CP 2.0.1) skipped, same or newer version 2.0.1 already imported.
      07:50:28.968 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/HDC_XS_BASE.tgz (HDC_XS_BASE 2.0.6) skipped, same or newer version 2.0.6 already imported.
      07:50:28.968 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/HDC_XS_LM.tgz (HDC_XS_LM 2.0.6) skipped, same or newer version 2.0.6 already imported.
      07:50:28.968 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/SAPUI5_1.tgz (SAPUI5_1 1.28.51) skipped, same or newer version 1.28.51 already imported.
      07:50:28.968 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/XHANA_SEC_CP.tgz (HANA_SEC_CP 1.3.9) skipped, same or newer version 1.3.9 already imported.
      07:50:28.969 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/YHANA_BACKUP.tgz (HANA_BACKUP 2.0.0) skipped, same or newer version 2.0.0 already imported.
      07:50:28.969 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/YHANA_HDBLCM.tgz (HANA_HDBLCM 2.0.0) skipped, same or newer version 2.0.0 already imported.
      07:50:28.969 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/YHANA_SEC_BASE.tgz (HANA_SEC_BASE 1.3.9) skipped, same or newer version 1.3.9 already imported.
      07:50:28.969 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/ZHANA_ADMIN.tgz (HANA_ADMIN 2.0.3) skipped, same or newer version 2.0.3 already imported.
      07:50:28.969 - WRN : Import of delivery unit /hana/shared/HXE/global/hdb/auto_content/ZHANA_WKLD_ANLZ.tgz (HANA_WKLD_ANLZ 1.1.1) skipped, same or newer version 1.1.1 already imported.
      07:50:28.969 - INFO: No delivery units to import
      07:50:28.969 - INFO: -----------------------------------------------------------
      07:50:28.969 - INFO: END: Importing delivery units (start: 07:50:26.696 duration: 00:00:02)
      07:50:28.969 - INFO: -----------------------------------------------------------
      07:50:29.116 - INFO: Update Repository done

      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?

      Author's profile photo Stefan Dochev
      Stefan Dochev
      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
      Stefan

       

      Author's profile photo Stefan Dochev
      Stefan Dochev

      Furthermore 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'.

      Author's profile photo Lucia Subatin
      Lucia Subatin
      Blog Post Author

      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.

       

      Author's profile photo Stefan Dochev
      Stefan Dochev

      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

       

       

       

      Author's profile photo Lucia Subatin
      Lucia Subatin
      Blog Post Author

      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

      Author's profile photo Stefan Dochev
      Stefan Dochev

      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