Load script stops suddenly, causing scheduled execution to fail
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?
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 🙂