SAP Knowledge Base Article - Preview

2644242 - HANA Statistics server has been disabled after upgrade.

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-MON , SAP HANA Monitoring , Problem

About this page

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

Search for additional results

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