4 Replies Latest reply: Jun 9, 2015 10:10 AM by Peter Cammaert RSS

    Scheduled tasks sometimes completed, but most of the time failed

    Charly Permadi


      Hi All,

       

      Attached files are log files from the same QVW file (ReportingSection), one failed (09 Jun 2015 2:08 PM) and one completed (09 Jun 2015 2:41 PM). Snapshot between these two log files in below:

       

      09 Jun 2015 2:08 PM --> failed

      2.08.jpg

       

      09 Jun 2015 2:41 PM --> completed

      2.40.jpg

       

      I have done the following:

      - restart server

      - restart all services

      - remove and put back the tasks

      - check the ODBC setup

       

      Additional information:

      - the following is related to the failed tasks, based on QMC --> Status --> Tasks --> Log:

       

      (2015-06-09 14:08:38) Information: The Source Document reload complete. DocumentPath=D:\DATA\PUBLISH\QVD_ReportingSection.qvw

      (2015-06-09 14:08:38) Information: Memory Allocation Delta for this file=327.34 Mb. Available Physical Memory Before Reload=15872.05 Mb. Available Physical Memory After Reload=15557.03 Mb. Total Physical Memory=15557.03 Mb.

      (2015-06-09 14:08:38) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\DATA\PUBLISH\QVD_ReportingSection.qvw.

      (2015-06-09 14:08:39) Information: Closing the document.

      (2015-06-09 14:08:39) Information: Closed the QlikView Engine successfully. ProcessID=3752

      (2015-06-09 14:08:39) Error: The task "Publish/QVD_ReportingSection.qvw" failed. Exception:

      (2015-06-09 14:08:39) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=D:\DATA\PUBLISH\QVD_ReportingSection.qvw.

      (2015-06-09 14:08:39) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

      (2015-06-09 14:08:39) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

      (2015-06-09 14:08:39) Error:    --- End of inner exception stack trace ---

      (2015-06-09 14:08:39) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

      (2015-06-09 14:08:39) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

      (2015-06-09 14:08:39) Error:    --- End of inner exception stack trace ---

      (2015-06-09 14:08:39) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

      (2015-06-09 14:08:39) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

       

      - the following is related to the completed tasks, based on QMC --> Status --> Tasks --> Log:

       

      (2015-06-09 14:41:22) Information: The Source Document reload complete. DocumentPath=D:\DATA\PUBLISH\QVD_ReportingSection.qvw

      (2015-06-09 14:41:22) Information: Memory Allocation Delta for this file=483.43 Mb. Available Physical Memory Before Reload=15855.52 Mb. Available Physical Memory After Reload=15380.64 Mb. Total Physical Memory=15380.64 Mb.

      (2015-06-09 14:41:22) Information: The Source Document was reloaded successfully.

      (2015-06-09 14:41:22) Information: Reload finished successfully

      (2015-06-09 14:41:22) Information: Start saving document

      (2015-06-09 14:41:30) Information: Check in document: D:\DATA\PUBLISH\QVD_ReportingSection.qvw

      (2015-06-09 14:41:30) Information: Closing the document.

      (2015-06-09 14:41:31) Information: Closed the QlikView Engine successfully. ProcessID=2340

      (2015-06-09 14:41:31) Information: No distribution required.

      (2015-06-09 14:41:31) Information: Task Execute Duration=00:00:50.4024570

      (2015-06-09 14:41:31) Information: The task "Publish/QVD_ReportingSection.qvw" finished successfully

      (2015-06-09 14:41:31) Information: TaskResult.status=Finished

      (2015-06-09 14:41:31) Information: Notifying all triggers of new state:Finished

      (2015-06-09 14:41:32) Information: Notifying all triggers of new state:Finished - completed

      (2015-06-09 14:41:32) Information: Saving Task Result

       

      Looking forward for your advise what need to be checked to solve the above error.

      Thank you in advance.

       

      Best regards,

      Charly