2212518 - HANA error maximum number of rows per partition reached

You receive an error "maximum number of rows per partition reached for table" when adding data to a table.

An error similar to the below can also be found in the indexserver trace file:

• UdivMethods.cpp(00134) : Maximum number of rows per partition reached for '<TABLE_NAME>'. Please try merge + optimize compression before adding new rows. Delta-Part=1
• trex_update.cc(02225) : TrexUpdate failed on table '<TABLE_NAME>' with error: Maximum number of rows per partition reached, rc=17
• ColumnStorageChange.cc(00094) : TrexColumnUpdate failed on table '<TABLE_NAME>' with error: Maximum number of rows per partition reached.  Allowed record count exceeded: current record count <COUNT>, added record count <COUNT>, maximum allowed record count 2100000000 in table '<TABLE_NAME>', rc=17

A similar error can be seen in the indexserver trace file when partitioning a table:

• partitioning Split.cpp(02409) : Number of rows: xxx for target partition: '<SCHEMA>.<TABLE_NAME>' could exceed physical limit of ...

In SAP systems like S/4HANA you can also find error messages like the following:

• SQL code: 2055, SQL text: maximum number of rows per table or partition reached: <SCHEMA>.<TABLE_NAME>
• ***LOG BY4=> sql error 2055   performing INS on table <TABLE NAME>
• ***LOG BY0=> maximum number of rows per table or partition reached: ' <SCHEMA>.<TABLE_NAME>'
• SQLERRTEXT : maximum number of rows per table or partition reached: ' <SCHEMA>.<TABLE_NAME>'

SAP HANA, platform edition

sql error 2055 max rows per partition, DBSQL_SQL_ERROR, RECORD_COUNT  , KBA , HAN-DB-ENG , SAP HANA DB Engines , HAN-DB-PER , SAP HANA Database Persistence , How To