QMC Reload Process

[fkeuroglian]

Hi people i would like to know if there is a posibility to create a Defensive programing in the reload procedure.

for example, i have 3 etl, and they are in secuence: ETL1 then ETL2 then ETL3

now i have checked the option "on event from another task succesfull" and then execute the etl

but if etl1 fail, stop all the process and etl2 and etl3 do not complety and reload ok.

is there a way to create some flag or something to have the posibility to:

RUN ETL1;

IF ETL1 OK THEN

     RUN ETL2

ELSE

     RUN ETL2

IF ETL2 OK THEN

     RUN ETL3

ELSE

     RUN ETL3

Thank you a lot people all the help will be appreciated !

Fernando

[Chris_Rice]

You should be able to just create two tasks for ETL2 and 3.  So:

IF ETL1 OK THEN

     RUN ETL2 Task 1

ELSE

     RUN ETL2 Task 2

IF ETL2 OK THEN

     RUN ETL3 Task 1

ELSE

     RUN ETL3 Task 2

Both Task 1 and Task 2 are the same thing, just triggered differently.

[rwunderlich]

If I understand, you want to run ETL2 when ETL1 completes, either successful or failure? Do you have Publisher? If so, you can define both triggers.

-Rob

[fkeuroglian]

Hi, Rob

I do not have publisher, there is another posibility without publisher?

thank you rob

[Chris_Rice]

I don't think that's possible with QlikView sans Publisher, but you should be able to set up external tasks and triggers.

http://community.qlik.com/docs/DOC-3024

[#6]

Just create 2 triggers; one for success and another for failure

[fkeuroglian]

Kiru, explain more

what would you use and put an example , where and how do you create the two triggers?