Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
martinstrumann
Partner - Contributor II
Partner - Contributor II

QMC Task Trigger on Event finished (success or failed)

Hey Guys,

i there a possibility to trigger a Task on just a finished (does not matter if sucess or failed) previous Task in Qlik Sense?

 

Discalimer:

Of yourse you can create two triggers for the Task to run. One on success and one on fail from the previos Task. In my case unfortunatly we have multiple previous tasks, which all have to be finished before the new task should start.  This situation can't be fixed with the above solution, because for 5 previous tasks you have to creat i.e. 25 seperate triggers for every combination of fail/success.

 

 

Labels (5)
2 Solutions

Accepted Solutions
Gysbert_Wassenaar

No, there isn't. It's just success or fail. You'll either have to chain the preceding tasks so you can add a success and fail for each chained task. That means 10 triggers instead of 25. You still need a lot of triggers and you lose parallellism in the task execution.

The other option is to make sure that a reload always finishes by setting ErrorMode to 0 in the load scripts of the other apps and do any error handling yourself instead of letting the reload fail.


talk is cheap, supply exceeds demand

View solution in original post

Levi_Turner
Employee
Employee

I like @Gysbert_Wassenaar 's suggestion. Because at its core, the goal of chaining reloads together builds off the assumption that successful reload of the parent is integral for the dependencies for the child. If you break that assumption then things can get tricky inside of Qlik Sense. You can merge @Gysbert_Wassenaar 's with something like the Qlik SMTP / Notification Connector (https://community.qlik.com/t5/Qlik-Architecture-Deep-Dive-Blog/Qlik-SMTP-Notification-Connector/ba-p...) which can allow for email notifications on failures for that specific task so that you do have some signal of a success / failure for that individual task whose apparent success or failure isn't key to the chain of ETL work being done by the tasks.

View solution in original post

4 Replies
Anil_Babu_Samineni

If you talk about dependency tasks. Yes you can create based on previous task. You can see option, Success or failure on dependency. 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
martinstrumann
Partner - Contributor II
Partner - Contributor II
Author

Hi Anil,

 

i think you talk about QlikView, aren't you? Can you please provide a screenshot where i can find this on QlikSense?

 

BR,

Martin

Gysbert_Wassenaar

No, there isn't. It's just success or fail. You'll either have to chain the preceding tasks so you can add a success and fail for each chained task. That means 10 triggers instead of 25. You still need a lot of triggers and you lose parallellism in the task execution.

The other option is to make sure that a reload always finishes by setting ErrorMode to 0 in the load scripts of the other apps and do any error handling yourself instead of letting the reload fail.


talk is cheap, supply exceeds demand
Levi_Turner
Employee
Employee

I like @Gysbert_Wassenaar 's suggestion. Because at its core, the goal of chaining reloads together builds off the assumption that successful reload of the parent is integral for the dependencies for the child. If you break that assumption then things can get tricky inside of Qlik Sense. You can merge @Gysbert_Wassenaar 's with something like the Qlik SMTP / Notification Connector (https://community.qlik.com/t5/Qlik-Architecture-Deep-Dive-Blog/Qlik-SMTP-Notification-Connector/ba-p...) which can allow for email notifications on failures for that specific task so that you do have some signal of a success / failure for that individual task whose apparent success or failure isn't key to the chain of ETL work being done by the tasks.