Skip to Content

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 !

To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

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

    (0) 
    1. Lucia Subatin
      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!

      (0) 
  2. 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?

    (0) 
  3. 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

     

    (0) 
    1. 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’.

      (0) 
      1. Lucia Subatin
        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.

         

        (1) 
    1. Lucia Subatin
      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

      (0) 
  4. 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

    (0) 

Leave a Reply