SAP Knowledge Base Article - Preview

3039026 - [2594] DynamicRangePartitioning error

Symptom

In the indexserver trace the below errors can be found:

YYYY-MM-DD HH:MM:SS.MS e partitioning     DynamicRangePartitioning.cpp(00586) : DynamicRangePartitioning::calculateNewRange: Minimum value in <partition name> part <entry range value> is smaller than lower bound of new range <partition lower range>
YYYY-MM-DD HH:MM:SS.MS e partitioning     DynamicRange.cpp(02677) : Unable to calculate next range for <SID>::<schema>:<table name> (t xxxxxx):exception 1: no.70002594 (partitioning/DynamicRangePartitioning.cpp:587) TID: <TID>
  DynamicRangePartitioning: Minimum value in the <partition name> part is smaller than the least possible lower bound for a new range.
YYYY-MM-DD HH:MM:SS.MS e partitioning DynamicRange.cpp(00621) : SQL preparation or execution of <SQL statement> failed:
column store error: add dynamic range: [2594] DynamicRangePartitioning: Minimum value in the <partition name> part is smaller than the least possible lower bound for a new range.

For example:

YYYY-MM-DD HH:MM:SS.MS e partitioning     DynamicRangePartitioning.cpp(00586) : DynamicRangePartitioning::calculateNewRange: Minimum value in OTHERS part 20101010 is smaller than lower bound of new range 20210202
YYYY-MM-DD HH:MM:SS.MS e partitioning     DynamicRange.cpp(02677) : Unable to calculate next range for <SID>::<schema>:<table name> (t xxxxxx):exception 1: no.70002594 (partitioning/DynamicRangePartitioning.cpp:587) TID: <TID>
  DynamicRangePartitioning: Minimum value in the <partition name> part is smaller than the least possible lower bound for a new range.
YYYY-MM-DD HH:MM:SS.MS e partitioning DynamicRange.cpp(00621) : SQL preparation or execution of <SQL statement> failed:
column store error: add dynamic range: [2594] DynamicRangePartitioning: Minimum value in the OTHERS part is smaller than the least possible lower bound for a new range.


Read more...

Environment

SAP HANA, platform edition 1.0
SAP HANA, platform edition 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

Hana 1.0, Hana 2.0, partitioning, dynamic range, dynamic range partitioning, no.70002594, DynamicRangePartitioning, [2594], [2594] DynamicRangePartitioning , 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.