topic Re: QV Task running longer suddenly in QlikView

QV Task running longer suddenly

Rema_04 — Wed, 01 Jun 2022 03:40:07 GMT

Hi All,

One of the QV Task in QMC which used to run for an average duration of 5 mins is running longer for 5.5 hrs.There has been no change in script and I have compared with log file of 5 min run and 5 hr run.Also the data volume is same.

The task ran fine on 28th May, but broke suddenly from 29th May.

I have tried disabling the task, service restart and server restart as well.But none helped .

Could you please help me out with this issue.

Re: QV Task running longer suddenly

Maria_Halley — Wed, 01 Jun 2022 06:27:06 GMT

@Rema_04

Did you compare the task logs or the document log? The document log (if you have set it to generate one) you can follow the process with time stamps, so you can see where the task reload spends the most time.
If you have one from when it reloaded faster you should compare the two.

you can find instruction on how to enable the document log here.

Re: QV Task running longer suddenly

vinieme12 — Fri, 03 Jun 2022 06:55:49 GMT

Reload the manually and monitor if it still takes 5mins or observer stages that you see are taking longer

There could be changes in script / transformations that are taking longer

Re: QV Task running longer suddenly

KHSDM — Fri, 03 Jun 2022 08:19:08 GMT

Any upgrade recently? It might be the cause.

Re: QV Task running longer suddenly

Rema_04 — Fri, 03 Jun 2022 08:37:23 GMT

Hi All,

There was changes in indexes of the tables and hence the task was running long.Now the issue has been taken care from DB end and issue resolved.

Thanx all

Re: QV Task running longer suddenly

Anonymous — Fri, 03 Jun 2022 16:12:37 GMT

Hi Rema_04, since you answered your own question, go ahead and mark your answer as correct so folks don't spend time looking at questions that have been answered.