Out Of Virtual Memory (boot.ini)

[#1]

I use QlikView to import multiple text files with more than 1.5 million lines and the message OUT OF VIRTUAL MEMORY always seems to mind when the 12th file.


I read other topics about the same problem and noticed that to try to solve the problem you must edit the boot.ini file and change the value of the variable QVM to 3Gb.
I tried this file (boot.ini) on my machine and did not find it, can someone pass me an example?

Following is the script load.

inicio=374;
final=380;
for cont=inicio to final step 2
 //Carregar novos registros
 [base]:
 LOAD
 num(@112:119T,'00000000') &
 num(@173:178T,'000000') &
 num(@179:180T,'00') as [Link-Pagamentos],
 num(@112:119T,'00000000') &
 num(@173:178T,'000000') &
 num(@179:180T,'00') as [PP37-ID],
 num(@1:2T) as [PP37-TP],
 @4:4T as [PP37-Estrela],
 num(@105:107T) as [[PP37-Banco],
 num(@108:111T) as [PP37-Setor],
 @112:119T as [PP37-RA-Registro],
 @120:169T as [PP37-RA-Nome],
 num(@170:172T,'000') as [PP37-RA-LOS],
 num(@173:178T,'000000') as [PP37-OrderID],
 num(@179:180T,'00') as [PP37-CP],
 @181:184T as [PP37-CP-Ano],
 @179:180T & '/' & @181:184T as [PP37-CP-FMT],
 num(@181:184T & @179:180T) as [PP37-CP-ORD],
 date(left(@185:192T,2) & '/' &
 mid(@185:192T,3,2) & '/' &
 right(@185:192T,4)) as [PP37-DT-Fat],
 date(left(@193:200T,2) & '/' &
 mid(@193:200T,3,2) & '/' &
 right(@193:200T,4)) as [PP37-DT-Venc],
 date(left(@201:208T,2) & '/' &
 mid(@201:208T,3,2) & '/' &
 right(@201:208T,4)) as [PP37-DT-Val],
 money(num(@209:219T)/100) as [PP37-vlr-Fat],
 money(num(@220:230T)/100) as [PP37-vlr-Deb],
 money(num(@231:241T)/100) as [PP37-vlr-Pagto-Parcial],
 money(num(@242:252T)/100) as [PP37-vlr-Saldo],
 @367:367T as [PP37-MB],
 filebasename() as [PP37-Arquivo-Nome]
 FROM C:\Temp\PP37\PP37A$(cont).TXT (ansi, fix, no labels, header is 0, record is line);
 JOIN LOAD
 [PP37-ID],
 [PP37-TP],
 [PP37-Estrela],
 [PP37-Setor],
 [PP37-RA-Registro],
 [PP37-RA-Nome],
 [PP37-RA-LOS],
 [PP37-OrderID],
 [PP37-CP],
 [PP37-CP-Ano],
 [PP37-CP-FMT],
 [PP37-CP-ORD],
 [PP37-DT-Fat],
 [PP37-DT-Venc],
 [PP37-DT-Val],
 [PP37-vlr-Fat],
 [PP37-vlr-Deb],
 [PP37-vlr-Pagto-Parcial],
 [PP37-vlr-Saldo],
 [PP37-MB],
 [PP37-Arquivo-Nome]
 FROM C:\QVD\pp37.qvd (qvd)
 WHERE NOT exists([PP37-ID]);
 store * from base into c:\qvd\pp37.qvd;
 drop table base;
next

Thanks!
Marco

[GabrielAraya]

Hi Marco. Sometimes the "Out of Virtual Memory" in the reload process is a problem with the data model. In order to discard this situation, I recommend you to run the reload process in debug mode, for 10 rows for example and to check if you have Syntetics Keys in the data model.

Gabriel

[#3]

Thanks Gabriel, but when I import 11 files this problem does not occur.

I changed the code and managed to import 16 of the 18 files without problem, but in 17 the problem occurred again.

You know how to use the boot.ini?
if yes, please explain how to use it.

Marco

[GabrielAraya]

Sure, In boot.ini file, you should have a line similar to:multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Microsoft Windows XP Professional" /noexecute=optin /fastdetect yo need to add at the end of the line: /3GB .

multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Microsoft Windows XP Professional" /noexecute=optin /fastdetect/3GB