Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
I am currently working with Qlik Cloud and managing Some apps/dashboards. At present, whenever a reload job fails, we receive an email notification, and an admin manually searches for the app and triggers the reload again.
I would like to implement an automation to optimize this process with the following logic:
Automatic Retry on Failure
If a reload job fails, the system should automatically trigger a retry.
If the retry also fails, then an email notification should be sent.
Handling Different App Structures:
Some apps are standalone (no dependencies).
Some apps have dependencies:
1 ETL → 1 Dashboard
→ Dashboard should reload only if ETL succeeds.
2 ETLs → 1 Dashboard
3 ETLs → 1 Dashboard
4 ETLs → 1 Dashboard
In all dependent cases, dashboards should reload only if all associated ETL tasks are successful.
Expected Automation Behavior
Retry failed ETL/app reload automatically.
Trigger dependent dashboard reload only after successful ETL completion.
Send email alert only after retry failure.
Avoid unnecessary dashboard reloads if ETL fails.
I believe this can be implemented using Qlik Application Automation (possibly with webhooks).
Could you please guide me with:
Step-by-step instructions to build this automation in Qlik Cloud
Which blocks to use and where to configure them
How to handle dependencies between ETL and dashboard apps
Best practices for retry logic and error handling
Your guidance would be highly appreciated.
Thank you for your support.
Best regards,
Ashith A V
Hi @Ashi03,
I did a Qlik Automation that I believe covers all your requirements. I have skipped the part to send emails but, I put an indication where you can handle that - see the JSON attached, you can import this JSON file into your Qlik Automation - right click in the canvas of a new Qlik Automation and select Upload Workspace and select the JSON file I sent.
A quick explanation:
Add in the variable AppList the list of ETL Applications you need to reload prior to the Dashboard Application. All the ETL Applications will reload in parallel.
The process then is about checking the Reload Status of each Application and if it finds an error, retry for a second time. If that fails, I stop the process.
If everything runs fine, the automation will reload the Dashboard Application.
I hope it helps!
Regards,
Mark Costa
Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com