Register Login

OOM Situations- HANA Memory Problems

Updated May 18, 2018

Which indications exist for SAP HANA memory problems?

May I Know the existence of indication for SAP HANA memory problems?


Comments

  • 28 Jan 2015 6:24 pm Shalesh Singh Helpful Answer

    The following error messages can indicate OOM situations. Be aware that some of the errors can also be issued in other scenarios. To make sure that they are really memory related, you have to check the related trace file.

    SQL error -10108: Session has been reconnected

    SQL error 129 while accessing table 

    transaction rolled back by an internal error: exception during deltalog replay.

    transaction rolled back by an internal error: TableUpdate failed

    transaction rolled back by an internal error: exception

    1000002: Allocation failed ; $size$=1191936; $name$=TableUpdate; $type$=pool;

    $inuse_count$=2180; $allocated_size$=8180736; $alignment$=16#

    transaction rolled back by an internal error: TrexUpdate

    failed on table with error:

    commitOptimizeAttributes() failed with rc=6900, Attribute engine

    failed;object=$delta_1$en, rc=6900 - enforce TX rollback

    transaction rolled back by an internal error: TrexUpdate

    failed on table '' with error: Attribute load

    failed;index=en,attribute='$trexexternalkey$' (207), rc=6923 - enforce TX rollback

    transaction rolled back by an internal error: TrexUpdate

    failed on table '' with error: AttributeEngine: not enough

    memory, rc=6952 - enforce TX rollback

    SQL error 403 while accessing table 

    internal error: ""."": [133] (range 2)

    SQL error 2048 while accessing table 

    column store error: search table error: [9] Memory allocation failed

    column store error: search table error: [1999] general error (no further information available)

    column store error: search table error: [2575] flatten scenario failed; Allocation failed

    column store error: search table error: [6900] Attribute engine failed

    column store error: search table error: [6923] Attribute load failed

    column store error: search table error: [6952] Error during optimizer search

    column store error: search table error: [6952] AttributeEngine: not enough memory

    SQL error 3584 while accessing table

    distributed SQL error: [9] Memory allocation failed

    distributed SQL error: [2617] executor: plan operation execution failed with an exception

    SQL error 3587 at CON

    invalid protocol or service shutdown during distributed query execution: 

    [2613] executor: communication problem


×