topic Re: increasing in execution time in QlikView

increasing in execution time

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

Hello everyone

One of my task execution in QMS increase every day, although i didn't change any thing in my dashboard.

i would appreciate if anyone can help

Re: increasing in execution time

swuehl — Wed, 08 Mar 2017 09:43:05 GMT

Have you looked at the task and document log details to determine where exactely the additional time is spent?

Re: increasing in execution time

muthukumar77 — Wed, 08 Mar 2017 09:45:14 GMT

Hi,

Can you send me your log file?

Re: increasing in execution time

swuehl — Wed, 08 Mar 2017 09:46:43 GMT

Also check the amount of data records processed on e.g. first and last date in your list, maybe you are just experiencing quite an increase in data amount.

Re: increasing in execution time

Anonymous — Wed, 08 Mar 2017 10:08:36 GMT

where is the log file locate?

Re: increasing in execution time

muthukumar77 — Wed, 08 Mar 2017 10:14:31 GMT

Hi,

Your QVW file path.

Refer this image to generate log file.

Document Setting

Re: increasing in execution time

swuehl — Wed, 08 Mar 2017 10:16:23 GMT

Video - QlikView Server log files explained

Re: increasing in execution time

Anonymous — Wed, 08 Mar 2017 10:17:37 GMT

bellow instructions repeated for about 7 hours

Re: increasing in execution time

Anonymous — Sun, 12 Mar 2017 09:42:26 GMT

This attachment is a log file but i have question:

what is a different between this log file and log tab in Qlik console? because they are different, in log file it took just 10 min long but in log tab in console took 7 hours long !!!

Re: increasing in execution time

Anonymous — Sun, 12 Mar 2017 09:43:07 GMT

please check my new attachment

Re: increasing in execution time

gayandilhara — Sun, 12 Mar 2017 18:21:38 GMT

Did you try using the query in the QVW and attempt running in a DBMS? If there were no changes to the QVW recently then it could be the volume of the data increasing. Maybe if you run the SQL separately and if that executes in quick time then you can focus on the QVW.

Also it might be worth to check if any other program is taking up the server resources that may be depriving Qlikview dashboards running at full potential.

Re: increasing in execution time

Siva_Sankar — Mon, 13 Mar 2017 05:31:21 GMT

Use ScriptLogAnalyzer tool, to find out where exactly the script load is taking time. Useful tool. Find the attachment. !

Re: increasing in execution time

Anonymous — Mon, 13 Mar 2017 10:13:54 GMT

Hi Sivasankar

Thank you... i used "ScriptLogAnalyzer" . it's cool

But My problem is my log file and log tab in Qlik console are different, in log file it took just 10 min long but in log tab in console took 7 hours long !!!

So i can't check log tab in console with ScriptLogAnalyzer

Re: increasing in execution time

Anonymous — Mon, 13 Mar 2017 10:28:21 GMT

Hi Stefan

where can i check amount or data records processed?

Re: increasing in execution time

swuehl — Mon, 13 Mar 2017 11:55:28 GMT

I think you are looking at two different log files.

The document log is created when running the QVW script, it logs all Information related to the ETL process.

The number of rows processed should be part of that, written each time a table is loaded.

The other log is created by the service that is triggered by Task Scheduler, which is responsible to actually load the document, execute the script, save it and potentially perform distribution etc. tasks.

Looks to me like the reload is quite fast, but an remote distribution task takes Ages to complete, but could be wrong here.

Re: increasing in execution time

Siva_Sankar — Mon, 13 Mar 2017 12:16:43 GMT

Hi Elham,

As stefan and the script log tool confirms that the reload is fast, to me it looks like the issue with distribution service.

Probably memory leak issue, Can you try restarting the distribution service of Qlikview server?

-Siva

Re: increasing in execution time

sasiparupudi1 — Mon, 13 Mar 2017 14:48:51 GMT

Hi '

You have synthetic keys in your data model. Try resolving them as they might be slowing up the load process

3/12/2017 4:28:10 AM:	$Syn 1 = ServiceDetail_ID+ServiceDetail_ServiceDetailTerm
3/12/2017 4:30:38 AM:	$Syn 2 = ADTID+ServiceTypeID

hth

Sas

Re: increasing in execution time

Siva_Sankar — Mon, 13 Mar 2017 15:10:07 GMT

From the log file, synthetic key is not taking the time. It is the distribution process which is taking long time.

Restarting distribution service should fix the issue.

Re: increasing in execution time

Anonymous — Wed, 15 Mar 2017 08:45:12 GMT

Hi to all of you kind people

My problem just solved, i just replace a last version of my dashboard with the new one

I don't know exactly which part of my script section had caused the problem. but fortunately finally solved.

Again thank you for your kind and generous support.

Re: increasing in execution time

Siva_Sankar — Wed, 15 Mar 2017 14:09:42 GMT

Great.