3658827 - ERROR [SQL-2048] column store error: add dynamic range: [2594] Encounter non-integer value in partition OTHERS

• Dynamic and automatic range partitioning is not occurring as expected for the OTHERS partition, based on a dynamic interval range defined in the partition DDL command.
• Upon further investigation into the local Tenant indexserver trace file(s), the following errors are observed :

[30677]{223923}[-1/-1] 2025-09-16 01:11:38.962846 i TraceContext     TraceContext.cpp(01371) : UserName=, StatementHash=0220cbf9672d8338bb4a772efd68260f, StatementExecutionID=844434489255070
[30677]{223923}[-1/-1] 2025-09-16 01:11:38.962846 e partitioning     DynamicRange.cpp(03705) : Encounter non-integer value in partition OTHERS: 
[30677]{-1}[1108/-1] 2025-09-16 01:11:38.974719 e partitioning     DynamicRange.cpp(00813) : SQL preparation or execution of
'ALTER TABLE "SCHEMA"."CDPOS" ADD PARTITION FROM OTHERS'
failed:
column store error: add dynamic range: [2594] Encounter non-integer value in partition OTHERS:  at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_metadata.cc:1660
ERROR [SQL-2048] column store error: add dynamic range: [2594] Encounter non-integer value in partition OTHERS:  at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_metadata.cc:1660
exception  1: no.71002048  (ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_metadata.cc:1660) TID: 30677
    add dynamic range: [2594] Encounter non-integer value in partition OTHERS: 
NO exception throw location recorded. Stack generation suppressed.
exception type information:

• The partitioning specification looks something very similar to this :

ALTER TABLE SCHEMA.CDPOS PARTITION BY RANGE (CHANGENR)((PARTITION '0000000000' <= VALUES < '0200000000',PARTITION '0200000000' <= VALUES < '0400000000',PARTITION '0400000000' <= VALUES < '0600000000',
PARTITION '0600000000' <= VALUES < '0800000000',PARTITION '0800000000' <= VALUES < '1000000000',PARTITION '1000000000' <= VALUES < '1200000000',PARTITION '1200000000' <= VALUES < '1400000000',PARTITION OTHERS DYNAMIC INTERVAL 200000000));

SAP HANA, Platform Edition 2.0   

KBA , HAN-DB , SAP HANA Database , Problem