Symptom
Cross checking the indexserver trace, the tables being updated are encountering the error
Maximum number of rows per partition reached. Allowed record count exceeded
indexserver_alert_xxxx.trc
[10982]\{301198\}[288/9153141970] 2025-05-03 04:17:18.124031 e UdivMethods UdivMethods.cpp(00145) : Please try merge + optimize compression before adding new rows. MaxUdivs: main=2092504894, delta1=7494904, delta2=0, maxRowId=2100131006, calculated with numRows=636
[10982]\{301198\}[288/9153141970] 2025-05-03 04:17:18.124439 e table_update TableUpdate.cpp(03961) : execute_context() caught exception for table SAPGRP:_SYS_SPLIT_FAGL_SPLINFO_VAL~1, rc=17: exception 1: no.70000017 (ims_search_api/UdivMethods.cpp:58) TID: 10982
Maximum number of rows per partition reached. Allowed record count exceeded: current record count 2099999798, added record count 636, maximum allowed record count 2100000000 in table SAPGRP:_SYS_SPLIT_FAGL_SPLINFO_VAL~1$delta_1$
[10982]\{301198\}[288/9153141970] 2025-05-03 04:17:18.169121 e table_update TableUpdate.cpp(01278) : trace_basics called from 'setLastError', this=0x00007cb5e563c800, *getPreparedInfo()=0x00007be544c09400, table 'SAPGRP:_SYS_SPLIT_FAGL_SPLINFO_VAL~1', action=INSERT,
[10982]\{301198\}[288/9153141970] 2025-05-03 04:17:18.169169 e SQLUpdate ColumnStorageChange.cc(00094) : TrexColumnUpdate failed on table 'SAPGRP:_SYS_SPLIT_FAGL_SPLINFO_VAL~1' with error: Maximum number of rows per partition reached. Allowed record count exceeded: current record count 2099999798, added record count 636, maximum allowed record count 2100000000 in table SAPGRP:_SYS_SPLIT_FAGL_SPLINFO_VAL~1$delta_1$, rc=17
Read more...
Environment
SAP HANA PLEATFORM EDITION 2.0
Product
Keywords
update, 2 billion, column store, partition, SM13 , KBA , HAN-LM-UPG-DB , Upgrade of HANA Database , 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.
SAP Knowledge Base Article - Preview