Loading files from a shared folder causes load script to hang

[jpapador]

I have some spreadsheets on the network in a shared folder.  QlikView can reach these, loads them, and stores them off into QVDs locally without issue.  The problem I am having is when the script reaches the end it just hangs there and never finishes.  Half of the script reads ODBC from a SQL database and the other is these spreadsheets.  When I comment out the spreadsheets section the script completes without issue.

Anyone ever run into anything like this?

[avinashelite]

I feel its not the issue with the 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 .

Please check your keys in all the tables once , make sure you dont have a circular key or more than one common keys

[avinashelite]

[Anonymous]

Are any of the files in question locked or do have any rogue qv.exe processes running.

If that is the issue, the simplest way to sort that is to close everything down and restart your PC.

Also what happens if you comment out any STORE to qvd statements.

[Anonymous]

Or, as Avinesh alludes, it could be generating a humongous synthetic key.

[#6]

are you having this issue when the reload is done through the QMC or when you do a manual reload

[jpapador]

Thank you for your replies.  I should mention that I am doing a STORE and DROP.  So the end results is that there are no tables.

I will comment out the store and see what the result is.