Symptom
When looking at your Alerts tab in HANA Studio you see the below alert:
ID: 0 'Alert Internal statistics server problem'
Check Type:
Alert Internal statistics server problem
Alert:
[3] 304 division by zero undefined: search table error: [6859] AttributeEngine: divide by zero;object=_SYS_STATISTICS:#_SYS_XX_xxx_xxxxxx SNAPSHOT_ID: 2017-09-12 07:28:11.0000000.
Timestamp:
User Action:Resolve the problem. For more information, see the trace files. You may need to activate tracing first.
Also, in the indexserver trace file, you see:
[68257]{300052}[17/135844607] 2017-09-12 07:28:11.070320 i TraceContext TraceContext.cpp(00952) : UserName=, ApplicationUserName=_SYS_STATISTICS, ApplicationName=Embedded Statistics Server, ApplicationSource=running ID (3, deletion: no) for 12.09.2017 05:28:11 000 Tue, StatementHash=xxx
[68257]{300052}[17/135844607] 2017-09-12 07:28:11.070310 e expr ExpressionMemory.cpp(05804) : error during code execution at position 23: AttributeEngine: divide by zero(6859)
...
[68257]{300052}[17/135844607] 2017-09-12 07:28:11.070736 e trex_qo Evaluate.cpp(01190) : searchDocuments failed; rc: 6859 (AttributeEngine: divide by zero); table: _SYS_STATISTICS:#_SYS_QO_TMP_7f9037cd7800:600000000003a2e (t 504403158806631194); column: ACTIVE_STATUS(206)
[68257]{300052}[17/135844607] 2017-09-12 07:28:11.070777 e trex_qo OptimizerImpl.cpp(00543) : evaluate failed; rc: 6859 (AttributeEngine: divide by zero); table: _SYS_STATISTICS:
Read more...
Environment
SAP HANA Database 1.0
Product
SAP HANA 1.0, platform edition
Keywords
Alert Internal statistics server problem divide by zero , KBA , HAN-DB-MON , SAP HANA Monitoring , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.