3382604 - Target Range partitioning does not have a OTHERS part and cannot be mapped to source Range partitioning

• A table (re-)partition fails with the following error as observed in the indexserver trace on a HANA Tenant DB :

indexserver_host.<>.<>.trc

[251797]\{340994\}[-1/-1] 2023-09-17 07:24:29.134227 i TraceContext     TraceContext.cpp(01269) : UserName=SAPSID, ApplicationUserName=<>, ApplicationName=ABAP:<>, ApplicationSource=CL_SQL_STATEMENT==============CP:698, Client=100, StatementHash=75edd289152fce57760cee7ec0e0e315, EppRootContextId=005056910CD71EDE95A4E3B64485EF40, EppTransactionId=F78563ADB98A06B0E0065068E23701F1, EppConnectionId=00000000000000000000000000000000, EppConnectionCounter=0, EppComponentName=EDP/host_SID_40, EppAction=RDAAG_PARTITIONING_FOR_JOB, StatementExecutionID=844441979655462
[251797]\{340994\}[-1/-1] 2023-09-17 07:24:29.134213 e partitioning     Split.cpp(03136) : Target Range partitioning does not have a OTHERS part and cannot be mapped to source Range partitioning. (2593, HDP::SAPSID:CDPOS (t 380783))
[251797]\{340994\}[-1/-1] 2023-09-17 07:24:29.134264 e partitioning     Split.cpp(02671) : Data in source table does not fit target partition spec. (2593, SID::SAPSID:CDPOS (t 380783))
[251797]\{340994\}[-1/-1] 2023-09-17 07:24:29.134269 e partitioning     Split.cpp(02464) : Initialization failed. (2593, SID::SAPABC:CDPOS (t 380783))

• This can also be encountered in the SAPGUI work process traces as part of a Data Aging run for time selecition tables through the DAGPTM /DAGRUN transaction codes :

Date       Time     Message text

17.09.2023 07:19:40 Job RDAAG_PARTITIONING_FOR_JOB 07193600 started
17.09.2023 07:19:40 Step 001 started (program RDAAG_PARTITIONING_FOR_JOB, variant &0000000000003, user ID <>)
17.09.2023 07:19:40 Partitioning started for table CDPOS
17.09.2023 07:24:29 A database error occured. The error message in the database was: "column store error: fail to alter partition: [2593] Error during split/merge operation;Target Range partitioning does not have a OTHE
17.09.2023 07:24:29 Job finished

C  SQLCODE    : 2048
C  SQLERRTEXT : column store error: fail to alter partition: [2593] Error during split/merge operation;Target Range \
C               partitioning does not have a OTHERS part and cannot be mapped to source Range partitioning.,object=H\
C               DP::SAPHDP:CDPOSen
C  SQL COMMAND: ALTER TABLE "CDPOS" PARTITION BY 'RANGE[TIME SELECTION: PAGED ATTRIBUTES, NO UNIQUE CHECK] _DATAAGIN\
C               G 00000000,20230101-20230401,20230401-20230701,20230701-20231001,20231001-20240101';
B  ***LOG BY2=> sql error 2048 performing EXE [dbds         799]
B  ***LOG BY0=> column store error: fail to alter partition: [2593] Error during split/merge operation;Target Range partitioning does not have a OTHERS part and cannot be mapped to source Range partitioning.,object=HDP::SAPSID:CDPOSen [dbds         799] 

KBA , HAN-DB , SAP HANA Database , BC-CCM-DAG , Data Aging , Problem