Qlik Application Automation: How to automatically rerun a failed automation

[J_Lindberg]

An automation will not automatically rerun or retry if it fails. You can, however, rerun a failed automation by using an additional automation. 

Caution should be taken when implementing this solution to prevent running endless loops or reruns. 

• Considerations
• Retry Automation Run
• Run Automation
• Rerun example
• Full Automation

 

Considerations

Before a solution can be implemented you must decide if the rerun should:

1. Retry the failed automation run using the same, if any, input.
2. Initiate an entirely new run of the automation.

Retry Automation Run

The block Retry Automation Run can be used to retry a specific run of the automation using the same, if any, inputs. This block is useful if the monitored automation has its run mode set to Webhook or Triggered. It is also possible to manually re-run these runs using the Retry button in the automations run history.

Run Automation

The block Run Automation can be used to initiate a new run of the automation. This block is useful if the automation that fails has the run mode set to Scheduled, and the inputs of the failed run wouldn’t be unique.

Rerun example

The following example shows how a failed automation can be retried using the Retry Automation Run. Depending on the specifics of the automation you want to rerun, you may want to use the Run Automation block instead.

1. Use the block List My Automations to get all of your automations.
2. Then use the block List Automation Runs to only get the runs that have failed by filtering on status:
   
   
   
   
3. Use the block Transform List to create a list of failed runs. Add the two fields id and stopTime to this list and configure them such as this:
   
   
   
   
   
   

   The value for stopTime must be transformed using the Date formula so that the value may be used for comparisons. The output format must be changed to Unix format (U):

   
   
   
4. Now use the block Filter List to only get the most recently failed runs.
   
   
   
   The condition that controls how recent failed runs you would like to retry can be configured according to your needs by modifying the "Date" formula. Ensure that you configure the output format to be in Unix format (U). In this case runs that has failed within 30 minutes will be rerun:
   
   
   
   
5. The final step is to include one of the blocks Retry Automation Run or Run Automation, depending on what you are trying to achieve. This is an example of how the Retry Automation Run should be configured:
   
   
   
   In case the Run Automation block is used, only the "Automation Id" is needed as input.

Full Automation

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

[MartW]

Can this post be updated with them most recent automation.
I think that the transform block was updated after this post was made.

I caught me off guard when testing this and I created an infinite loop.

[Ken_T]

do reloads done by an automation, show up in the reloads history of the app?

(once I do one of these, I will check and confirm)