Single Document trigger by successful completion of Multiple Reloads

[#1]

Is it possible to trigger the reload of a single document after a two or more reload tasks are successful?

I am not looking for a OR clause, rather if A and B and C have successfully reloaded, reload D.

Document A, B, and C create .QVD files to be loaded by Document D.  I need A, B, and C to successfully complete, then have D trigger to reload.  If A, B, or C fail, D should not be reloaded.

James

[Bill_Britt · Accepted solution]

Yes, this is possible if you have a publisher license.

[#3]

Hi James

As Bill said this is possible only if you have a QlikView Publisher license.

What it actually does is slightly different but it achieves the same thing. When one of the listed reloads finishes it checks to see if the others all completed successfully within a definable time period. If they have it will run the reload, if not it won't.

Matt

[bnichol]

This can be done by adding Task Dependencies in QEMC > Documents > Source Documents > Triggers >Task Dependencies.

Good luck,

B

[#5]

Matt,

In V11, I see the trigger of 'On multiple events completed', is this what your are referring to?

James

[Bill_Britt]

That is it.

[#7]

It appears that a combination of 'On multiple events completed' trigger and the task dependencies is the solution.

To test this theory, I setup a pause task which triggers 4 document reloads.  The first 3 reloads are very fast, the 4th takes about 2 minutes to complete.  I then setup a 5 document to be triggered by the succesful completion of the 4 documents.  However, without the dependency check, the 5th document would start reloading before the long running 4th document finished.

Thanks to all!

James

[santhosh_k_n]

Hi B,

I had a question on your point,

I had task A say QVD generator, and Task B should run after the QVD Gen.

I scheduled for Task A & B at 08:00 AM but for Task B I given Task Dependency as Task A, But both are starting at same time and Task B is reflecting the old data rather than the refreshed New data.

Can u suggest on thsi.

Thanks

Santhosh N

[bnichol]

Should Task A and Task B really be dependencies?  Is Task based on the QVDs in Task A?

If Task B needs components of Task A, then it should be triggered on the successful completion.

Based on your original question, Task D should be triggered following Tasks A, B, and C.  You can add dependencies on other jobs, but dependencies only checks that the job completed successfully, not that it is still running.

If Tasks A, B, and C need to run concurrently, then I would either trigger Task D on successful completion of the longest running job, or schedule the job at a time when the other task should have completed by 5 or 10 minutes.

Hope this helps,

B

[santhosh_k_n]

Thanks D.

This solutions solves  my problem