topic Re: Trigger on QMC in QlikView

Trigger on QMC

priyarane — Wed, 04 Nov 2015 13:19:48 GMT

Hi Community,

There are 4 triggers have been assigned on task but without completing the the 4 task it is starting and failed.. as attached

Re: Trigger on QMC

roger_stone — Wed, 04 Nov 2015 13:22:34 GMT

Has that qvw been deleted or have you really used upper case for its name?

Re: Trigger on QMC

Anonymous — Wed, 04 Nov 2015 13:28:44 GMT

Your problem is that the task with the 4 triggers are starting, even though only three of the trigger tasks have run?

If I remember correctly, you have a time option for which the trigger tasks has to be successfully run (e.g.120 minutes). If the "fourth" trigger task has run some time within this time frame, even before the three others, that task will run. Try to lower that time frame.

There is no sequence of triggers, it only says "these four task has to have run successfully within the specified time frame".

Re: Trigger on QMC

priyarane — Wed, 04 Nov 2015 13:38:43 GMT

Hi Kim,

The last task generally takes 5 hours to completed. but we are using 360 time constraint as below so could you pleas suggest me

Re: Trigger on QMC

priyarane — Wed, 04 Nov 2015 13:39:45 GMT

it is not delted one and it exists as it is

Re: Trigger on QMC

Anonymous — Wed, 04 Nov 2015 13:41:31 GMT

Does the three transforms use data from the 67_EXT_HNAH_GL_RECON_RETAIL extract?

Re: Trigger on QMC

priyarane — Wed, 04 Nov 2015 13:50:41 GMT

Re: Trigger on QMC

Anonymous — Thu, 05 Nov 2015 13:16:04 GMT

Make sure you extract (which takes ~5 hours) starts two-three hours before your transforms. Then set the Time constraint to a lower value. Then you will be able to trigger the task once both the extract and the transforms has successfully run within the same time frame.