Discussion Board for collaboration related to QlikView Deployment.
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.
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
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.
// Load from the product table.and left join to client.
left join (Client)
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.