topic ''OUT OF VIRTUAL AND/OR LOGICAL MEMORY ALLOCATING 2 MB' ERROR WHILE RELOADING SCRIPT in QlikView https://community.qlik.com/t5/QlikView/OUT-OF-VIRTUAL-AND-OR-LOGICAL-MEMORY-ALLOCATING-2-MB-ERROR-WHILE/m-p/642423#M235355 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am getting following error message while rying to reload the script.</P><P>'OUT OF VIRTUAL AND/OR LOGICAL MEMORY ALLOCATING 2 MB'.</P><P>If you click on OK button, system futher throws below message</P><P>'SERVER DEPLOYMENT COMPATIBILITY WARNING' - Internal inconsistency Type D detected, if this application is deployed on server, the server will restart with the message above written to the event log.</P><P>Please contact Qliktech support for further assistance.</P><P></P><P>We already have tried increasing the Virtual memory size but it didn't worked.</P><P></P><P>Please advice.</P></BODY></HTML> Thu, 22 May 2014 05:05:24 GMT 2014-05-22T05:05:24Z ''OUT OF VIRTUAL AND/OR LOGICAL MEMORY ALLOCATING 2 MB' ERROR WHILE RELOADING SCRIPT https://community.qlik.com/t5/QlikView/OUT-OF-VIRTUAL-AND-OR-LOGICAL-MEMORY-ALLOCATING-2-MB-ERROR-WHILE/m-p/642423#M235355 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am getting following error message while rying to reload the script.</P><P>'OUT OF VIRTUAL AND/OR LOGICAL MEMORY ALLOCATING 2 MB'.</P><P>If you click on OK button, system futher throws below message</P><P>'SERVER DEPLOYMENT COMPATIBILITY WARNING' - Internal inconsistency Type D detected, if this application is deployed on server, the server will restart with the message above written to the event log.</P><P>Please contact Qliktech support for further assistance.</P><P></P><P>We already have tried increasing the Virtual memory size but it didn't worked.</P><P></P><P>Please advice.</P></BODY></HTML> Thu, 22 May 2014 05:05:24 GMT https://community.qlik.com/t5/QlikView/OUT-OF-VIRTUAL-AND-OR-LOGICAL-MEMORY-ALLOCATING-2-MB-ERROR-WHILE/m-p/642423#M235355 2014-05-22T05:05:24Z Re: ''OUT OF VIRTUAL AND/OR LOGICAL MEMORY ALLOCATING 2 MB' ERROR WHILE RELOADING SCRIPT https://community.qlik.com/t5/QlikView/OUT-OF-VIRTUAL-AND-OR-LOGICAL-MEMORY-ALLOCATING-2-MB-ERROR-WHILE/m-p/642424#M235356 <HTML><HEAD></HEAD><BODY><P>There are too many synthetic keys in your data model. You have to correct(remove these synthetic keys AFAP) your data model to get rid of it.</P></BODY></HTML> Thu, 22 May 2014 05:09:52 GMT https://community.qlik.com/t5/QlikView/OUT-OF-VIRTUAL-AND-OR-LOGICAL-MEMORY-ALLOCATING-2-MB-ERROR-WHILE/m-p/642424#M235356 tresB 2014-05-22T05:09:52Z Re: ''OUT OF VIRTUAL AND/OR LOGICAL MEMORY ALLOCATING 2 MB' ERROR WHILE RELOADING SCRIPT https://community.qlik.com/t5/QlikView/OUT-OF-VIRTUAL-AND-OR-LOGICAL-MEMORY-ALLOCATING-2-MB-ERROR-WHILE/m-p/642425#M235357 <HTML><HEAD></HEAD><BODY><P>Hi Anil,</P><P></P><P>Please improve your data model. With so many syn keys the output you'll get won't be proper.</P></BODY></HTML> Thu, 22 May 2014 05:25:14 GMT https://community.qlik.com/t5/QlikView/OUT-OF-VIRTUAL-AND-OR-LOGICAL-MEMORY-ALLOCATING-2-MB-ERROR-WHILE/m-p/642425#M235357 2014-05-22T05:25:14Z Re: ''OUT OF VIRTUAL AND/OR LOGICAL MEMORY ALLOCATING 2 MB' ERROR WHILE RELOADING SCRIPT https://community.qlik.com/t5/QlikView/OUT-OF-VIRTUAL-AND-OR-LOGICAL-MEMORY-ALLOCATING-2-MB-ERROR-WHILE/m-p/642426#M235358 <HTML><HEAD></HEAD><BODY><P>Hi Anil,</P><P>The error occurs due to QlikView running out of available memory. On 32-bit platforms the user memory address space is typically limited to 2 GB per process even though more physical memory may be available. </P><P>The root cause is most probably the data model. Try to eliminate or reduce the number of synthetic keys.</P><P>Cheers</P><P>Carlos</P></BODY></HTML> Thu, 22 May 2014 06:04:54 GMT https://community.qlik.com/t5/QlikView/OUT-OF-VIRTUAL-AND-OR-LOGICAL-MEMORY-ALLOCATING-2-MB-ERROR-WHILE/m-p/642426#M235358 cfz 2014-05-22T06:04:54Z Re: ''OUT OF VIRTUAL AND/OR LOGICAL MEMORY ALLOCATING 2 MB' ERROR WHILE RELOADING SCRIPT https://community.qlik.com/t5/QlikView/OUT-OF-VIRTUAL-AND-OR-LOGICAL-MEMORY-ALLOCATING-2-MB-ERROR-WHILE/m-p/642427#M235359 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>QV's ability to calculate and fetch rows hinders as the number of synthetic keys increase. And if u use any joins with the same of synthetic keys,it runs out of memory.</P><P>Reform ur data model and try.</P><P>HTH</P><P>Regards,</P><P>Ravi N.</P></BODY></HTML> Thu, 22 May 2014 06:07:01 GMT https://community.qlik.com/t5/QlikView/OUT-OF-VIRTUAL-AND-OR-LOGICAL-MEMORY-ALLOCATING-2-MB-ERROR-WHILE/m-p/642427#M235359 Anonymous 2014-05-22T06:07:01Z