Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

script

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

1 Solution

Accepted Solutions
raadwiptec
Creator II
Creator II
Author

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

View solution in original post

8 Replies
Anonymous
Not applicable

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

MK9885
Master II
Master II

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

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
Creator II
Creator II
Author

hi all,

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

ramasaisaksoft

then check data base tables and where conditions

MK9885
Master II
Master II

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
Creator II
Creator II
Author

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