Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

cancel
Showing results for 
Search instead for 
Did you mean: 
kwoklimho
Partner
Partner

Reload task Failure

Dear All,

We have settled the schedule task in QMC. The scheduled reload task keeps failure after June 2019. We are using QlikView 11.13. The issue logs are provided.

PRD - ext prg - P20_DocXXX_sales_by_store_summary_report - stats.PNG

PRD - ext prg - run_qv_dm_sales_tranx_fact_reports_batch1 - stats.PNG

  

3 Replies
kwoklimho
Partner
Partner
Author

-------------------------------------------------------First issue log-----------------------------------------------------------------------------------

(2019-08-19 08:00:43) Information: Starting task 'PRD - ext prg - P20_DocXXX_sales_by_store_summary_report'. Id:3b69f6ac-cb2e-41ce-898b-9fa5b1e04229. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c(2019-08-19 08:00:43) Information: Entering Task Execution.
(2019-08-19 08:00:43) Information: ClusterID=1(2019-08-19 08:00:43) Information: QDSID=57db244d-6edc-eaa7-56fb-54959ed84d83
(2019-08-19 08:00:43) Information: TaskID=3b69f6ac-cb2e-41ce-898b-9fa5b1e04229(2019-08-19 08:00:43) Information: MaxRunTime=1.00:00:00
(2019-08-19 08:00:43) Information: MachineName=BUSTARD(2019-08-19 08:00:43) Information: Max attempts:1
(2019-08-19 08:00:43) Information: Current Attempt=0(2019-08-19 08:00:43) Information: Task Dependencies are OK
(2019-08-19 08:00:43) Information: Executing "d:\Project\SanMiu-P20\09_External Program\P20_DocXXX_sales_by_store_summary_report.bat"
(2019-08-19 08:00:43) Information: Executing commandline: "d:\Project\SanMiu-P20\09_External Program\P20_DocXXX_sales_by_store_summary_report.bat" in folder "d:\Project\SanMiu-P20\09_External Program".(2019-08-19 08:00:47) Information: The process exited with ExitCode zero (OK) at 8/19/2019 8:00:47 AM
(2019-08-19 08:00:47) Information: Task Execute Duration=00:00:04.3437298
(2019-08-19 08:00:47) Information: The task "PRD - ext prg - P20_DocXXX_sales_by_store_summary_report" finished successfully
(2019-08-19 08:00:47) Information: TaskResult.status=Finished(2019-08-19 08:00:47) Information: Notifying all triggers of new state:Finished
(2019-08-19 08:00:47) Information: Notifying all triggers of new state:Finished - completed
(2019-08-19 08:00:47) Information: Saving Task Result

-------------------------------------------------------Second issue log-----------------------------------------------------------------------------------

(2019-08-19 08:24:49) Information: Starting task 'PRD - ext prg - run_qv_dm_sales_tranx_fact_reports_batch1'. Id:1790fbfe-c747-4054-9af0-da680b4ef8d9. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c
(2019-08-19 08:24:49) Information: Entering Task Execution. (2019-08-19 08:24:49) Information: ClusterID=1
(2019-08-19 08:24:49) Information: QDSID=57db244d-6edc-eaa7-56fb-54959ed84d83
(2019-08-19 08:24:49) Information: TaskID=1790fbfe-c747-4054-9af0-da680b4ef8d9
(2019-08-19 08:24:49) Information: MaxRunTime=1.00:00:00
(2019-08-19 08:24:49) Information: MachineName=BUSTARD
(2019-08-19 08:24:49) Information: Max attempts:1
(2019-08-19 08:24:49) Information: Current Attempt=0
(2019-08-19 08:24:49) Information: Task Dependencies are OK
(2019-08-19 08:24:49) Information: Executing "d:\Project\SanMiu-P20\09_External Program\run_qv_dm_sales_tranx_fact_reports_batch1.bat"
(2019-08-19 08:24:49) Information: Executing commandline: "d:\Project\SanMiu-P20\09_External Program\run_qv_dm_sales_tranx_fact_reports_batch1.bat" in folder "d:\Project\SanMiu-P20\09_External Program".(2019-08-19 08:26:02) Information: The process exited with ExitCode zero (OK) at 8/19/2019 8:26:02 AM
(2019-08-19 08:26:02) Information: Task Execute Duration=00:01:12.3832361
(2019-08-19 08:26:02) Information: The task "PRD - ext prg - run_qv_dm_sales_tranx_fact_reports_batch1" finished successfully
(2019-08-19 08:26:02) Information: TaskResult.status=Finished(2019-08-19 08:26:02) Information: Notifying all triggers of new state:Finished
(2019-08-19 08:26:02) Information: Notifying all triggers of new state:Finished - completed
(2019-08-19 08:26:02) Information: Saving Task Result

Vegar
MVP
MVP

You are writing "keeps failing after June 2019", but your log shows a single failure. So I assume that it works for the most so there no change in data structures or field names that are causing your trouble.

My best guess would be that you sometimes lack system resources. Do you have multiple tasks running at the same time? The issue might reside in one of the parallel running tasks. Does your apps contain all history data and thereby increase in size for every day?

 

I would recommend  you to monitor your system resources while your tasks are running. You might need to increase ram and/or CPU.

Are you running on 64bit windows server? If so then you should consider to do an upgrade. The newer versions handle parallel triggered tasks better than QV 11.13 that is old and no longer supported by Qlik. 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Brett_Bleess
Employee
Employee

Leo, would need to see the actual failed task log in this case in order to provide any good theories, the script/document log may prove useful as well, and if there is no script/document log, that would indicated Vegar may be on the right track with things regarding the task never really launching things.  Both of the log snippets you attached show things ran successfully, so I am at a loss, but the timestamps of those logs do not seem to match the tasks that failed, just FYI.  Sorry I do not have something better here, but need the actual task logs from the failed entries etc. as noted above to provide something better.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.