Schedule Task failing.

[Rajiv-Dharia]

Hi All,

Please suggest, I have added a connection string as some of the Data source was moved in an application. Now application reload manually completes successfully but the related schedule task failing. Below is the log file for the task.

2023-02-02 12:34:21) Information: Starting task 'Occupation/Occupation programmed qvd maker 005 036 098.qvw'. Id:1301667d-003f-434d-a130-ba4433a9eb8c. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2023-02-02 12:34:21) Information: Entering Task Execution.

(2023-02-02 12:34:21) Information: ClusterID=1

(2023-02-02 12:34:21) Information: QDSID=cb05bcf5-5dc2-99a8-2003-2839aeff2b4e

(2023-02-02 12:34:21) Information: TaskID=1301667d-003f-434d-a130-ba4433a9eb8c

(2023-02-02 12:34:21) Information: MaxRunTime=06:00:00

(2023-02-02 12:34:21) Information: MachineName=SARWOLVM064

(2023-02-02 12:34:21) Information: Max attempts:1

(2023-02-02 12:34:21) Information: Current Attempt=0

(2023-02-02 12:34:21) Information: Task Dependencies are OK

(2023-02-02 12:34:21) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2023-02-02 12:34:21) Information: Opening "\\10.10.1.64\D$\QLIKVIEW DEV\OCCCUPATION\QVD MAKER\Occupation programmed qvd maker 005 036 098.qvw"

(2023-02-02 12:34:21) Information: Allocating new QlikView Engine. Current usage count=2 of 5 (of type non-reader).

(2023-02-02 12:34:21) Information: Max retries:5

(2023-02-02 12:34:21) Information: Attempt:01

(2023-02-02 12:34:23) Information: Opened the QlikView Engine successfully. ProcessID=19632

(2023-02-02 12:34:23) Information: Allocated QlikView Engine successfully. Current usage count=3 of 5 (of type non-reader). Ticket number=1036.

(2023-02-02 12:34:23) Information: Loading document "\\10.10.1.64\D$\QLIKVIEW DEV\OCCCUPATION\QVD MAKER\Occupation programmed qvd maker 005 036 098.qvw" (0.17 Mb)

(2023-02-02 12:34:23) Information: Physical FileSize=0.17 Mb. Memory Allocation Delta for this file=3.14 Mb. Available Physical Memory Before Open=225594.48 Mb. Available Physical Memory After Open=225708.26 Mb. Total Physical Memory=258047.43 Mb.

(2023-02-02 12:34:23) Information: Attempted to load the document without data.

(2023-02-02 12:34:23) Information: The document was loaded successfully.

(2023-02-02 12:34:23) Information: Document was opened successfully

(2023-02-02 12:34:23) Information: Starting reload

(2023-02-02 12:34:24) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

(2023-02-02 12:34:24) Information: The Source Document is being reloaded. DocumentPath=\\10.10.1.64\D$\QLIKVIEW DEV\OCCCUPATION\QVD MAKER\Occupation programmed qvd maker 005 036 098.qvw

(2023-02-02 12:34:24) Information: Waiting for the document log "\\10.10.1.64\D$\QLIKVIEW DEV\OCCCUPATION\QVD MAKER\Occupation programmed qvd maker 005 036 098.qvw" to become available.. Check until 2/02/2023 12:34:54

(2023-02-02 12:34:24) Information: Found a document log. FileName=\\10.10.1.64\D$\QLIKVIEW DEV\OCCCUPATION\QVD MAKER\Occupation programmed qvd maker 005 036 098.qvw.log

(2023-02-02 12:34:24) Information: Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20230202\123421 - Occupation_Occupation programmed qvd maker 005 036 098.qvw\DocumentLog.txt

(2023-02-02 12:34:24) Information: Reloading.

(2023-02-02 12:34:25) Information: Reloading..

(2023-02-02 12:34:26) Information: Reloading...

(2023-02-02 12:34:27) Information: Reloading....

(2023-02-02 12:34:28) Information: Reloading.....

(2023-02-02 12:34:29) Information: Reloading......

(2023-02-02 12:34:30) Information: Reloading.......

(2023-02-02 12:34:31) Information: Reloading........

(2023-02-02 12:34:32) Information: Reloading.........

(2023-02-02 12:34:33) Information: Reloading..........

(2023-02-02 12:34:34) Information: Slow down logging. Log every <2> seconds.

(2023-02-02 12:34:34) Information: Reloading

(2023-02-02 12:34:36) Information: Reloading.

(2023-02-02 12:34:38) Information: Reloading..

(2023-02-02 12:34:40) Information: Reloading...

(2023-02-02 12:34:42) Information: Reloading....

(2023-02-02 12:34:44) Information: Reloading.....

(2023-02-02 12:34:46) Information: Reloading......

(2023-02-02 12:34:48) Information: Reloading.......

(2023-02-02 12:34:50) Information: Reloading........

(2023-02-02 12:34:52) Information: Reloading.........

(2023-02-02 12:34:54) Information: Reloading..........

(2023-02-02 12:34:56) Information: Slow down logging. Log every <10> seconds.

(2023-02-02 12:34:56) Information: Reloading

(2023-02-02 12:35:07) Information: Reloading.

(2023-02-02 12:35:17) Information: Reloading..

(2023-02-02 12:35:20) Information: The Source Document reload complete. DocumentPath=\\10.10.1.64\D$\QLIKVIEW DEV\OCCCUPATION\QVD MAKER\Occupation programmed qvd maker 005 036 098.qvw

(2023-02-02 12:35:20) Information: Memory Allocation Delta for this file=64.88 Mb. Available Physical Memory Before Reload=225735.42 Mb. Available Physical Memory After Reload=225501.44 Mb. Total Physical Memory=225501.44 Mb.

(2023-02-02 12:35:21) Error: The Source Document was NOT reloaded successfully. DocumentPath=\\10.10.1.64\D$\QLIKVIEW DEV\OCCCUPATION\QVD MAKER\Occupation programmed qvd maker 005 036 098.qvw.

(2023-02-02 12:35:21) Information: Closing the document.

(2023-02-02 12:35:22) Information: Closed the QlikView Engine successfully. ProcessID=19632

(2023-02-02 12:35:22) Error: The task "Occupation/Occupation programmed qvd maker 005 036 098.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=\\10.10.1.64\D$\QLIKVIEW DEV\OCCCUPATION\QVD MAKER\Occupation programmed qvd maker 005 036 098.qvw.  ||    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult) ||    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-02-02 12:35:22) Information: Task Execute Duration=00:01:01.1411213

(2023-02-02 12:35:22) Information: Sending Alert mail

(2023-02-02 12:35:25) Information: TaskResult.status=Finished

(2023-02-02 12:35:25) Information: Notifying all triggers of new state:FinishedWithErrors

(2023-02-02 12:35:25) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2023-02-02 12:35:25) Information: Saving Task Result

[Chip_Matejowsky · Accepted solution]

Hello @Rajiv-Dharia,

Since the reload task failed with error The Source Document was NOT reloaded successfully, you'll need to review the document log of the QVW file associated with the reload task for more information. Start by reviewing the Qlik Knowledgebase article The Source Document was NOT reloaded successfully. If you have questions about the error encountered in the document log, post the log to this thread.

Best Regards

[Albert_Candelario]

Hello @Rajiv-Dharia ,

Could somehow be related to section access as per the part of the error:(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword

But as @Chip_Matejowsky  said, the best move would be checking the Document log of the task.

Cheers,

Albert