topic Sense QVD Store hangs in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Sense-QVD-Store-hangs/m-p/800827#M1012 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Im using a Extract application in Qlik Sense for OLE DB read and looping through tables and store into QVD.</P><P>Every table is dropped after each load &amp; store, So Qlik Sense does not have to join any tables or such, just load, store, drop.</P><P></P><P>It works like a charm for smaller tables, b<SPAN style="font-size: 10pt; line-height: 1.5em;">ut all my larger tables (5million-20million rows plus) seems to fail to store/crash the services.</SPAN></P><P>The read finishes, then Qlik Sense just maxes out RAM and CPU, and nothing happens and the QVD doesnt get saved.</P><P>It did not even save after hours of waiting, and I had to restart all services to get back into application.</P><P><IMG __jive_id="82047" alt="Screen Shot 2015-03-26 at 17.06.37.png" class="image-1 jive-image" src="/legacyfs/online/82047_Screen Shot 2015-03-26 at 17.06.37.png" style="height: auto;" /></P><P>Any ideas? Thanks</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">*Im running latest Qlik Sense server on Windows 2012 server.</SPAN></P></BODY></HTML> Thu, 26 Mar 2015 16:14:11 GMT tomas_arn 2015-03-26T16:14:11Z Sense QVD Store hangs https://community.qlik.com/t5/Connectivity-Data-Prep/Sense-QVD-Store-hangs/m-p/800827#M1012 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Im using a Extract application in Qlik Sense for OLE DB read and looping through tables and store into QVD.</P><P>Every table is dropped after each load &amp; store, So Qlik Sense does not have to join any tables or such, just load, store, drop.</P><P></P><P>It works like a charm for smaller tables, b<SPAN style="font-size: 10pt; line-height: 1.5em;">ut all my larger tables (5million-20million rows plus) seems to fail to store/crash the services.</SPAN></P><P>The read finishes, then Qlik Sense just maxes out RAM and CPU, and nothing happens and the QVD doesnt get saved.</P><P>It did not even save after hours of waiting, and I had to restart all services to get back into application.</P><P><IMG __jive_id="82047" alt="Screen Shot 2015-03-26 at 17.06.37.png" class="image-1 jive-image" src="/legacyfs/online/82047_Screen Shot 2015-03-26 at 17.06.37.png" style="height: auto;" /></P><P>Any ideas? Thanks</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">*Im running latest Qlik Sense server on Windows 2012 server.</SPAN></P></BODY></HTML> Thu, 26 Mar 2015 16:14:11 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Sense-QVD-Store-hangs/m-p/800827#M1012 tomas_arn 2015-03-26T16:14:11Z