SAP Knowledge Base Article - Preview

3714726 - Partitioning of large table stuck at RepartitionDeltaAndMVCC or UpdateRuntime

Symptom

  • Partitioning of a table containing over 2 billion rows is stuck or fails in SAP HANA.
  • The process halts specifically at "RepartitionDeltaAndMVCC"
  • You encounter the following errors during the process:
    Error: "statement_allocation_limit error"
    Error: "transaction rolled back by lock wait timeout: Lock-wait time out exceeded"
  • The issue persists even after re-execution attempts.


Read more...

Environment

SAP HANA, platform edition

Product

SAP HANA, platform edition all versions

Keywords

SAP HANA partitioning, table partitioning stuck, RepartitionDeltaAndMVCC, lock wait timeout, statement allocation limit error, primary index constraints, table recreation, data consistency, SAP HANA troubleshooting, database partitioning errors. , KBA , HAN-DB-ENG , SAP HANA DB Engines , 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.