script

[raadwiptec]

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...

any suggestions

[Anonymous]

Strange!! Is this run on the server or on your local machine? It will be good to show the script.

[MK9885]

Try Debug method to check. You'll see that button next to reload in load script.

Give the line number (using Limit Load) where you've problem and check for any errors

[sdmech81]

Hi,

Open script editor..And debug n then set points then execute and see the error msg over their..

[ramasaisaksoft]

-->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.

[raadwiptec]

hi all,

if i debug with limited lines it is running good..

[ramasaisaksoft]

then check data base tables and where conditions

[MK9885]

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.

[raadwiptec · Accepted solution]

thanks it is resolved... their was no issue basically .. it was indeed time consuming compared to yesterday....eventually it started running after 4-5 minutes..