1860493 - Out of memory during import migration to HANA

You are performing a data migration to HANA and you face an out of memory.

• The import logs are showing lines such as the ones below:

------
(...)
DbSl Trace:   execute(), rc=1, rcSQL=2048 (column store error: merge delta index error:  [6924] Attribute save failed)

DbSl Trace: EXECUTE on connection 0, rc=2048 (column store error: merge delta index error:  [6924] Attribute save failed)

(DB) ERROR: DDL statement failed
 ( UPDATE "<TABLE_MIGRATED>" MERGE DELTA INDEX )
 DbSlExecute: rc = 99
  (SQL error 2048)
  error message returned by DbSl: column store error: merge delta index error:  [6924] Attribute save failed
(...)

(DB) INFO: <TABLE_MIGRATED> created

(DB) INFO: <TABLE_MIGRATED> unloaded

(DB) INFO: disconnected from DB

-------

       Or:

-------

(...)

(DB) ERROR: DbSlErrorMsg rc = 99

DbSl Trace: status of row 1/3360, status=-2, rc=129

DbSl Trace:   execute() of C_0002, #rec=0, rc=1, rcSQL=129
 (transaction rolled back by an internal error: Memory allocation failed)

DbSl Trace: EXECUTE on connection 0, rc=129 (transaction rolled back by an internal error: Memory allocation failed)

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed
  rc = 99, table "TABLE_MIGRATED" (SQL error 129)
  error message returned by DbSl:  transaction rolled back by an internal error:  Memory allocation failed
(DB) INFO: disconnected from DB
(...)
-------

• HANA diagnosis files tab you can see some indexserver*rtedump*.oom.trc and indexserver*.unloads.*.trc files during the time the SAPinst failed. You can also see the following information on the indexserver trace alerts:

-------
[9781]{0}[-2091417] 2013-05-05 11:11:09.313132 e SERVER_TRACE DeltaIndexManager.cpp(10405) : Caught exception merging attribute: exception  1: no.1000002  (ltt/impl/memory.cpp:64)
    Out of memory ; $size$=21994186096; $name$=build-reverse-index; $type$=TempAllocator
[8928]{0}[-2091417] 2013-05-05 11:11:09.479786 e SERVER_TRACE DeltaIndexManager.cpp(08080) :  mergeDeltaIndex failed for SAPSID: TABLE_MIGRATED (73358) rc=2450
[8928]{0}[-2091417] 2013-05-05 11:11:09.613813 e SERVER_TRACE DeltaIndexManager.cpp(08829) : do rollbackDeltaMerge merge for idx SAPSID:TABLE_MIGRATED(73358)
-------

• HANA Studio Performance load graphics may show a pattern such as the one below:

SAP HANA DATABASE

oom; sapinst; merge; hardmerge; critical_merge_decision_func; mergedog; , KBA , HAN-DB , SAP HANA Database , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , How To