topic Re: Out of memory in QlikView https://community.qlik.com/t5/QlikView/Out-of-memory/m-p/375479#M139888 <HTML><HEAD></HEAD><BODY><P>When you create a Qlik View data model you don' t have a Syn key and you don't have calcutated dimension in your chart.</P></BODY></HTML> Mon, 02 Jul 2012 09:08:47 GMT 2012-07-02T09:08:47Z Out of memory https://community.qlik.com/t5/QlikView/Out-of-memory/m-p/375477#M139886 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">I'm</SPAN> <SPAN class="hps">new</SPAN> <SPAN class="hps">developer</SPAN> <SPAN class="hps">qlikview.Attualmente</SPAN>'m <SPAN class="hps">doing</SPAN> <SPAN class="hps">tests</SPAN> <SPAN class="hps">with the</SPAN> <SPAN class="hps">personal</SPAN> <SPAN class="hps">version</SPAN>, the <SPAN class="hps">expectation that</SPAN> <SPAN class="hps">buy</SPAN> <SPAN class="hps">licenses</SPAN>. <SPAN class="hps">I have a</SPAN> <SPAN class="hps">MySQL</SPAN> <SPAN class="hps">database</SPAN> <SPAN class="hps">that I connected</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">Civ</SPAN>. <SPAN class="hps">The data</SPAN> <SPAN class="hps">are</SPAN> <SPAN class="hps">loaded</SPAN> <SPAN class="hps">pochiessimi</SPAN> <SPAN class="hps">but uploading</SPAN> <SPAN class="hps">me</SPAN> <SPAN class="hps">the following error</SPAN><BR /> <SPAN class="hps">OUT</SPAN> <SPAN class="hps">OF</SPAN> <SPAN class="hps">VIRTUAL</SPAN> <SPAN class="hps">AND</SPAN> <SPAN class="hps">/</SPAN> <SPAN class="hps">OR</SPAN> <SPAN class="hps">LOGICAL</SPAN> <SPAN class="hps">MEMORY</SPAN> <SPAN class="hps">Allocating</SPAN> <SPAN class="hps">2MB</SPAN>.<BR /> <SPAN class="hps">Allogego</SPAN> <SPAN class="hps">script</SPAN> <SPAN class="hps">I also do</SPAN> <SPAN class="hps">that</SPAN> <SPAN class="hps">my pc</SPAN> <SPAN class="hps">has 4</SPAN> <SPAN class="hps">g</SPAN> <SPAN class="hps">of ram</SPAN>. <SPAN class="hps">I do not know</SPAN> <SPAN class="hps">if I have to</SPAN> <SPAN class="hps">configure something</SPAN> <SPAN class="hps">I</SPAN> <SPAN class="hps">tried</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">expand</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">allocazioen</SPAN> <SPAN class="hps">dynamic</SPAN> <SPAN class="hps">memory</SPAN> <SPAN class="hps">but the problem</SPAN> <SPAN class="hps">persists</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P></BODY></HTML> Mon, 02 Jul 2012 08:02:25 GMT https://community.qlik.com/t5/QlikView/Out-of-memory/m-p/375477#M139886 2012-07-02T08:02:25Z Re: Out of memory https://community.qlik.com/t5/QlikView/Out-of-memory/m-p/375478#M139887 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The problem here seems to be that you're getting a lot of Synthetic keys:</P><P><EM>$Syn 1 = INDIRIZZO+TELEFONO</EM></P><P><EM>$Syn 2 = NOTE+FK_PROGETTO</EM></P><P><EM>$Syn 3 = NOTE+ABILITATO</EM></P><P><EM>$Syn 4 = COSTO_EFFETTIVO+NOTE</EM></P><P><EM>$Syn 5 = COSTO_EFFETTIVO+NOTE+CODICE+COSTO_STANDARD+RICAVO_ATTESO</EM></P><P><EM>$Syn 6 = COSTO_EFFETTIVO+NOTE+CODICE+COSTO_STANDARD+FK_AREA+FK_AREA_COMMERCIALE+FK_AREA_COMMERCIALE_SECONDO_LIVELLO+NOME+RICAVO_ATTESO</EM></P><P><EM>$Syn 7 = COSTO_EFFETTIVO+MARGINE_ASSOLUTO_EFFETTIVO+MARGINE_PERCENTUALE_EFFETTIVO+NOTE+RICAVO</EM></P><P><EM>$Syn 8 = COSTO_EFFETTIVO+MARGINE_ASSOLUTO_EFFETTIVO+MARGINE_PERCENTUALE_EFFETTIVO+NOTE+RICAVO+CODICE+COSTO_ATTESO+COSTO_STANDARD+DATA_INIZIO+EFFORT+FK_FORNITORE+MARGINE_ASSOLUTO_ATTESO+MARGINE_ASSOLUTO_STANDARD+MARGINE_PERCENTUALE_ATTESO+MARGINE_PERCENTUALE_STANDARD+RICAVO_ATTESO+RIMANENZE_FINALI_EFFETTIVE+RIMANENZE_FINALI_STANDARD</EM></P><P><EM>$Syn 9 = COSTO_EFFETTIVO+MARGINE_ASSOLUTO+MARGINE_ASSOLUTO_EFFETTIVO+MARGINE_PERCENTUALE_EFFETTIVO+NOTE+PERCENTUALE_AVANZAMENTO+RICAVO</EM></P><P><EM>$Syn 10 = COSTO_EFFETTIVO+ID_PROGETTO+MARGINE_ASSOLUTO_EFFETTIVO+MARGINE_PERCENTUALE_EFFETTIVO+NOTE+PORTAFOGLIO+RICAVO</EM></P><P><EM>$Syn 11 = COSTO+COSTO_EFFETTIVO+NOTE</EM></P><P></P><P>These occur when two (or more) tables share two (or more) fields with the same name. Make sure you rename fields so that you don't get accidental linkage on fields that you're not intending to link together.</P></BODY></HTML> Mon, 02 Jul 2012 08:05:28 GMT https://community.qlik.com/t5/QlikView/Out-of-memory/m-p/375478#M139887 Anonymous 2012-07-02T08:05:28Z Re: Out of memory https://community.qlik.com/t5/QlikView/Out-of-memory/m-p/375479#M139888 <HTML><HEAD></HEAD><BODY><P>When you create a Qlik View data model you don' t have a Syn key and you don't have calcutated dimension in your chart.</P></BODY></HTML> Mon, 02 Jul 2012 09:08:47 GMT https://community.qlik.com/t5/QlikView/Out-of-memory/m-p/375479#M139888 2012-07-02T09:08:47Z