Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

raadwiptec
Contributor 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
Contributor II

Re: script

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
imadzidan
New Contributor III

Re: script

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

MK9885
Honored Contributor II

Re: script

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
Valued Contributor

Re: script

Hi,

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

ramasaisaksoft
Valued Contributor III

Re: script

-->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
Contributor II

Re: script

hi all,

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

ramasaisaksoft
Valued Contributor III

Re: script

then check data base tables and where conditions

MK9885
Honored Contributor II

Re: script

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
Contributor II

Re: script

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