SAP Datasphere: Cannot allocate enough memory:Allocation failed; Reason: booked memory limit reached

[LMichael]

Good day,

I have installed the Finance Foundation business content on SAP Datasphere and am attempting to preview data from the GLACCOUNTLINEITEMRAWDATA object (equivalent to ACDOCA), which contains 600 million records.

Current Datasphere Tenant Configuration: 192GB disk space and 48GB RAM

I am working with an analytical model that has variables to limit the data; however, I am encountering an error that states: "Cannot allocate enough memory: Allocation failed; Reason: booked memory limit reached (SAP Note 3191224)." 

I have reviewed the SAP note but am still unable to preview the data. Has anyone else experienced this issue, and how was it resolved? Thank you for your assistance.

SAP Datasphere SAP HANA Cloud, SAP HANA database 

[LMichael]

@Martin_Kuma, @JulianJuraske , @ClemSteich , @MKreitlein , @TuncayKaraca I have noticed your valuable contributions to the community and was wondering if you could provide any input on the issue I am currently facing. Your advice would be greatly appreciated. Thanks

[JulianJuraske]

The 1st Level Approach would be to Use the View Analyzer. If you need more details you should use planviz in order to identify the root cause in your datamodel https://community.sap.com/t5/technology-blogs-by-members/performance-analysis-in-the-sap-datasphere/...

[Martin_Kuma]

I would persist the model-view.

If it fails on OoM you can:

#create partitions (f.e. year, ...) and persist each partition

#persist sub-views until you do not get the OoM