Symptom
- 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]
Read more...
Product
SAP HANA, platform edition 2.0
Keywords
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.