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