Out of virtual and/or logical memory, allocating 0.5 MB Version 9.0

[#1]

Hi There,

I've searched through various other posts but none seem to match the current problem I am having. I have a QVW document that is 7mb.

It opens fine in Qlik version 9.0 however after about 5-10 Minutes of being open I get the Out of virtual and/or logical memory, allocating 0.5 MB error and Qlik will then crash. Strange thing is I didn't have this problem with the same document on 8.20. I've tried it on my colleagues pc's and they experience the same problem in version 9.0

The document does include a number of partial reloads, however even if I don't run the Partial reload it will eventually crash. Running on 32bit 2gb of ram 2.40Ghz

Any help would be greatly appreciated

[#2]

Check out your expressions within tables in your documents. Chances are you have a large if statement that shouldn't be an if statement.

Also, do you have any synthetic keys? Crtl + T to see if you do. They will be labeled $syn

[#3]

Thanks for the reply, No synthetic Keys. There are a nuber of If statments, for example

Count(IF(daystart(now())=daystart(CallsTimeoutDate),AgentID,null()))/Count(IF(daystart(now())=daystart(DayUpdated2),StartRingTime,null()))

[#4]

That if statement will probably do it. Are you going to be uploading to a server then running this?

You can do a number of things.

1.) http://community.qlik.com/wikis/qlikview-wiki/using-flags-to-avoid-if-formulas.aspx -

Change your if statement to follow the rules above and use flags. This will help solve your issue.

2.) You can also change (doesn't always help) settings -> user preferences -> Objects tab -> check "ignore calculation limits"

[Anonymous · Accepted solution]

I bet it is now() function that is the maijor reason of the problem. Try now(0) or now(2) instead.
Now() or now(1) checks time non-stop and takes all CPU, especially in QV9.

[johnw]

I believe they changed the definition of now() in 8.5. If I remember correctly, now() in 8.2 was when the reload started. In 8.5 and up, now() means NOW. So using it an expression will work fine in 8.2, but will kill your CPU in 8.5 and up. I believe we complained to QlikTech at the time, as we had to change a LOT of applications, but it is what it is.

[#7]

That explains it! that great thanks for your hep all.