Home / server / Questions

Questions[sap-hana](server)

Martin Hope
Thorsten Niehues
Asked: 2021-01-03 05:25:18 +0800 CST
  • 1

In installed SAP Hana according to How to install SAP Hana Express Edition 2.0 on Ubuntu 18.04 (Bionic Beaver) (issues have been commented in the blog above)

Following this I wanted to explore the XSA environment according to SAP HANA XS Advanced, explore the basic tools

Unfortunately I ran into a python error:

hxeadm@thorsten-VirtualBox:/usr/sap/HXE/HDB90> xs login
Python path configuration:
  PYTHONHOME = '/usr/sap/HXE/HDB90/exe/Python'
  PYTHONPATH = '/usr/sap/HXE/SYS/global/hdb/custom/python_support:/usr/sap/HXE/HDB90/exe/python_support:/usr/sap/HXE/HDB90/thorsten-virtualbox:/usr/sap/HXE/HDB90/exe:/usr/sap/HXE/HDB90/exe/testscripts:/usr/sap/HXE/HDB90/exe/Python/lib/python2.7'
  program name = '/usr/bin/python3'
  isolated = 0
  environment = 1
  user site = 1
  import site = 1
  sys._base_executable = '/usr/bin/python3'
  sys.base_prefix = '/usr/sap/HXE/HDB90/exe/Python'
  sys.base_exec_prefix = '/usr/sap/HXE/HDB90/exe/Python'
  sys.executable = '/usr/bin/python3'
  sys.prefix = '/usr/sap/HXE/HDB90/exe/Python'
  sys.exec_prefix = '/usr/sap/HXE/HDB90/exe/Python'
  sys.path = [
    '/usr/sap/HXE/SYS/global/hdb/custom/python_support',
    '/usr/sap/HXE/HDB90/exe/python_support',
    '/usr/sap/HXE/HDB90/thorsten-virtualbox',
    '/usr/sap/HXE/HDB90/exe',
    '/usr/sap/HXE/HDB90/exe/testscripts',
    '/usr/sap/HXE/HDB90/exe/Python/lib/python2.7',
    '/usr/sap/HXE/HDB90/exe/Python/lib/python38.zip',
    '/usr/sap/HXE/HDB90/exe/Python/lib/python3.8',
    '/usr/sap/HXE/HDB90/exe/Python/lib/python3.8/lib-dynload',
  ]
Fatal Python error: init_fs_encoding: failed to get the Python codec of the filesystem encoding
Python runtime state: core initialized
  File "/usr/sap/HXE/HDB90/exe/Python/lib/python2.7/encodings/__init__.py", line 123
    raise CodecRegistryError,\
                            ^
SyntaxError: invalid syntax

Current thread 0x00007f8d164ae740 (most recent call first):
<no Python frame>
hxeadm@thorsten-VirtualBox:/usr/sap/HXE/HDB90>

Anybody an idea or hint how to fix this?

python ubuntu-20.04 sap-hana
Martin Hope
Thorsten Niehues
Asked: 2016-01-16 08:13:52 +0800 CST
  • 0

Our SAP HANA database consumes a lot of memory - even though we do not have much data in it.

After some research:

select top 100 * from M_CS_TABLES order by MEMORY_SIZE_IN_TOTAL desc

I figured out that the STATISTICS_ALERTS_BASE table has a size of over 20.000.000.000 (twenty billion)

How to reduce or clear this table?

EDIT:

If the table gets huge it can make the admin panel in SAP HANA really slow. If so then truncate the table fixes the issue!

sap-hana