Can I stop a document that has been loading for 14 hours

[#1]

Recently we have had some documents get hung in loading, and was wondering if there was a way to automatically fail a load if it has been running for x amount of time.  As you can see in the attachment, a normally 5 minute load was running for 14 hours.  Since it happened at 5pm, nobody noticed it until the next morning.  Is there a setting that we could automatically fail a load if it is running for an hour?

[ThornOfCrowns]

The answer here: http://community.qlik.com/thread/32208 may be useful.

[ergustafsson · Accepted solution]

Hi Todd,

Absolutely, there is a timeout setting in the task tab "Triggers" called "Timeout in minutes". By default it is 24 hours.

Regards,

Erik

[#4]

Thank you. That’s what I was looking for. Is there a global setting, or do I have to go into each trigger and apply the timeout?

[ergustafsson]

Hi!

I recommend you to use the GUI of the QMC and do it manually, but you can set a global setting to:

In C:\Program Files\QlikView\Distribution Service\QlikviewDistributionService.exe.config, add the following entry to change the global task time out setting:

<add key="AbsoluteMaximumMinutesBeforeTaskTimeout" value="2880"/>

You will have to make sure this setting is reviewed after each upgrade as there is a chance it could be overwritten.

Restart the QDS service(s) after making this change.

Regards,

Erik

[#6]

Is the global setting overridable by the individual trigger setting? For example, If I set the global setting to 30 minutes, but one one particular load I need to extend it to an hour, can I set that individual trigger to 60 minutes, or does the global setting trump all?

[ergustafsson]

Hi Todd,

I believe it is the lowest possible value, meaning if the global setting is 30 and the task setting is 60, the task will be killed after 30 minutes. Should be easy enough to confirm and test this though. Set the global setting to any maximum value you might want to use, i.e. 24 hours/1440 minutes.

Regards,

Erik