topic Re: Getting OUT OF OBJECT MEMORY in QlikView

Getting OUT OF OBJECT MEMORY

sandeepprasad_j — Thu, 18 Apr 2013 13:58:14 GMT

HI Experts,

Can i please know why i am getting the error OUT OF OBJECT MEMORY when i want to see the data . The data iis in the container object .

Thanks,

Sandeep.

Re: Getting OUT OF OBJECT MEMORY

Thu, 18 Apr 2013 14:56:57 GMT

Hi ,

When the Data is Huge more than the Capability of RAM , then the Operating Sytem try to use

Hard Disk memory as Vertual Memory and then if this also fails to accomplain the Data

then the "Out of Memory" is pop up.

You can aviod while loading try to Load like 1 miilion records using

First 1000000

Load *

from

['.....] ;

Please reply me for the same .

Regards

//Yusuf

Re: Getting OUT OF OBJECT MEMORY

sandeepprasad_j — Fri, 19 Apr 2013 04:36:31 GMT

Hi Yusuf ,

There are taking the data from the data base . So, my question is Do we have to change the script in every tab in the script editor or ???

Thanks,

Sandeep

Re: Getting OUT OF OBJECT MEMORY

Fri, 19 Apr 2013 05:32:28 GMT

HI ,

If this problem is on your Local Machine (Desktop ),

then For testing your Application you can use Load only few thousands of records .

like in the Script before only few tables which loads millions of rows (huge Data Tables).

Table:

First 10000;

Load * ;

Sql Select * from DB.TableName ;

Once your application is working fine . then at the time of Deployment you can comment that "first 10000" ;

But if this Probem you are getting On QlikView sever(After Deployment of QlikView Server) then you have increase the scaling of RAM and also the Processor .

Please reply me for the same.

//Yusuf

Re: Getting OUT OF OBJECT MEMORY

sandeepprasad_j — Fri, 19 Apr 2013 06:24:12 GMT

HI Yusuf,

Thanks for the immediate reply....infact i am facing this problem after the server deployment...can you please guide me on how to increase the scaling RAM and CPU for a specific object or sheet if its possible. Your help in this regard is much appreciated.

Thanks,

Sandeep

Re: Getting OUT OF OBJECT MEMORY

jagan — Fri, 19 Apr 2013 06:27:43 GMT

Hi Sandeep,

When you are getting this error, while viewing the chart or while loading the data? I think it occurs while viewing the charts, if you are displaying huge data in Pivot / Straight table or Aggr() or Distinct this may occur.

Regards,

Jagan.

Re: Getting OUT OF OBJECT MEMORY

sandeepprasad_j — Fri, 19 Apr 2013 08:54:54 GMT

Hi Jagan,

Thanks for the review....can you guide me on how to resolve this issue i am facing by scaling the RAM/CPU of the server or is there another way around this.

Thanks,

Sandeep.

Re: Getting OUT OF OBJECT MEMORY

Fri, 19 Apr 2013 09:47:11 GMT

tHI ,

what i suggest is not to load data from DataBase for the All years .

Try to have a StartDate = 2012-01-01 , and try to load only last year data instead of loading the Entire Data

from the DataBase .

It is always good have a startDate for loading data of last 6 months or 12 months .

instead of loading data of last 5 years and so on.

Please reply me for the same.

//Yusuf

Re: Getting OUT OF OBJECT MEMORY

sandeepprasad_j — Fri, 19 Apr 2013 10:18:08 GMT

Hi Yusuf ,

Thanks for giving the reply ... but its not solving my issue.can you guide me on how to resolve this issue i am facing by scaling the RAM/CPU of the server or is there another way around this.

Thanks,

Sandeep.

Re: Getting OUT OF OBJECT MEMORY

jagan — Fri, 19 Apr 2013 10:40:26 GMT

Hi,

When you are getting this error, what is your database size and number of records in the table, and what is your machine configuration, like RAM etc.

Regards,

Jagan.