SAP Knowledge Base Article - Preview

2143679 - How-To: Removing Primary Keys of SAP HANA Statistics Server Histories

Symptom

The memory footprint of the statisticsserver tables is significant.

The history collection of the statisticsserver fails for some tables (e.g. HOST_SERVICE_THREAD_SAMPLES_BASE, HOST_VOLUME_IO_DETAILED_STATISTICS_BASE or STATISTICS_ALERTS_BASE) with uniqueness related errors:

SQL error 301: unique constraint violated
TrexUpdate failed on table '_SYS_STATISTICS:<table_name>' with error: unique constraint violation in self check for table _SYS_STATISTICS:<table_name>en, constraint='$trexexternalkey$'

Read more...

Environment

SAP HANA

Product

SAP HANA, platform edition all versions

Keywords

no primary key on this table
invalid index name exception: invalid index , KBA , HAN-DB-MON , SAP HANA Monitoring , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.