Activate internal user failed with insufficient privilege

[scott_xu]

Hi, I noticed that one internal user _SYS_STATISTICS is inactivated in our HANA database. When I tried to activate it, I got following error message. Does anyone know how to resolve it?

Thanks.

Scott

[Former Member]

Hi Scott,

Can you check the HANA Version on your Appliance and check if you have Embedded Statistics Server

This is an expected behavior for HANA systems that have Embedded Statistics Server(ESS) activated

you can check the status of the ESS by executing the below query on SQL Console

SELECT * FROM _SYS_STATISTICS.STATISTICS_PROPERTIES where key='internal.installation.state'

You must see output of columns

KEY                                         VALUE

internal.installation.state      Done (okay) since "Date when ESS was activated"

If this is the case do not attempt to change the state of the user _SYS_STATISTICS

Hope this helps

Sunil

[scott_xu]

Hi Sunil,

The HANA version is 1.00.097.01.1436865239

When I run your script, I got

KEY                                   VALUE

internal.installation.state      Done (okay) since 2015-09-22 13:01:01.1920000 local time:2015-09-22 09:01:01.1920000

So I can let the user inactivate, right? Thanks

[Former Member]

Hi Scott,

yes based on the result you shared please do not take any action

Is this a new HANA install you had completed this week?

starting from SPS09 ESS is enabled by default during installation and this seems to be the case with your new system

thank you

Sunil

[scott_xu]

Thanks.