topic Re: Load script stops suddenly, causing scheduled execution to fail in QlikView

Load script stops suddenly, causing scheduled execution to fail

Anonymous — Mon, 05 Nov 2018 10:14:00 GMT

Good morning community!

I'm having an issue with a scheduled load execution in Qlikview. My Create_QVD is scheduled to run on Sunday at 15:00, but often I'll check the schedule on Monday to find that this run has failed. I check the log, and there is no error message; the script seems to just stop suddenly.

Every time that this has happened, it has always stopped at the exact same place. The last line is always "Order Discount from Current Retail Price, "

This is attempting to load an archived version of the transactional table to concatenate to this week's version of the table.

Please see below the section of my load script that the execution stops at:

Is this an issue with memory? Or with the load script?

Thanks,

Henry

Re: Load script stops suddenly, causing scheduled execution to fail

prieper — Mon, 05 Nov 2018 13:38:20 GMT

Hard to judge without further details ...

But looks very much to be a memory-problem.

What happens, when you run it on local computer?

Re: Load script stops suddenly, causing scheduled execution to fail

RadovanOresky — Mon, 05 Nov 2018 14:27:35 GMT

Well, it could also be caused by the Timeout limit for the document reload.

I believe that the default timeout is 21600, which is 6 hours.

If it started at 1500, than it was already 5 hours running, when it started the last logged load. It looks like a big one, so it might not have enough time to finish.

If this will end up the be the cause, I suggest you either increase the timeout limit in the QMC for this document, or segment the load to multiple smaller / shorter loads.

Radovan

Re: Load script stops suddenly, causing scheduled execution to fail

Anonymous — Mon, 05 Nov 2018 14:37:36 GMT

I'll try running it manually now. So far it seems to be fine. It may be a few hours before I can give a proper answer, though

Re: Load script stops suddenly, causing scheduled execution to fail

Anonymous — Mon, 05 Nov 2018 14:43:44 GMT

Hi Radovan,

Do you know where I can find the option to increase the timeout value in QMC? I can't find it under the 'Documents' tab

Re: Load script stops suddenly, causing scheduled execution to fail

passionate — Mon, 05 Nov 2018 14:46:38 GMT

The best place to find issue is Qlikview server log.

Re: Load script stops suddenly, causing scheduled execution to fail

Anonymous — Mon, 05 Nov 2018 14:52:05 GMT

Hi Pankaj,

Do you know where the server logs would usually be kept? Or how I can find out where they are kept?

Re: Load script stops suddenly, causing scheduled execution to fail

Peter_Cammaert — Mon, 05 Nov 2018 15:06:33 GMT

I'm assuming that you don't have a Publisher license, because in a standard task definition the default timeout is 1440 minutes or 24 hrs. On a Publisher-less server, you can find the timeout field on the Reload tab here:

Note: to make sure that a reload engine being killed due to a timeout really is the cause of failure, check the TaskLog.txt file in the relevant subfolder of the QDS tree (C:\ProgramData\QlikTech\DistributionService\1\Log\). It should list an error message about "...engine aborted..." or something like that, while the DocumentLog doesn't tell you anything (being killed makes that rather difficult 🙂

Re: Load script stops suddenly, causing scheduled execution to fail

RadovanOresky — Mon, 05 Nov 2018 15:13:45 GMT

Hi, if you have Small Business Edition server, the option is on:

Documents tab > select one document > Reload sub-tab (right side of the screen) > Timeout in seconds option.

You need to hit Apply after you change it.

On Enterprise Edition server, this option is on the reload task on Source Documents on the Triggers subtab (here it states the timeout in minutes).

Radovan

Re: Load script stops suddenly, causing scheduled execution to fail

Anonymous — Mon, 05 Nov 2018 15:34:45 GMT

Hi Peter,

I believe I've found the log for this reload in the location you've specified above, and the error message is as follows:

From what I can gather, this is indeed a timeout issue

Re: Load script stops suddenly, causing scheduled execution to fail

Peter_Cammaert — Tue, 06 Nov 2018 12:50:24 GMT

So it seems.

If I remember correctly, in the TaskLog and a few lines before the one you included in your reply, the QlikView Distribution Service (that generates this particular log file) states its intent to kill your reload engine on a single terse line. The stack traces like the one in the screenshot contain a lot of information that is probably more useful for Qlik Support than it is for us...