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
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.
SAP Knowledge Base Article - Preview