Symptom
Information is required to know how to prevent the embedded statistics server on HANA from gathering too many HANA alerts for e-mail processing to a recipient list.
- Minicheck results shows that there are many alerts pending in table _SYS_STATISTICS.STATISTICS_EMAIL_PROCESSING with check ID :
M0730 - Pending e-mails older than 3 days
- This can be confirmed via commands :
select count(*) from _SYS_STATISTICS.STATISTICS_EMAIL_PROCESSING where state='New'
or
SQL: "HANA_StatisticsServer_MailProcessing" as per 1969700 - SQL Statement Collection for SAP HANA
Read more...
Environment
- SAP HANA Database Platform Edition 1.0
- SAP HANA Database Platform Edition 2.0
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0
Keywords
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.