Scheduled Task Fails Without Reason when Loaded Automatically

[dthornburg]

Hi,

  The scheduled tasks are failing when they are ran from the Task scheduler. The QVW's loads fine when I open it up with the desktop on the same server where Qlikview server is installed. There is not an error as to why the task failed. Any ideas what I have setup incorectly? This is a new install of Qlikview server on a Windows. Task log is below.

Thank You

4/20/2018 11:27:32.4967336 Information Starting task 'Spec_Tests.qvw'. Id:a726ea23-39c2-4581-9ea7-064a5b5ee227. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

4/20/2018 11:27:32.4967336 Information Entering Task Execution.

4/20/2018 11:27:32.4967336 Information ClusterID=1

4/20/2018 11:27:32.4967336 Information QDSID=6b52a980-aa17-24a2-7766-eeba037fb36e

4/20/2018 11:27:32.4967336 Information TaskID=a726ea23-39c2-4581-9ea7-064a5b5ee227

4/20/2018 11:27:32.4967336 Information MaxRunTime=06:00:00

4/20/2018 11:27:32.4967336 Information MachineName=APP01

4/20/2018 11:27:32.4967336 Information Max attempts:1

4/20/2018 11:27:32.4967336 Information Current Attempt=0

4/20/2018 11:27:32.4967336 Information Task Dependencies are OK

4/20/2018 11:27:32.5279430 Information Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

4/20/2018 11:27:32.5279430 Information Opening "C:\ProgramData\QlikTech\Documents\Spec_Tests.qvw"

4/20/2018 11:27:32.5279430 Information Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).

4/20/2018 11:27:32.5279430 Information Max retries:5

4/20/2018 11:27:32.5279430 Information Attempt:01

4/20/2018 11:27:33.9810713 Information Opened the QlikView Engine successfully. ProcessID=4284

4/20/2018 11:27:33.9810713 Information Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=15.

4/20/2018 11:27:33.9810713 Information Loading document "C:\ProgramData\QlikTech\Documents\Spec_Tests.qvw" (0.18 Mb)

4/20/2018 11:27:34.0591967 Information Physical FileSize=0.18 Mb. Memory Allocation Delta for this file=2.55 Mb. Available Physical Memory Before Open=9577.73 Mb. Available Physical Memory After Open=9573.92 Mb. Total Physical Memory=11999.55 Mb.

4/20/2018 11:27:34.0591967 Information Attempted to load the document without data.

4/20/2018 11:27:34.0591967 Information The document was loaded successfully.

4/20/2018 11:27:34.0591967 Information Document was opened successfully

4/20/2018 11:27:34.0591967 Information Starting reload

4/20/2018 11:27:34.0748236 Information QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

4/20/2018 11:27:34.0748236 Information The Source Document is being reloaded. DocumentPath=C:\ProgramData\QlikTech\Documents\Spec_Tests.qvw

4/20/2018 11:27:35.0748263 Information Reloading.

4/20/2018 11:27:35.3716997 Information The Source Document reload complete. DocumentPath=C:\ProgramData\QlikTech\Documents\Spec_Tests.qvw

4/20/2018 11:27:35.3716997 Information Memory Allocation Delta for this file=1.17 Mb. Available Physical Memory Before Reload=9573.89 Mb. Available Physical Memory After Reload=9563.95 Mb. Total Physical Memory=9563.95 Mb.

4/20/2018 11:27:35.4498287 Error The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Spec_Tests.qvw.

4/20/2018 11:27:35.4810773 Information Closing the document.

4/20/2018 11:27:36.1061172 Information Closed the QlikView Engine successfully. ProcessID=4284

4/20/2018 11:27:36.1061172 Error The task "Spec_Tests.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=C:\ProgramData\QlikTech\Documents\Spec_Tests.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)

4/20/2018 11:27:36.1061172 Information Task Execute Duration=00:00:03.6093836

4/20/2018 11:27:36.1061172 Information TaskResult.status=Finished

4/20/2018 11:27:36.1061172 Information Notifying all triggers of new state:FinishedWithErrors

4/20/2018 11:27:36.1061172 Information Notifying all triggers of new state:FinishedWithErrors - completed

4/20/2018 11:27:36.1217424 Information Saving Task Result

[felipedl · Accepted solution]

Hi,

The task log just shows if the task finished with error or not.

For specific errors, you'll need to check the document log file by checking the following:

Weird behaviour as you say it loads fine while reloading from desktop version.

Could you post the document log file?

Regards,

Felipe.

[Chip_Matejowsky]

Hi Dick,

From the task log you posted, we can see the below error:

4/20/2018 11:27:36.1061172 Error The task "Spec_Tests.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=C:\ProgramData\QlikTech\Documents\Spec_Tests.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)

So as Felipe posted, you need to ensure that Document logging is enabled Spec_Tests.qvw. Doing so will provide you with error logging for the failure. Like Felipe stated, if you can post the document log, or at least a snippet of the log showing what the failure is, we may be able to find the root cause.

If the successful run from QV Desktop is occurring from a separate computer than the server, the issue could be driver related.

Also, as the reload is successful if run from QV Desktop, but not when run from QVS/Publisher, a good test would be to logon to a computer using the same account which is running the QlikView Distribution Services account and run the reload from QV Desktop again. This test will show if the issue is permissions related.

Hope this helps,

Chip

[dthornburg]

Once I enabled the document logging there was a great deal more detail. The error ended up being I installed one of the database drivers from a network install. This was causing an issue with the reload engine. I installed the database driver locally and everything seems to be working fine now. Thanks.