Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Rema_04
Contributor
Contributor

QV Task running longer suddenly

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.

Labels (2)
2 Solutions

Accepted Solutions
Maria_Halley
Support
Support

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

 

View solution in original post

Rema_04
Contributor
Contributor
Author

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

View solution in original post

5 Replies
Maria_Halley
Support
Support

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

 

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
KHSDM
Creator II
Creator II

Any upgrade recently? It might be the cause.

Rema_04
Contributor
Contributor
Author

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

JohnInSD
Contributor III
Contributor III

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.