allocated memory exceeded

[#1]

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

[#2]

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.

[#3]

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

[#4]

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

[#5]

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

[#6]

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