Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Single Document trigger by successful completion of Multiple Reloads

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

Tags (3)
1 Solution

Accepted Solutions
Employee
Employee

Single Document trigger by successful completion of Multiple Reloads

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

9 Replies
Employee
Employee

Single Document trigger by successful completion of Multiple Reloads

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

Not applicable

Single Document trigger by successful completion of Multiple Reloads

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
Valued Contributor

Single Document trigger by successful completion of Multiple Reloads

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

Good luck,

B

Not applicable

Single Document trigger by successful completion of Multiple Reloads

Matt,

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

James

Employee
Employee

Single Document trigger by successful completion of Multiple Reloads

That is it.

Not applicable

Single Document trigger by successful completion of Multiple Reloads

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
Contributor

Re: Single Document trigger by successful completion of Multiple Reloads

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
Valued Contributor

Re: Single Document trigger by successful completion of Multiple Reloads

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
Contributor

Re: Single Document trigger by successful completion of Multiple Reloads

Thanks D.

This solutions solves  my problem

Community Browser