iam running a qlikview script.. it has more than 7000 lines of code.. it used to run good until yesterday.. since today until certain table it run then it shows as 4566 lines fethed and gets hanged over their.. not able to understand the problem.. no chages were done on the script. the logs also does not show any errors in the folder...
-->Mainly Hanging means either it may occur Circular Loop /Stored procedure is taking too much of time to execute because of Database connection issue.
-->If you are not getting all records 7000 means may be your database tables got less records/else some where condition issue
but you said same code is worked till yesterday so try like below.
better to create a Test.qvw and copy paste your code in Desktop Edition at your desk
so Test.Qvw will have ur code and just do Debug for 100 records first.
later you can can try same debug for all the records.
Maybe do Binary Load Instead?
Create a separate QVW only for script with no visualizations and use this qvw to do binary load and create your charts.
Which will be your source file.
This is the best method to do as it will be 3 tier.