SAP Knowledge Base Article - Preview

3627962 - Query on view NSDM_V_MCHBH fails with out of memory error

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.