Symptom
The following SELECT statement is using too much memory on HANA database and failing with out of memory error:
Hash: 2cb15cdb9c439baa18c5feea216de854
SQL:
SELECT
DISTINCT "MANDT" , "MATNR" , "WERKS" , "LGORT" ,
"CHARG" , "LFGJA" , "LFMON" , "CLABS" , "CUMLM" ,
"CINSM" , "CEINM" , "CSPEM" , "CRETM" , "/CWM/CLABS" ,
"/CWM/CUMLM" , "/CWM/CINSM" , "/CWM/CEINM" , "/CWM/CSPEM" ,
"/CWM/CRETM"
FROM
/* Redirected table: MCHBH */ "NSDM_V_MCHBH" "MCHBH"
WHERE
"MANDT" = ? AND
"MATNR" = ? AND
"WERKS" = ? AND
"LGORT" = ? AND
"CHARG" = ? AND
"LFGJA" = ? AND
"LFMON" = ?
Read more...
Environment
SAP HANA 2.0
Keywords
"Post Goods Movement", VL02N, 2cb15cdb9c439baa18c5feea216de854 , KBA , HAN-DB-PERF , SAP HANA Database Performance , 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