topic allocated memory exceeded in QlikView

allocated memory exceeded

Sun, 29 Jul 2012 01:50:14 GMT

Hi,

I am trying to refresh a qvd which has 14million records. It is fetching data from the DB(SQL SERVER) but while writing to QVD it is throwing an exception as ALLOCATED LOGICAL/PHYSICAL MEMORY EXCEEDED >2MB

Everything else looksfine.

Thanks,

Siri

Re: allocated memory exceeded

Sun, 29 Jul 2012 10:01:17 GMT

When you run the script, please check the memory utilization in the task manager. This error is because the memory is full. Check out running it in a machine with larger memory.

Alternatively look if you have options to remove any group by statement in the load part or by supressing the preceding load script part.

Kiran.

Re: allocated memory exceeded

Sun, 29 Jul 2012 15:41:30 GMT

Hi Kiran,

I dont have any group by...i am just getting complete data from database for only one table and storing it to a QVD, My system has 8GB of RAM.

Thanks

Re: allocated memory exceeded

Sun, 29 Jul 2012 15:41:40 GMT

Hi Kiran,

I dont have any group by...i am just getting complete data from database for only one table and storing it to a QVD, My system has 8GB of RAM.

Thanks

Re: allocated memory exceeded

Sun, 29 Jul 2012 15:41:53 GMT

Hi Kiran,

I dont have any group by...i am just getting complete data from database for only one table and storing it to a QVD, My system has 8GB of RAM.

Thanks

Re: allocated memory exceeded

Mon, 30 Jul 2012 07:40:57 GMT

If you have table with huge data, load only wanted fields.