SAP Knowledge Base Article - Preview

3673244 - HANA out of memory event for statement hash 545dbc8b434b98bf99f50cb18eadfae2

Symptom

HANA out of memory event occurs while executing statement:

SELECT /* FDA WRITE */ DISTINCT  "D" . "PARTID" , "S" . "SUBKEY" , "D" . "TEXT", "D" . "COUNTER" , "G" . "PROGNAME" , "C" . "TRIGENTRY" , "D" . "TRIGOFFSET" ,"G" . "PROGDATE" , "G" . "PROGTIME" FROM ( "SRTMP_DATA" "D" INNER JOIN "SRTMP_PROC""C" ON "C" . "TRIGID" = "D" . "TRIGID" AND "C" . "TESTID" = "D" . "TESTID" AND"C" . "PARTID" = "D" . "PARTID" INNER JOIN "SRTMP_PROG" "G" ON "G" . "PROGID"= "C" . "PROGID" AND "G" . "TESTID" = "C" . "TESTID" AND "G" . "PARTID" = "C" ."PARTID" INNER JOIN "SRTMP_SUB" "S" ON "D" . "TESTID" = "S" . "TESTID" AND "D". "PARTID" = "S" . "PARTID" AND "D" . "SUBID" = "S" . "SUBID" ) , ? AS "t_00" ("C_0"INTEGER, "C_1" INTEGER, "C_2" INTEGER) WHERE "D" . "TRIGID" = "t_00" . "C_0"AND "D" . "TRIGOFFSET" = "t_00" . "C_1" AND "D" . "SUBID" = "t_00" . "C_2"

identified by the statement hash 545dbc8b434b98bf99f50cb18eadfae2.

This statement is linked to the ABAP program:
   RSQLM_UPDATE_DATA
scheduled as background job:
   SQLM_UPDATE_DATA/SCHEDULE
which in case of an HANA out of memory event terminates with ABAP runtimer error:
   DBSQL_SQL_ERROR


Read more...

Product

SAP ERP 6.0

Keywords

KBA , HAN-DB-PERF , SAP HANA Database Performance , BC-DWB-TOO-RTA , Runtime Analysis , 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.