1860493 - Out of memory during import migration to HANA | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1860493 - Out of memory during import migration to HANA

Symptom

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:

oom_pattern.png


Read more...

Environment

SAP HANA DATABASE

Product

SAP HANA, platform edition all versions

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.