HANA Calculation View Activation takes very long / memory overflow

[PH]

Hi all,

when trying to activate a HANA Calculation View which uses 2 other calculation views (based on external views on BW DSOs), the status "Running" in the lower right of the HANA Studio (or Eclipse) stays for very long (more than 10 minutes) and I observe high CPU consumption on my PC for hdbstudio.exe (or eclipse.exe).

Often, I also get the warning, that an OutOfMemoryError occured and that hdbstudio.exe needs to be closed. If working with Eclipse, then eclipse.exe is simply closed after some time (probably also due to OutOfMemoryError)...

I configured -Xmx parameter with 2 GB (and even tested 3 GB).

The calculation view is not used anywhere else, that is it is not a "child view" in any other calculation view.

Where and how can I check, where the activation process "looses" the time? Is it possible to somehow track/debug, what the activation is actually doing?

I am using Eclipse 4.7 with HANA Tools 2.3.34. We use the HANA as the database for a BW on HANA system and we want to leverage mixed-mode modelling scenarios, where we

Any help is much appreciated.

[shyam_uthaman]

Hi,

I answered a similar question recently -->Is-there-any-particular-reason-why-hana-views-take-long-time-to-activate

Check if you have similar symptoms. Hope this helps.

Thanks,

Shyam

[eason_chen]

Hi,

For OOM issue of your HANA studio, I would suggest you configured -Xmx to a higher value e.g. 4gb, 8gb for test.
For performance issue of activation the view, you could analyze it further by generating runtime dump with 2 minutes interval during the activation. It could provide you more detailed information of what HANA is doing.
You may also refer to following note and check if it helps.
2638713 - Performance Degradation During Object Re-Validation

Best Regards,
Eason Chen