topic Re: Loading files from a shared folder causes load script to hang in QlikView https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950330#M326888 <HTML><HEAD></HEAD><BODY><P>Are any of the files in question locked or do have any rogue qv.exe processes running.</P><P></P><P>If that is the issue, the simplest way to sort that is to close everything down and restart your PC.</P><P></P><P>Also what happens if you comment out any STORE to qvd statements.</P></BODY></HTML> Mon, 28 Sep 2015 13:51:22 GMT Anonymous 2015-09-28T13:51:22Z Loading files from a shared folder causes load script to hang https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950327#M326885 <HTML><HEAD></HEAD><BODY><P>I have some spreadsheets on the network in a shared folder.&nbsp; QlikView can reach these, loads them, and stores them off into QVDs locally without issue.&nbsp; The problem I am having is when the script reaches the end it just hangs there and never finishes.&nbsp; Half of the script reads ODBC from a SQL database and the other is these spreadsheets.&nbsp; When I comment out the spreadsheets section the script completes without issue. </P><P></P><P>Anyone ever run into anything like this?</P></BODY></HTML> Mon, 28 Sep 2015 13:44:39 GMT https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950327#M326885 jpapador 2015-09-28T13:44:39Z Re: Loading files from a shared folder causes load script to hang https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950328#M326886 <HTML><HEAD></HEAD><BODY><P>I feel its not the issue with the <STRONG>Data load because as per your inputs it executing till the end of the script . so it s loading all the data after the its trying to make association and it is failing here .</STRONG></P><P></P><P>Please check your keys in all the tables once , make sure you dont have a circular key or more than one common keys </P></BODY></HTML> Mon, 28 Sep 2015 13:47:55 GMT https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950328#M326886 avinashelite 2015-09-28T13:47:55Z Re: Loading files from a shared folder causes load script to hang https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950329#M326887 <HTML><HEAD></HEAD><BODY><P><IMG alt="c.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/100227_c.png" style="height: 246px; width: 620px;" /></P></BODY></HTML> Mon, 28 Sep 2015 13:48:44 GMT https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950329#M326887 avinashelite 2015-09-28T13:48:44Z Re: Loading files from a shared folder causes load script to hang https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950330#M326888 <HTML><HEAD></HEAD><BODY><P>Are any of the files in question locked or do have any rogue qv.exe processes running.</P><P></P><P>If that is the issue, the simplest way to sort that is to close everything down and restart your PC.</P><P></P><P>Also what happens if you comment out any STORE to qvd statements.</P></BODY></HTML> Mon, 28 Sep 2015 13:51:22 GMT https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950330#M326888 Anonymous 2015-09-28T13:51:22Z Re: Loading files from a shared folder causes load script to hang https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950331#M326889 <HTML><HEAD></HEAD><BODY><P>Or, as Avinesh alludes, it could be generating a humongous synthetic key.</P></BODY></HTML> Mon, 28 Sep 2015 13:52:38 GMT https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950331#M326889 Anonymous 2015-09-28T13:52:38Z Re: Loading files from a shared folder causes load script to hang https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950332#M326890 <HTML><HEAD></HEAD><BODY><P>are you having this issue when the reload is done through the QMC or when you do a manual reload</P></BODY></HTML> Mon, 28 Sep 2015 13:59:12 GMT https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950332#M326890 2015-09-28T13:59:12Z Re: Loading files from a shared folder causes load script to hang https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950333#M326891 <HTML><HEAD></HEAD><BODY><P>Thank you for your replies.&nbsp; I should mention that I am doing a STORE and DROP.&nbsp; So the end results is that there are no tables.</P><P></P><P>I will comment out the store and see what the result is.</P></BODY></HTML> Mon, 28 Sep 2015 14:10:10 GMT https://community.qlik.com/t5/QlikView/Loading-files-from-a-shared-folder-causes-load-script-to-hang/m-p/950333#M326891 jpapador 2015-09-28T14:10:10Z