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.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
- SAP HANA, platform edition 1.0
- SAP HANA, platform edition 2.0
Product
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.
SAP Knowledge Base Article - Preview