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:
Read more...
Environment
SAP HANA DATABASE
Product
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.