Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

sathish_expo
Contributor

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

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.

2 Replies
Not applicable

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

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

Not applicable

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

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.

Community Browser