Error: Out of virtual and/or logial memory

[#1]

I have error: Out of virtual and/or logial memory 2 MB when downloaded data. RAM: 32 gB, processor: 4. QlikView are used 5 gB of RAM.

Number of rows are approximately 50 million.

I rewrited script in several view and it didn't help. I don't understand where is problem. Thank's for any help.

Following script:

AmountTb:

LOAD amount,
typeid as amounttype,
recordid,
CurrencyId,
Inserted as aminsert,
month (Inserted) as Month,
Year (Inserted) as Year,
Day (Inserted) as Day
FROM
D:\Tables\AmountTb.qvd (qvd)
Where amount>10 and typeid = 266;

RecordTb:
LOAD contractid,
id
FROM
D:\Tables\RecordTb.qvd (qvd);

inner join (AmountTb)

load id as recordid,
contractid
Resident RecordTb;

DROP Table RecordTb;

[qlikviewajeet]

Hi

Here inner join will not work.

QV support innerjoin by default,

here you can use left join if needed. as i don't think u need any join.

bcz conractid is only one field on that base both two tables get joined and buil data model.

[#3]

Hi,

thanks a lot for your answer.

I rewrited script:

AmountTb:
LOAD amount,
     typeid as amounttype,
     recordid,
     CurrencyId,
     Inserted as aminsert,
     month (Inserted) as Month,
     Year (Inserted) as Year,
     Day (Inserted) as Day
FROM
D:\Tables\AmountTb.qvd (qvd);

RecordTb:
LOAD contractid,
     id as recordid

FROM
D:\Tables\RecordTb.qvd (qvd);

But it doesn't work on whole data base. When I checked on limitation data it was working. But when I want to upload all data QlikView returned error: Out of virtual and/or logial memory 2 MB.

[qlikviewajeet]

Hi

Plz go through the test application i attached. here is ur solution..

bcz this error comes only when

* Bad DataModeling

Join the data table carefully.

Thanks

Ajeet