topic QlikView memory leak demo in QlikView

QlikView memory leak demo

mrybalko — Sat, 16 Nov 2024 20:02:56 GMT

Hello

Our team has found small qvw that consumed about 1TB RAM and crushed production servers. It has only 8k rows.

We investigated the problem and created smaIl demo app. Beware: demo will hang your desktop\server.

Tested on April 19 SR1 and 12.0 SR2

Steps:

Combochart
Two expressions
First expression should have position Right (top)
Second expression should return 0\0 value and have Static step and Static max properties

Re: QlikView memory leak demo

dplr-rn — Thu, 19 Sep 2019 17:30:01 GMT

interesting. did you find a solution?

Re: QlikView memory leak demo

marcus_sommer — Fri, 20 Sep 2019 10:35:58 GMT

I'm not sure if here is really a memory leak from the expression point of view. The used expression of: sum(0) / sum(0) must create some kind of a cartesian product and it seemed that any of the chart-settings - I didn't went through everything but could imagine that it are the axis-settings which couldn't handle it and repeat it again and again.

If I create a new chart and just apply your expressions there is no abnormality. Another cause could just be that this chart is corrupted. Therefore I suggest to create a new one from the scratch and and adjust one property after another and if it worked the origin object was corrupt and if it chrashed again you know your last adjusting and therefore the cause.

Beside this there might be other ways to apply some special features to enforce a certain view than using to the datamodel non related expressions.

- Marcus