2644242 - HANA Statistics server has been disabled | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2644242 - HANA Statistics server has been disabled

Symptom

  • Indexserver trace reports error :

    [45665]{364452}[147/53797279] 2018-05-01 13:16:27.650883 i SQLSessionCmd Statement.cc(06724) : INI configuration is changed by 364452, client ip=*.*.*.*, client port=**, query=alter system alter configuration ('nameserver.ini','SYSTEM') unset ('statisticsserver','active') with reconfigure
    [54842]{-1}[-1/-1] 2018-05-01 13:16:31.678951 i TraceContext TraceContext.cpp(00960) : UserName=
    [54842]{-1}[-1/-1] 2018-05-01 13:16:31.678940 i STATS_WORKER ConfigurableRegistry.cpp(00337) : start installation
    [54842]{-1}[-1/-1] 2018-05-01 13:16:32.220784 i TraceContext TraceContext.cpp(00960) : UserName=
    [54842]{-1}[-1/-1] 2018-05-01 13:16:32.220771 i STATS_WORKER ConfigurableRegistry.cpp(00385) : call _SYS_STATISTICS.Shared_Build_SR_Views ('', '')
    [47075]{300039}[18/53797303] 2018-05-01 13:16:33.072419 i TraceContext TraceContext.cpp(00960) : UserName=, StatementHash=712353bd3026e3af919ab794ee3a2edd
    [47075]{300039}[18/53797303] 2018-05-01 13:16:33.072408 w SQLScriptExecuto se_eapi_proxy.cc(00172) : Error <exception 71000362: _SYS_SR_SITE_Prod1
    > in preparation of internal statement: create view _SYS_STATISTICS.VIEW_ALERT_21_M_EVENTS as select * from "_SYS_SR_SITE_Prod*** ".M_EVENTS union all select * fROm SYS.M_EVENTS
    [47075]{300039}[18/53797303] 2018-05-01 13:16:33.072608 e LJIT cePopCustomLjit.cpp(00609) : Llang Runtime Error: Exception::SQLException362: invalid schema name: _SYS_SR_SITE_Prod1: line 1 col 69 (at pos 68)
    at main (line 204) ("_SYS_STATISTICS"."SHARED_CREATE_UNION_VIEW": line 35 col 3 (at pos 1784))
    [47075]{300039}[18/53797303] 2018-05-01 13:16:33.072621 e LJIT cePopCustomLjit.cpp(00628) : "_SYS_STATISTICS"."SHARED_CREATE_UNION_VIEW": line 35 col 3 (at pos 1784): [362] (range 3) invalid schema name exception: invalid

  • Statistics server remains disabled.

Read more...

Environment

SAP HANA Database 1.0, 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

embedded statistics server, fails, ESS , KBA , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.