topic Re: Out OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2 MB in QlikView

Out OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2 MB

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

we have upload excel in 103507 record.we click reload button, we get 'Out of Virtual And /Or Logical Memory allocation 2 MB' this error.kindly advice me, how can we resolve this issue.

Re: Out OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2 MB

Wed, 08 Jan 2014 07:27:58 GMT

is the table joining with any other table?

try to use Qualify *; before the table and check if it can be reloaded without any relations with other table's

Happy new Year and best regards

Juan Pedro

Re: Out OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2 MB

Wed, 08 Jan 2014 12:21:29 GMT

It usually happens when you want to join up 2 tables that do not have a link between them.

eg. If you have tables like.

Client:

Load

ClientNo,

Name,

Surname

from Client.qvd(qvd);

// Load from the product table.and left join to client.

left join (Client)

load

ProductID,

SKU,

Weight

from Prod.qvd(qvd);

The 2 tables do not have a field with the same name in it in both. This causes a Cartesian join

Depending on the size of the tables it will cause the error that you just described.