Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

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

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?


1 Solution

Accepted Solutions
erikadvectas
Valued Contributor

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

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

6 Replies
thornofcrowns
Valued Contributor II

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

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

erikadvectas
Valued Contributor

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

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

Not applicable

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

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?

erikadvectas
Valued Contributor

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

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

Not applicable

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

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?

erikadvectas
Valued Contributor

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

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

Community Browser