Out Of Virtual Memory (boot.ini)

Thu, 08 Oct 2009 20:42:40 GMT

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

Out Of Virtual Memory (boot.ini)

GabrielAraya — Thu, 08 Oct 2009 21:46:05 GMT

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

Out Of Virtual Memory (boot.ini)

Thu, 08 Oct 2009 23:40:40 GMT

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

Out Of Virtual Memory (boot.ini)

GabrielAraya — Fri, 09 Oct 2009 01:00:38 GMT

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

topic Out Of Virtual Memory (boot.ini) in QlikView

Out Of Virtual Memory (boot.ini)

Out Of Virtual Memory (boot.ini)

Out Of Virtual Memory (boot.ini)

Out Of Virtual Memory (boot.ini)