Schedule tasks failing after the time of Average duration of successful executions .

[Rajiv-Dharia]

Hi All,

Need suggestion as one of my schedule task which takes 'Average duration of successful executions 7 hour 49 min is failing after 8 hour 19 min. error code is 

24/01/2023 20:56:40 Warning The QlikView Engine is Reloading, it will be killed (Please ignore logged warnings/errors about the kill).
24/01/2023 20:56:42 Error The task "Stage 2/MIP 2015_Maker.qvw" failed. Exception: QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext) at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext) at System.Threading.WaitHandle.WaitOne(Int32 millisecondsTimeout, Boolean exitContext) at SolutionGlobal.ThreadPool.ThreadPoolJob.SafeWaitEvent(WaitHandle eventWaitHandle) at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) --- End of inner exception stack trace --- at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) --- End of inner exception stack trace --- at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
24/01/2023 20:56:42 Error Task failed with exception
24/01/2023 20:56:42 Error Exception=The currently executing operation was aborted.

I increased the time in Time out secounds from 2880 to 30780 but still it failed. Need help!

Regards,

Rajiv Dharia

[Chip_Matejowsky]

Hi @Rajiv-Dharia,

That error typically indicates that the task timed out. Can you provide the full task log?

In the task log, what is the MaxRunTime (line 7 or so)?

Where did you increase time out settings from 2880 to 30780? In the QVDistributionService.exe.config? Or some other file? Or in the QMC?

What is full build version? 

What happened between when task last run successfully (11/01/2023) and when task began to consistently fail (12/01/2023)? Where changes made to the application? Was more data added?

Best Regards

[Rajiv-Dharia]

Hi,
I have copied the logs from the QMC, I am using QlikView 11.2 version.
[cid:image001.png@01D930EE.C7CAB2C0]
Logs when the task was unsuccessful.
(2023-01-25 10:29:42) Information: Reloading....
(2023-01-25 10:49:47) Information: Reloading.....
(2023-01-25 11:09:53) Information: Reloading......
(2023-01-25 11:29:59) Information: Reloading.......
(2023-01-25 11:50:04) Information: Reloading........
(2023-01-25 11:57:44) Warning: The QlikView Engine is Reloading, it will be killed (Please ignore logged warnings/errors about the kill).
(2023-01-25 11:57:44) Information: Killing the QlikView Engine. ProcessID=20012
(2023-01-25 11:57:44) Information: Reload was aborted.
(2023-01-25 11:57:46) Information: Closed the QlikView Engine successfully. ProcessID=20012
(2023-01-25 11:57:46) Error: The task "Stage 2/MIP 2015_Maker.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted. || at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext) || at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext) || at System.Threading.WaitHandle.WaitOne(Int32 millisecondsTimeout, Boolean exitContext) || at SolutionGlobal.ThreadPool.ThreadPoolJob.SafeWaitEvent(WaitHandle eventWaitHandle) || at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- End of inner exception stack trace --- || at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2023-01-25 11:57:46) Error: Task failed with exception
(2023-01-25 11:57:46) Error: Exception=The currently executing operation was aborted.
(2023-01-25 11:57:46) Information: Sending Alert mail
(2023-01-25 11:57:49) Information: TaskResult.status=Finished
(2023-01-25 11:57:49) Information: Notifying all triggers of new state:FinishedWithErrors
(2023-01-25 11:57:49) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2023-01-25 11:57:49) Information: Saving Task Result

Logs when the task was successful.
(2023-01-11 22:15:15) Information: Reloading..
(2023-01-11 22:35:17) Information: Reloading...
(2023-01-11 22:55:21) Information: Reloading....
(2023-01-11 23:15:26) Information: Reloading.....
(2023-01-11 23:35:31) Information: Reloading......
(2023-01-11 23:41:56) Information: The Source Document reload complete. DocumentPath=\\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw
(2023-01-11 23:41:56) Information: Memory Allocation Delta for this file=21981.93 Mb. Available Physical Memory Before Reload=231785.79 Mb. Available Physical Memory After Reload=226857.27 Mb. Total Physical Memory=226857.27 Mb.
(2023-01-11 23:41:56) Information: The Source Document was reloaded successfully.
(2023-01-11 23:41:56) Information: Reload finished successfully
(2023-01-11 23:41:56) Information: Start saving document
(2023-01-11 23:42:25) Information: Check in document: \\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP<> 2015_Maker.qvw
(2023-01-11 23:42:25) Information: Closing the document.
(2023-01-11 23:42:29) Information: Closed the QlikView Engine successfully. ProcessID=13024
(2023-01-11 23:42:29) Information: No distribution required.
(2023-01-11 23:42:29) Information: Task Execute Duration=07:52:29.7239254
(2023-01-11 23:42:29) Information: The task "Stage 2/MIP 2015_Maker.qvw" finished successfully
(2023-01-11 23:42:29) Information: TaskResult.status=Finished
(2023-01-11 23:42:29) Information: Notifying all triggers of new state:Finished
(2023-01-11 23:42:29) Information: Notifying all triggers of new state:Finished - completed
(2023-01-11 23:42:29) Information: Saving Task Result

[Chip_Matejowsky]

Hi @Rajiv-Dharia,

Can you attach the logs to the case? The snippets you provided aren't the complete logs. Can you answer the below previously asked questions?

In the task log, what is the MaxRunTime (line 7 or so)?

Where did you increase time out settings from 2880 to 30780? In the QVDistributionService.exe.config? Or some other file? Or in the QMC?

What happened between when task last run successfully (11/01/2023) and when task began to consistently fail (12/01/2023)? Where changes made to the application? Was more data added?

Best Regards

[Rajiv-Dharia]

Hi Mr Matejowsky,
I am attaching the logs in the file attached. Here you can find the MaxRun time, I increased the Timeout from QMC when it is consequently failing since 11 jan 2023. I did not make any changes in QlikView at all, but the size of this application is one of the heaviest application that I have in QlikView.

[Chip_Matejowsky]

Hi @Rajiv-Dharia,

I don't see any logs attached to your previous post. Can you please upload them? Thanks!

Best Regards

[Rajiv-Dharia]

Hi Mr Matejowsky,
It seems the attached file is not successfully sent to you hence sending you again with the content pasted below also.
I am attaching the logs in the file attached. Here you can find the MaxRun time, I increased the Timeout from QMC when it is consequently failing since 11 jan 2023. I did not make any changes in QlikView at all, but the size of this application is one of the heaviest application that I have in QlikView.
2023-01-11 15:49:59) Information: Starting task 'Stage 2/MIP 2015_Maker.qvw'. Id:3df1714f-c418-4126-8842-caa52e121c42. Triggered by 'TaskCompletedTrigger'. Id:9af61218-3bec-4ea7-ad6a-398b78af588e
(2023-01-11 15:49:59) Information: Entering Task Execution.
(2023-01-11 15:49:59) Information: ClusterID=1
(2023-01-11 15:49:59) Information: QDSID=cb05bcf5-5dc2-99a8-2003-2839aeff2b4e
(2023-01-11 15:49:59) Information: TaskID=3df1714f-c418-4126-8842-caa52e121c42
(2023-01-11 15:49:59) Information: MaxRunTime=08:00:00
(2023-01-11 15:49:59) Information: MachineName=SARWOLVM064
(2023-01-11 15:49:59) Information: Max attempts:1
(2023-01-11 15:49:59) Information: Current Attempt=0
(2023-01-11 15:49:59) Information: Task Dependencies are OK
(2023-01-11 15:49:59) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
(2023-01-11 15:49:59) Information: Opening \\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw<>
(2023-01-11 15:49:59) Information: Allocating new QlikView Engine. Current usage count=0 of 5 (of type non-reader).
(2023-01-11 15:49:59) Information: Max retries:5
(2023-01-11 15:49:59) Information: Attempt:01
(2023-01-11 15:50:00) Information: Opened the QlikView Engine successfully. ProcessID=13024

(2023-01-11 15:50:00) Information: Allocated QlikView Engine successfully. Current usage count=1 of 5 (of type non-reader). Ticket number=1350.
(2023-01-11 15:50:00) Information: Loading document \\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw<> (1263.49 Mb)
(2023-01-11 15:50:01) Information: Loading. LoadTime=00:00:00.9999814
(2023-01-11 15:50:03) Information: Loading. LoadTime=00:00:02.9999497
(2023-01-11 15:50:05) Information: Physical FileSize=1263.49 Mb. Memory Allocation Delta for this file=23.65 Mb. Available Physical Memory Before Open=241944.24 Mb. Available Physical Memory After Open=231888.31 Mb. Total Physical Memory=258047.43 Mb.
(2023-01-11 15:50:05) Information: Attempted to load the document without data.
(2023-01-11 15:50:05) Information: The document was loaded successfully.
(2023-01-11 15:50:05) Information: Document was opened successfully
(2023-01-11 15:50:05) Information: Starting reload
(2023-01-11 15:50:05) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.
(2023-01-11 15:50:05) Information: The Source Document is being reloaded. DocumentPath=\\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw

(2023-01-11 15:50:05) Information: Waiting for the document log \\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw<> to become available.. Check until 11/01/2023 15:50:35
(2023-01-11 15:50:05) Information: Found a document log. FileName=\\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw.log
(2023-01-11 15:50:05) Information: Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20230111\154959 - Stage 2_MIP 2015_Maker.qvw\DocumentLog.txt
(2023-01-11 15:50:06) Information: Reloading.
(2023-01-11 15:50:07) Information: Reloading..
(2023-01-11 15:50:08) Information: Reloading...
(2023-01-11 15:50:09) Information: Reloading....
(2023-01-11 15:50:10) Information: Reloading.....
(2023-01-11 15:50:11) Information: Reloading......
(2023-01-11 15:50:12) Information: Reloading.......
(2023-01-11 15:50:13) Information: Reloading........
(2023-01-11 15:50:14) Information: Reloading.........
(2023-01-11 15:50:15) Information: Reloading..........
(2023-01-11 15:50:16) Information: Slow down logging. Log every <2> seconds.
(2023-01-11 15:50:16) Information: Reloading
(2023-01-11 15:50:18) Information: Reloading.
(2023-01-11 15:50:20) Information: Reloading..
(2023-01-11 15:50:22) Information: Reloading...

(2023-01-11 15:50:24) Information: Reloading.... Information: Reloading....
(2023-01-11 15:50:26) Information: Reloading.....
(2023-01-11 15:50:28) Information: Reloading......
(2023-01-11 15:50:30) Information: Reloading.......
(2023-01-11 15:50:32) Information: Reloading........
(2023-01-11 15:50:34) Information: Reloading.........
(2023-01-11 15:50:36) Information: Reloading..........
(2023-01-11 15:50:38) Information: Slow down logging. Log every <10> seconds.
(2023-01-11 15:50:38) Information: Reloading
(2023-01-11 15:50:48) Information: Reloading.
(2023-01-11 15:50:58) Information: Reloading..
(2023-01-11 15:51:08) Information: Reloading...
(2023-01-11 15:51:18) Information: Reloading....
(2023-01-11 15:51:28) Information: Reloading.....
(2023-01-11 15:51:38) Information: Reloading......

(2023-01-11 15:51:48) Information Information: Reloading.......
(2023-01-11 15:51:58) Information: Reloading........
(2023-01-11 15:52:08) Information: Reloading.........
(2023-01-11 15:52:18) Information: Reloading..........
(2023-01-11 15:52:28) Information: Slow down logging. Log every <60> seconds.
(2023-01-11 15:52:28) Information: Reloading
(2023-01-11 15:53:29) Information: Reloading.
(2023-01-11 15:54:29) Information: Reloading..
(2023-01-11 15:55:29) Information: Reloading...
(2023-01-11 15:56:29) Information: Reloading....
(2023-01-11 15:57:30) Information: Reloading.....
(2023-01-11 15:58:30) Information: Reloading......
(2023-01-11 15:59:30) Information: Reloading.......
(2023-01-11 16:00:30) Information: Reloading........
(2023-01-11 16:01:30) Information: Reloading.........
(2023-01-11 16:02:31) Information: Reloading..........
(2023-01-11 16:03:31) Information: Slow down logging. Log every <300> seconds.
(2023-01-11 16:03:31) Information: Reloading
(2023-01-11 16:08:32) Information: Reloading.

(2023-01-11 16:13:34) Information: Reloading.. Information: Reloading..
(2023-01-11 16:18:35) Information: Reloading...
(2023-01-11 16:23:36) Information: Reloading....
(2023-01-11 16:28:37) Information: Reloading.....
(2023-01-11 16:33:39) Information: Reloading......
(2023-01-11 16:38:40) Information: Reloading.......
(2023-01-11 16:43:41) Information: Reloading........
(2023-01-11 16:48:42) Information: Reloading.........
(2023-01-11 16:53:43) Information: Reloading..........
(2023-01-11 16:58:44) Information: Slow down logging. Log every <600> seconds.
(2023-01-11 16:58:44) Information: Reloading
(2023-01-11 17:08:46) Information: Reloading.
(2023-01-11 17:18:48) Information: Reloading..
(2023-01-11 17:28:50) Information: Reloading...
(2023-01-11 17:38:52) Information: Reloading....
(2023-01-11 17:48:54) Information: Reloading.....
(2023-01-11 17:58:56) Information: Reloading......
(2023-01-11 18:08:58) Information: Reloading.......

(2023-01-11 18:19:00) Information: Reloading........ Information: Reloading........
(2023-01-11 18:29:02) Information: Reloading.........
(2023-01-11 18:39:03) Information: Reloading..........
(2023-01-11 18:49:06) Information: Slow down logging. Log every <900> seconds.
(2023-01-11 18:49:06) Information: Reloading
(2023-01-11 19:04:08) Information: Reloading.
(2023-01-11 19:19:11) Information: Reloading..
(2023-01-11 19:34:14) Information: Reloading...
(2023-01-11 19:49:17) Information: Reloading....
(2023-01-11 20:04:20) Information: Reloading.....
(2023-01-11 20:19:23) Information: Reloading......
(2023-01-11 20:34:25) Information: Reloading.......
(2023-01-11 20:50:03) Information: Reloading........
(2023-01-11 21:05:07) Information: Reloading.........
(2023-01-11 21:20:10) Information: Reloading..........
(2023-01-11 21:35:12) Information: Slow down logging. Log every <1200> seconds.
(2023-01-11 21:35:12) Information: Reloading
(2023-01-11 21:55:13) Information: Reloading.

(2023-01-11 22:15:15) Information: ReloadingInformation: Reloading..
(2023-01-11 22:35:17) Information: Reloading...
(2023-01-11 22:55:21) Information: Reloading....
(2023-01-11 23:15:26) Information: Reloading.....
(2023-01-11 23:35:31) Information: Reloading......
(2023-01-11 23:41:56) Information: The Source Document reload complete. DocumentPath=\\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw
(2023-01-11 23:41:56) Information: Memory Allocation Delta for this file=21981.93 Mb. Available Physical Memory Before Reload=231785.79 Mb. Available Physical Memory After Reload=226857.27 Mb. Total Physical Memory=226857.27 Mb.
(2023-01-11 23:41:56) Information: The Source Document was reloaded successfully.
(2023-01-11 23:41:56) Information: Reload finished successfully
(2023-01-11 23:41:56) Information: Start saving document
(2023-01-11 23:42:25) Information: Check in document: \\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP<> 2015_Maker.qvw
(2023-01-11 23:42:25) Information: Closing the document.
(2023-01-11 23:42:29) Information: Closed the QlikView Engine successfully. ProcessID=13024
(2023-01-11 23:42:29) Information: No distribution required.
(2023-01-11 23:42:29) Information: Task Execute Duration=07:52:29.7239254
(2023-01-11 23:42:29) Information: The task "Stage 2/MIP 2015_Maker.qvw" finished successfully
(2023-01-11 23:42:29) Information: TaskResult.status=Finished
(2023-01-11 23:42:29) Information: Notifying all triggers of new state:Finished
(2023-01-11 23:42:29) Information: Notifying all triggers of new state:Finished - completed
(2023-01-11 23:42:29) Information: Saving Task Result


Logs when the task is unsuccessful.
2023-01-25 03:24:34) Information: Starting task 'Stage 2/MIP 2015_Maker.qvw'. Id:3df1714f-c418-4126-8842-caa52e121c42. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c
(2023-01-25 03:24:34) Information: Entering Task Execution.
(2023-01-25 03:24:34) Information: ClusterID=1
(2023-01-25 03:24:34) Information: QDSID=cb05bcf5-5dc2-99a8-2003-2839aeff2b4e
(2023-01-25 03:24:34) Information: TaskID=3df1714f-c418-4126-8842-caa52e121c42
(2023-01-25 03:24:34) Information: MaxRunTime=08:33:00
(2023-01-25 03:24:34) Information: MachineName=SARWOLVM064
(2023-01-25 03:24:34) Information: Max attempts:1
(2023-01-25 03:24:34) Information: Current Attempt=0
(2023-01-25 03:24:34) Information: Task Dependencies are OK
(2023-01-25 03:24:34) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
(2023-01-25 03:24:34) Information: Opening \\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw<>
(2023-01-25 03:24:34) Information: Allocating new QlikView Engine. Current usage count=2 of 5 (of type non-reader).
(2023-01-25 03:24:34) Information: Max retries:5
(2023-01-25 03:24:34) Information: Attempt:01
(2023-01-25 03:24:36) Information: Opened the QlikView Engine successfully. ProcessID=20012
(2023-01-25 03:24:36) Information: Allocated QlikView Engine successfully. Current usage count=3 of 5 (of type non-reader). Ticket number=569.
(2023-01-25 03:24:36) Information: Loading document \\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw<> (1284.07 Mb)
(2023-01-25 03:24:37) Information: Loading. LoadTime=00:00:01.0000209
(2023-01-25 03:24:37) Information: Physical FileSize=1284.07 Mb. Memory Allocation Delta for this file=23.77 Mb. Available Physical Memory Before Open=234894.30 Mb. Available Physical Memory After Open=234854.62 Mb. Total Physical Memory=258047.43 Mb.
(2023-01-25 03:24:37) Information: Attempted to load the document without data.
(2023-01-25 03:24:37) Information: The document was loaded successfully.
(2023-01-25 03:24:37) Information: Document was opened successfully
(2023-01-25 03:24:37) Information: Starting reload
(2023-01-25 03:24:37) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.
(2023-01-25 03:24:37) Information: The Source Document is being reloaded. DocumentPath=\\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw
(2023-01-25 03:24:37) Information: Waiting for the document log \\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw<> to become available.. Check until 25/01/2023 3:25:07
(2023-01-25 03:24:37) Information: Found a document log. FileName=\\10.10.1.64\D$\QLIKVIEW\STAGE2\MIP 2015_Maker.qvw.log
(2023-01-25 03:24:37) Information: Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20230125\032434 - Stage 2_MIP 2015_Maker.qvw\DocumentLog.txt
(2023-01-25 03:24:38) Information: Reloading.
(2023-01-25 03:24:39) Information: Reloading..
(2023-01-25 03:24:40) Information: Reloading...
(2023-01-25 03:24:41) Information: Reloading....
(2023-01-25 03:24:42) Information: Reloading.....
(2023-01-25 03:24:43) Information: Reloading......
(2023-01-25 03:24:44) Information: Reloading.......
(2023-01-25 03:24:45) Information: Reloading........
(2023-01-25 03:24:46) Information: Reloading.........
(2023-01-25 03:24:47) Information: Reloading..........
(2023-01-25 03:24:48) Information: Slow down logging. Log every <2> seconds.
(2023-01-25 03:24:48) Information: Reloading
(2023-01-25 03:24:50) Information: Reloading.
(2023-01-25 03:24:52) Information: Reloading..
(2023-01-25 03:24:54) Information: Reloading...
(2023-01-25 03:24:56) Information: Reloading....
(2023-01-25 03:24:58) Information: Reloading.....
(2023-01-25 03:25:00) Information: Reloading......
(2023-01-25 03:25:02) Information: Reloading.......
(2023-01-25 03:25:04) Information: Reloading........
(2023-01-25 03:25:06) Information: Reloading.........
(2023-01-25 03:25:08) Information: Reloading..........
(2023-01-25 03:25:10) Information: Slow down logging. Log every <10> seconds.
(2023-01-25 03:25:10) Information: Reloading
(2023-01-25 03:25:20) Information: Reloading.
(2023-01-25 03:25:30) Information: Reloading..
(2023-01-25 03:25:40) Information: Reloading...
(2023-01-25 03:25:50) Information: Reloading....
(2023-01-25 03:26:00) Information: Reloading.....
(2023-01-25 03:26:10) Information: Reloading......
(2023-01-25 03:26:20) Information: Reloading.......
(2023-01-25 03:26:30) Information: Reloading........
(2023-01-25 03:26:40) Information: Reloading.........
(2023-01-25 03:26:50) Information: Reloading..........
(2023-01-25 03:27:01) Information: Slow down logging. Log every <60> seconds.
(2023-01-25 03:27:01) Information: Reloading
(2023-01-25 03:28:01) Information: Reloading.
(2023-01-25 03:29:01) Information: Reloading..
(2023-01-25 03:30:01) Information: Reloading...
(2023-01-25 03:31:02) Information: Reloading....
(2023-01-25 03:32:02) Information: Reloading.....
(2023-01-25 03:33:02) Information: Reloading......
(2023-01-25 03:34:02) Information: Reloading.......
(2023-01-25 03:35:03) Information: Reloading........
(2023-01-25 03:36:03) Information: Reloading.........
(2023-01-25 03:37:03) Information: Reloading..........
(2023-01-25 03:38:03) Information: Slow down logging. Log every <300> seconds.
(2023-01-25 03:38:03) Information: Reloading
(2023-01-25 03:43:04) Information: Reloading.
(2023-01-25 03:48:05) Information: Reloading..
(2023-01-25 03:53:07) Information: Reloading...
(2023-01-25 03:58:08) Information: Reloading....
(2023-01-25 04:03:09) Information: Reloading.....
(2023-01-25 04:08:11) Information: Reloading......
(2023-01-25 04:13:12) Information: Reloading.......
(2023-01-25 04:18:13) Information: Reloading........
(2023-01-25 04:23:14) Information: Reloading.........
(2023-01-25 04:28:16) Information: Reloading..........
(2023-01-25 04:33:17) Information: Slow down logging. Log every <600> seconds.
(2023-01-25 04:33:17) Information: Reloading
(2023-01-25 04:43:20) Information: Reloading.
(2023-01-25 04:53:22) Information: Reloading..
(2023-01-25 05:03:25) Information: Reloading...
(2023-01-25 05:13:27) Information: Reloading....
(2023-01-25 05:23:29) Information: Reloading.....
(2023-01-25 05:33:31) Information: Reloading......
(2023-01-25 05:43:34) Information: Reloading.......
(2023-01-25 05:53:36) Information: Reloading........
(2023-01-25 06:03:39) Information: Reloading.........
(2023-01-25 06:13:41) Information: Reloading..........
(2023-01-25 06:23:43) Information: Slow down logging. Log every <900> seconds.
(2023-01-25 06:23:43) Information: Reloading
(2023-01-25 06:38:46) Information: Reloading.
(2023-01-25 06:53:49) Information: Reloading..
(2023-01-25 07:08:53) Information: Reloading...
(2023-01-25 07:23:56) Information: Reloading....
(2023-01-25 07:39:00) Information: Reloading.....
(2023-01-25 07:54:05) Information: Reloading......
(2023-01-25 08:09:09) Information: Reloading.......
(2023-01-25 08:24:12) Information: Reloading........
(2023-01-25 08:39:16) Information: Reloading.........
(2023-01-25 08:54:22) Information: Reloading..........
(2023-01-25 09:09:27) Information: Slow down logging. Log every <1200> seconds.
(2023-01-25 09:09:27) Information: Reloading
(2023-01-25 09:29:34) Information: Reloading.
(2023-01-25 09:49:39) Information: Reloading..
(2023-01-25 10:09:41) Information: Reloading...
(2023-01-25 10:29:42) Information: Reloading....
(2023-01-25 10:49:47) Information: Reloading.....
(2023-01-25 11:09:53) Information: Reloading......
(2023-01-25 11:29:59) Information: Reloading.......
(2023-01-25 11:50:04) Information: Reloading........
(2023-01-25 11:57:44) Warning: The QlikView Engine is Reloading, it will be killed (Please ignore logged warnings/errors about the kill).
(2023-01-25 11:57:44) Information: Killing the QlikView Engine. ProcessID=20012
(2023-01-25 11:57:44) Information: Reload was aborted.
(2023-01-25 11:57:46) Information: Closed the QlikView Engine successfully. ProcessID=20012
(2023-01-25 11:57:46) Error: The task "Stage 2/MIP 2015_Maker.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted. || at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext) || at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext) || at System.Threading.WaitHandle.WaitOne(Int32 millisecondsTimeout, Boolean exitContext) || at SolutionGlobal.ThreadPool.ThreadPoolJob.SafeWaitEvent(WaitHandle eventWaitHandle) || at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- End of inner exception stack trace --- || at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2023-01-25 11:57:46) Error: Task failed with exception
(2023-01-25 11:57:46) Error: Exception=The currently executing operation was aborted.
(2023-01-25 11:57:46) Information: Sending Alert mail
(2023-01-25 11:57:49) Information: TaskResult.status=Finished
(2023-01-25 11:57:49) Information: Notifying all triggers of new state:FinishedWithErrors
(2023-01-25 11:57:49) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2023-01-25 11:57:49) Information: Saving Task Result
Stage 2/MIP 2015_Maker.qvw
Execution Started
Status
Duration
25/01/2023 3:24:34<>
Failed
8 hours 33 min 15 sec
24/01/2023 12:23:29<>
Failed
8 hours 33 min 15 sec
24/01/2023 4:15:32<>
Failed
8 hours 17 sec
23/01/2023 8:53:03<>
Failed
8 hours 14 sec
22/01/2023 4:13:35<>
Failed
8 hours 19 sec
20/01/2023 4:17:39<>
Failed
8 hours 15 sec
19/01/2023 13:11:30<>
Failed
8 hours 16 sec
18/01/2023 4:11:06<>
Failed
8 hours 16 sec
17/01/2023 2:56:37<>
Failed
8 hours 14 sec
16/01/2023 15:58:31<>
Failed
8 hours 14 sec
15/01/2023 4:12:43<>
Failed
8 hours 15 sec
14/01/2023 4:21:20<>
Failed
8 hours 14 sec
13/01/2023 14:19:50<>
Failed
8 hours 16 sec
13/01/2023 4:13:17<>
Failed
8 hours 17 sec
12/01/2023 16:16:10<>
Failed
8 hours 15 sec
12/01/2023 4:13:30<>
Failed
8 hours 15 sec
11/01/2023 15:49:59<>
Completed
7 hours 52 min 29 sec
10/01/2023 14:18:29<>
Failed
8 hours 16 sec
10/01/2023 4:19:04<>
Failed
8 hours 16 sec
8/01/2023 4:13:58<>
Failed
8 hours 18 sec
7/01/2023 4:13:17<>
Failed
8 hours 18 sec
6/01/2023 13:09:10<>
Failed
8 hours 14 sec
6/01/2023 4:11:26<>
Failed
8 hours 19 sec
5/01/2023 14:18:23<>
Completed
7 hours 54 min 53 sec
5/01/2023 4:14:31<>
Failed
8 hours 18 sec
4/01/2023 14:22:54<>
Failed
8 hours 15 sec
4/01/2023 4:17:23<>
Failed
8 hours 16 sec
3/01/2023 4:13:18<>
Failed
8 hours 16 sec
2/01/2023 15:34:45<>
Completed
7 hours 55 min 57 sec
30/12/2022 18:46:43<>
Failed
8 hours 24 sec
29/12/2022 18:03:29<>
Failed
8 hours 14 sec
29/12/2022 4:09:58<>
Failed
8 hours 15 sec
28/12/2022 4:14:34<>
Completed
7 hours 55 min 11 sec
27/12/2022 4:12:15<>
Completed
7 hours 39 min 13 sec
26/12/2022 16:02:44<>
Completed
7 hours 39 min 5 sec
Last updated @ 25/01/2023 14:49:13 Automatic

[Chip_Matejowsky · Accepted solution]

Hi @Rajiv-Dharia,

The failed task has  MaxRunTime=08:33:00 configured, so if task isn't completed in 8:33:00, the task will stop. The start time of the failed task was 03:24 and the end time was 11:57. That's 8:33:00 exactly. To increase the maximum runtime of the task, edit the task in the QMC > Status > Tasks > Edit (Pencil icon) > Server tab > Performance.

Best Regards

[Rajiv-Dharia · Accepted solution]

Hi Chip_Matejowsky,

It seems this changes are successful as after the changes the Tasks able to successfully reload the data Twice. Execution time is though different in those two loads. Below is the screenshot for the same.

Regards,

Rajiv Dharia,

Application Support Analyst

QV Support

[Maria_Halley]

@Rajiv-Dharia 

It is normal that a reload times varies. There are a lot of variables like, load on the server at the reload time, connection and response times from data sources etc.