topic Out of Object Memory Issue in QlikView

Out of Object Memory Issue

Tue, 24 Nov 2009 23:40:17 GMT

Hi Guys,

Do you ever have to deal with the Out of Object Memory Issue in Qlikview ?

I create a qvw file with 4 years of data - total records around 400 millions.

The offended sheet - was made of pivot chart with 4 cyclics with regular sum as the calculation, whenever i try to pull the 3 years of data - it always give me the "Out of Object Memory" Error and none got displays

40 G memory and 64 bit Windows Server 2008 and Quad Core Xeon 2.33 Mhz.

Qlikview 8.5.

Any help will be appreciated.

Out of Object Memory Issue

Tue, 24 Nov 2009 23:44:11 GMT

Sometimes it is not a memory issue, but en expression issue ( error in the expression for example).

Did you try by selecting some values in your application to limit the chart size ?

If the problem still present it could be an error in your expression...

Rgds,

Sébastien

Out of Object Memory Issue

Tue, 24 Nov 2009 23:50:11 GMT

If I change the value inside the Cyclic - then it did return the value.

But the user want specific values to display that;'s why I encountered that problem.

Even the vendor try to tell me to cut down on some of the available dimension in Cyclic to make it usable - but the user is the one bought the software - so I could not say what they could not do or could do

Regards,

Senjaya

Out of Object Memory Issue

Tue, 24 Nov 2009 23:54:47 GMT

That means that the problem is related to one particular dimension...

Maybe the blocking dimension is not correctly linked to the remaining of the tables ?

Is it possible to check that ?

It is hard to give you more details in thie issue.

Out of Object Memory Issue

Wed, 25 Nov 2009 00:00:22 GMT

All the cylics have the same dimensions - if I just do 1 year as my selection option - all of them return but if I start with 3 years of data then it will give out that error.

Out of Object Memory Issue

Wed, 25 Nov 2009 00:12:15 GMT

You can try to change the max memory allocated on chart in Server Qlikview control panel, then check if that solve the problem.

If you have plenty of memory used by a particular chart, default limit can be too low in the Server control panel.

Out of Object Memory Issue

Wed, 25 Nov 2009 00:28:50 GMT

Under Server Management Console :

I had changed the Calculated Formulas Max Memory to the 4096 Kb and we have only 40G in the computer

and also sort by expression max memory to 4096 kb

Object Calculation Time Limit to 300

Max Symbols in Chart to 100

Working Set limit % Low limit 70 and High limit 90 and cache 10%

Still this does not help - when I see the task manager - it reached the 37G before it down again and then send those error message to the screen.

I have exhaust all and even call the Qlikview Support in Sweden - they have not gotten back to me yet.

Out of Object Memory Issue

Thu, 26 Nov 2009 17:01:58 GMT

I had the same problem in the past days:

Sometimes the message: "Out of object memory", sometimes "Allocated memory exceeded".

Today we solved the problem: Till now worked with a 32bit developer on a 64bit server system. We installed the 64bit developer today and everything is fine.

Out of Object Memory Issue

Thu, 26 Nov 2009 18:02:30 GMT

In QV 8.5 i saw that in some cases the threshold limt percent of memory setting is not working properly.

Also this setting is only working for 64 bits system but I guess this is what you use as you have a lot of RAM...

Out of Object Memory Issue

Tue, 01 Dec 2009 23:54:47 GMT

We already used the 64 bit application as well.

This is the answer the support in Sweden gave me :

"You can try to get rid of the problem by reducing the number of dimensions. You can also look at the expressions and see if you can change them."

The problem is the client was paying us to get all those dimension in place - if I told them Qlikview can not handle them - why they even bother to purchase qlikview ?

The expression was simple only regular : if Age=18 ,sum(cost18) , cost(25)

Nothing fancy

Out of Object Memory Issue

Tue, 01 Dec 2009 23:59:37 GMT

if Age=18 ,sum(cost18) , sum(cost25) - --- I just mistyped before

Out of Object Memory Issue

Thu, 11 Feb 2010 13:43:22 GMT

Hi,

had the same problem. In your case, may be the solution is to change your formula as follows:

1 expression:

sum ({$<Age={'18'}>}, cost18)

2 expression:

sum ({$<Age={'18'}>}, cost25)

Hope this helps...

Out of Object Memory Issue

Thu, 11 Feb 2010 15:25:26 GMT

Yes - that is the only solution.

Thanks