SAP Knowledge Base Article - Preview

2994267 - HANA DB partitioning is failing with out of memory error

Symptom

  • The partitioning is failing because of memory issues which was caused by large tables.
  • In this case it was an ACDOCA table, but can be any table with large number of records.
  • If you collect the full system info dump, here you can find the out of memory dump where you can see the following top allocator:

    Top "M_HEAP_MEMORY" allocators (component, name, size). Ordered descending by exclusive_size_in_use.
    1: Column Store Tables:                        Pool/ColumnStore/Main/Uncompressed                                   1.65tb (1698287448416b)

    As we can see it almost reached the global allocation limit: GLOBAL_ALLOCATION_LIMIT (GAL) = 1.73tb (1932601048472b)


Read more...

Environment

SAP HANA, platform edition

Product

SAP HANA, platform edition 2.0 ; SAP HANA, platform edition all versions

Keywords

ACDOCA, Uncompressed, ColumnStore, Data Management, partitioning failing , 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.