Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Error: Out of virtual and/or logial memory

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;

3 Replies
qlikviewajeet
New Contributor III

Error: Out of virtual and/or logial memory

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.

Not applicable

Re: Error: Out of virtual and/or logial memory

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
New Contributor III

Re: Error: Out of virtual and/or logial memory

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

Community Browser