SAP Knowledge Base Article - Preview

3610003 - DECLARE script leads to peak memory increasing rapidly in the SQL view of SAP Datasphere.

Symptom

After clicking "Start Data Persistency", the peak memory in the Data Integration Monitor log (accessed by Views Monitor) rapidly escalates. The memory information "XXX GiB of peak memory used in the view persistency runtime" showed in the log is significantly larger than the peak memory without the DECLARE script. For instance, with the script, the peak memory is less than 1 GB, whereas without the script, the peak memory surges to over 30 GB.


Read more...

Environment

SAP Datasphere

Product

SAP Datasphere all versions

Keywords

KBA , DS-MD-VIW , Views , DS-MD , Modeling (Data Builder) , HAN-CLS-HC , HANA Cloud Services HANA Cloud , 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.