SAP Knowledge Base Article - Preview

3034420 - Cannot re-create partition in DAGPTM

Symptom

After merged existing data aging partitions for table and make sure no partition exists in table any more.
But when try to re-create partition in DAGPTM, it failed with error:

Data aging partitions can be created at the second level only if the table is hash partitioned at the first level.

In the system logs in transaction SM21, the below SQL error is displayed

Database error 2048 at EXE column store error: process parameters error: [2594] General partitioning error;Cannot use PARTITION_SPEC_SET_RANGE (Quic Aging) on tables with PAGE LOADABLE attributes.

Be aware that data aging undo and merging the partitions should be done in rare circumstances only.


Read more...

Environment

  •  SAP HANA Platform Edition 1.0
  •  SAP HANA Platform Edition 2.0

Product

SAP HANA, platform edition all versions

Keywords

Data aging partition, second level, first level, column loadable, page loadable , KBA , HAN-DB , SAP HANA Database , BC-CCM-DAG , Data Aging , 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.