topic Re: script in QlikView

script

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: script

Anonymous — Mon, 30 Jan 2017 14:21:16 GMT

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

Re: script

MK9885 — Mon, 30 Jan 2017 14:24:56 GMT

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

Re: script

sdmech81 — Mon, 30 Jan 2017 14:32:36 GMT

Hi,

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

Re: script

ramasaisaksoft — Mon, 30 Jan 2017 14:37:13 GMT

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

Re: script

raadwiptec — Mon, 30 Jan 2017 14:37:50 GMT

hi all,

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

Re: script

ramasaisaksoft — Mon, 30 Jan 2017 14:40:27 GMT

then check data base tables and where conditions

Re: script

MK9885 — Mon, 30 Jan 2017 14:41:39 GMT

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.

Re: script

raadwiptec — Mon, 30 Jan 2017 15:01:56 GMT

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