Qlik Community

Qlik Monitoring & Administration

Announcements
Members are not receiving notifications from the community. A bug has been identified and a fix is coming soon.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

How to identify redundant reload tasks

I am seeing multiple reload tasks for the same associated resource in the QMC scheduled for the same time.  If multiple apps use the same associated resource, is it safe to simply remove the extra reload tasks?  We are experiencing system load issues early in the morning and I suspect it is because the users have simply created redundant reload tasks.  Just trying to find a way to identify redundant (unnecessary) reload tasks.  Thanks.

1 Solution

Accepted Solutions
Highlighted
Contributor II
Contributor II

Thanks very much.  Wonderful level of detail and a tool to allow me to research further.  I have never used CLI, but will get right on that learning curve.  thanks again.  kls

View solution in original post

3 Replies
Highlighted
Employee
Employee

A few thoughts:

  • Redundant tasks will not cause the app to reload at the same time. If two tasks try to reload the same app, the task which executes after the first begins (but has not completed) will receive an error like so:

already_reloading.png

  • Now redundant reload tasks are absolutely confusing from an administrative standpoint.

As for determining which apps have greater than 1 reload task here's a quick and dirty script using Qlik-CLI:

Connect-Qlik
$tasks = Get-QlikReloadTask -full
$tasks.app.id | Group-Object | Sort-Object Count -Descending | Select-Object Name, Count | Group-Object {$_.Count -gt '1'}
<# Example outout:
Count Name                      Group                                                                                                                                                                                                                            
----- ----                      -----                                                                                                                                                                                                                            
    2 True                      {@{Name=de351196-3621-4e75-8a95-00d18ed5d4ea; Count=4}, @{Name=53c667f8-b6b9-431e-991e-fd9f9bf5d38f; Count=2}}                                                                                                                   
   78 False                     {@{Name=4561bb3a-5490-4dd6-b545-be6e1a647af5; Count=1}, @{Name=0f3eba7f-39f9-493c-87b4-518575a41376; Count=1}, @{Name=48117492-7d12-43f3-b3f6-3a21631a736f; Count=1}
#>

 

In this example, app de351196-3621-4e75-8a95-00d18ed5d4ea has 4 reload tasks and 53c667f8-b6b9-431e-991e-fd9f9bf5d38f has 2.

Highlighted
Contributor II
Contributor II

Thanks very much.  Wonderful level of detail and a tool to allow me to research further.  I have never used CLI, but will get right on that learning curve.  thanks again.  kls

View solution in original post

Highlighted
Employee
Employee

The Operations Monitor and Reloads Monitor apps also report Task Name | App Name which could be used to count Apps with >1 associated task...

But if the CLI is working, run with it. Thanks @Levi_Turner