topic Getting Virtual memory error. in QlikView

Getting Virtual memory error.

Mon, 28 Mar 2011 11:04:59 GMT

i am getting following error.

OUT OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2 mb

Getting Virtual memory error.

Miguel_Angel_Baeyens — Mon, 28 Mar 2011 11:12:06 GMT

Hello,

Can you elaborate further on how are you getting that error? Try disabling expressions and removing dimensions in a chart to debug where the issue is.

Hope that helps.

Getting Virtual memory error.

ashfaq_haseeb — Mon, 28 Mar 2011 11:54:13 GMT

Even I faced this error long back. This sort of error will arise,

when you run out of memory. or use use improper joining.

Try to resolve the join issue and also try to upgrate your developemenr machine's RAM

Regards

ASHFAQ

Getting Virtual memory error.

Fri, 01 Apr 2011 13:32:35 GMT

i used to get this error when ever i reload the data .

In my straight table i have expression and dimentions. I have only one join that is based on the column name. I dont have any complex join. In expression i am using the is statement to get the sum of a particular column based on the date range. So i don think i have any complex expression.In dimention field also i have the displaying the column based on the selected date range.

Any suggetion. Do i need to have some setting change.

Getting Virtual memory error.

Fri, 01 Apr 2011 13:34:33 GMT

i have just one join based on the column name . I am working on 2GB RAM computer.

Do i need to change any setting??

Thanks for ur concern

Getting Virtual memory error.

Wed, 06 Apr 2011 19:27:59 GMT

How large is the dashboard on disk? compressed or not?

Getting Virtual memory error.

Sun, 17 Apr 2011 19:27:49 GMT

How to see that my dashboard is compressed or not??

Getting Virtual memory error.

Sun, 17 Apr 2011 19:29:54 GMT

Any way i need those expression for displaying in the straight table.

And in expression also i am just using if statement to get the data for the selected date range.

How do i remove my error ??

Getting Virtual memory error.

Miguel_Angel_Baeyens — Sun, 17 Apr 2011 20:16:48 GMT

Hello,

Go to Settings menu, Document Properties, General tab, "Save format" section, "Compression".

Regards.

Getting Virtual memory error.

Miguel_Angel_Baeyens — Sun, 17 Apr 2011 20:18:42 GMT


Vikas Kumar Singh wrote:And in expression also i am just using if statement to get the data for the selected date range
How do i remove my error ??

Probably using a set analysis instead of an If() conditional will work, but without knowing how have you coded the expression is hard to know.

Regards.

Getting Virtual memory error.

Mon, 18 Apr 2011 12:52:05 GMT

Hi Thanks for your reply.Following is the if statement i am using in expression. That i have used in my straight table.

=(IF( ((DATE(CRDT,'MM/DD/YYYY')>=DATE#(Start_Date,'MM/DD/YYYY')) and( DATE(CRDT,'MM/DD/YYYY')<=DATE#(End_Date,'MM/DD/YYYY'))),

SUM(APPT_CNT)))

In dimention also i am using the same if statement to display the crdt(created date) for the seleted date range.

Like this I have 8 espression .

Please help me out.

I am displaying the sum of appt_cnt for a particular date range . Start_Date and End_Date is coming from the calender control.

In dimention also i am using the same if statement to display the crdt(created date) for the seleted date range.

Like this I have 8 espression .

Please help me out.

Getting Virtual memory error.

Mon, 18 Apr 2011 12:53:35 GMT

Save format Compression is High in my case.

Getting Virtual memory error.

Mon, 18 Apr 2011 13:10:43 GMT

You can increase the size of Virtual Memory. Virtual memory should be (Generally) 1.5 times the size of RAM. Basically it is the part of the Secondary disk which the computer uses when it runs out of Phisycal RAM.

To increase Windows Virtual Memory

1. Right-Click My Computer

2. Go to Properties

3. Go to Advance Tab

4. Go to Performance > Settings

5. Go to Advance Tab

6. Go to Virtual Memory > Change

7. Select drive you want to use for Virtual Memory

8. Select Custom size

8.1. Generally Initial Size should be 2 G and Maximum size should be 1.5 Times your RAM.

9. Set > OK > Apply > OK (Save Everything)

10. You need to restart the computer

Check if your problem is solved. If no try to increase the Virtual Memory a little more.

I Hope this works out.

All the Best

Rajeev Sontakey ( rajeevmeets@gmail.com )

Getting Virtual memory error.

Mon, 18 Apr 2011 13:20:15 GMT

Sorry for my point no#8.1

8.1 Please note that the initial size should be Half of RAM and Maximum should be 1.5 times of RAM.

Getting Virtual memory error.

suniljain — Mon, 18 Apr 2011 13:59:12 GMT

what is the data volume ?.

Getting Virtual memory error.

Miguel_Angel_Baeyens — Mon, 18 Apr 2011 18:37:02 GMT

Hi,

The first I'd do is to do the CRDT Date transformation in the script

TableLabel: LOAD ..., Date(CRDT,'MM/DD/YYYY') AS CRDT, ...

And similar with your variables (not in the script, but in the place where their values are changed, a slider calendar object, likely. The easier the format is the faster the expression will perform.

Besides, regardless of some other hardware/computer issues, your expression above (as any using a conditional) may cause a poor performance in the chart rendering. It may be not the cause of your problem but I'd give a shot to the following expression using set analysis instead:

SUM({< CRDT = {"=DATE(CRDT,'MM/DD/YYYY') >= DATE(DATE#(Start_Date, 'MM/DD/YYYY')))", "=DATE(CRDT, 'MM/DD/YYYY') <= DATE(DATE#(End_Date, 'MM/DD/YYYY')))"} >} APPT_CNT)

Hope this helps.

Getting Virtual memory error.

Anonymous — Thu, 26 May 2011 16:05:39 GMT

I am also getting this error when loading and joining 6 tables from an access database. But in my case it is not QlikView's fault.

My dataload works fine when I use an ODBC connection previously set up in ODBC Manager like this

ODBC CONNECT TO [MyDataSourceName;DBQ=my.accdb;];

But when I use OLEDB connection like this

CONNECT TO [Provider=Microsoft.ACE.OLEDB.12.0;Data Source=my.accdb;];

I get the out of memory error.

As far as QliKView is concerned both approaches are loading the same amount of data and performing the same joins etc. One driver works , the other (older!!) driver doesn't.

There may be more to this error message than meets the eye

Getting Virtual memory error.

Mon, 30 May 2011 08:28:51 GMT

size of data.. number of rows