SAP Knowledge Base Article - Preview

1910188 - How to handle HANA Alert 27: ‘Record count of column-store table partitions’

Symptom

When checking the Alerts tab in HANA there is an alert called “SCHEMANAME.TABLENAME partition 2 has record count 2001915”.

  • For HANA Studio you would find the alert by going to Administration Console -> Alerts -> Show: all alerts.

1.png

  • For Solution Manager you would find the alert using transaction DBACOCKPIT -> choose HANA system -> expand Current Status -> Alerts.

To check the exact time of the alert please go to Administration Console -> Alerts -> double click on the alert.

2.jpg

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 Database

Product

SAP HANA, platform edition all versions

Keywords

Operations Recommendation; #OpsRec-HANA; threshold value; Check record count of not partitioned column table; Configure Check Settings; partitioned; parts; PARTITION BY; , 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.