topic Allocated Memory Exceeded in QlikView

Allocated Memory Exceeded

sunny_talwar — Wed, 22 Apr 2015 13:25:10 GMT

Hi Qlikers,

I have an issue where I have designed which looks and works perfectly until I close it down and reopen it to see "Allocated Memory Exceeded on some of the charts. Then when I reload the application, everything comes back and as long as I don't close the application, things look fine, but if I close it again the problem comes back. I saw a similar post Allocated memory exceeded on the community, but the solution is not very helpful as I wouldn't want to reload my application every time I open it.

Is there a way to trouble shoot what exactly is the problem here?

Any inputs would be greatly appreciated.

Best,

Sunny

Re: Allocated Memory Exceeded

MK_QSL — Wed, 22 Apr 2015 13:28:49 GMT

Try to check the dimension and expressions you have used in your table or chart...

Sometimes due to join fails between tables and still you are using different tables fields in your same table, this problem occurs.

You can do save as the application and only load 10 or 20 rows for each tables using Limited Load...

Now analyse whether the Chart/Tables giving correct result or not...

My guessing is due to Cartesian Join/Product this is happening... !

Re: Allocated Memory Exceeded

sunny_talwar — Wed, 22 Apr 2015 13:37:47 GMT

Thanks for quick response Manish Kachhia‌. My data model looks like this (hidding the table names and fields, but you will see how the basic structure is)

Does this has something to do with the error?

I have only 64 rows of data in that Fact Table.

Re: Allocated Memory Exceeded

Anonymous — Wed, 22 Apr 2015 13:40:49 GMT

in your data model two tables are stand alone .. Are you using any field from those table in your charts calculation or dimension ?

Thanks

BKC

Re: Allocated Memory Exceeded

sunny_talwar — Wed, 22 Apr 2015 13:43:05 GMT

I am using the fields from the top data Island table.

Re: Allocated Memory Exceeded

MK_QSL — Wed, 22 Apr 2015 13:46:26 GMT

Looks like your island table is making Cartesian product.

Can you provide the expressions your have used?

Re: Allocated Memory Exceeded

sunny_talwar — Wed, 22 Apr 2015 13:48:50 GMT

Edits in Red

The problem seems to be related to a variable I have created which use Match and Pick function:

(If(Match(FieldfromDataIslandTable, 1, 2, 3), Pick(Field1fromGroupedTable, 100, 150), 0) +

...

IfMatch(FieldfromDataIslandTable, 1, 2), Pick(Field6fromGroupedTable, 100, 50), 0))/

(If(Match(FieldfromDataIslandTable, 1, 2, 3), 1, 0) +

...

If(Match(FieldfromDataIslandTable, 1, 2), 1, 0))

Is there anything wrong with the above structure?

Best,

Sunny

Re: Allocated Memory Exceeded

sunny_talwar — Wed, 22 Apr 2015 13:50:46 GMT

That might be true, but why is everything perfectly fine once it is reloaded?

Re: Allocated Memory Exceeded

MK_QSL — Wed, 22 Apr 2015 14:04:34 GMT

Can't tell you without looking more detailed version..

Re: Allocated Memory Exceeded

Anonymous — Wed, 22 Apr 2015 14:04:48 GMT

Sunny because of many if statements in the front end it is using more resources when you first open the app. because the more resources will be consumed when you first open the app. Once the app is opened and if you reload it will not take more resources to populate the data.My first suggestion and best would be push if statement logic into script so that way it will not consume more resources. Second suggestion is increase the RAM of your machine where you are developing the app. Hope that helps.

Re: Allocated Memory Exceeded

sunny_talwar — Wed, 22 Apr 2015 14:07:44 GMT

Let me see if I can implement Vinay Bangari suggestion. If that doesn't work, I will provide more details.

But thanks for your help on this Manish Kachhia‌

Best,

Sunny

Re: Allocated Memory Exceeded

sunny_talwar — Mon, 27 Apr 2015 01:08:32 GMT

Hey Manish‌, Please find a sample application where I am facing this issue. Right now the issue can only be seen in a text object, but as I fill in more data into the application, the below chart will also start giving problems. I am attaching a excel file so that you can see the effects of reloading.

Please see and let me know if you have a good way to handle this situation.

Best,

Sunny

Re: Allocated Memory Exceeded

Thu, 04 Feb 2016 22:41:45 GMT

I had a similar issue. A combo chart was working for my colleague but when I opened it, It gave me "Allocated Memory Exceeded" error. I figured the problem was my QV version.

The problem got resolved after upgrading to the Latest Version of QV. Apparently, they fixed this problem in SR1 but I had QV11 SR 12 installed and still was getting this error. I had to upgrade to QV 12 to resolve the problem.