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.