Reload task fails

[AliAzizi]

Hi guys

Our customer is using "Performance Monitor" application. A task created to refresh the app 4 times a day. But we have experienced that this task in some cases fails. The following can be seen in the document and task logfiles:

From document log:
0794    FROM C:\ProgramData\QlikTech\DistributionService\TaskResults\TaskResult_*.xml (XmlSimple, Table is [Root])
Error: XML document must have a top level element.
On line number: 0. On column number: 0. System ID: file:///C:/ProgramData/QlikTech/DistributionService/TaskResults/TaskResult_bcafecfc-6f7f-4407-89f7-c24d53745e0b.xml.
General Script Error
Execution Failed
Execution finished.

Fom task log:
9/11/2015 14:46:27.5801995 Information The Source Document reload complete. DocumentPath=\\<server path>\Qlikview Apps\Master\Performance Monitor.qvw
9/11/2015 14:46:27.5801995 Information Memory Allocation Delta for this file=132.68 Mb. Available Physical Memory Before Reload=19433.75 Mb. Available Physical Memory After Reload=19288.43 Mb. Total Physical Memory=19288.43 Mb.
9/11/2015 14:46:37.5334461 Information Reloading....
9/11/2015 14:46:38.2666790 Error The Source Document was NOT reloaded successfully. DocumentPath=\\<server path>\Qlikview Apps\Master\Performance Monitor.qvw.
9/11/2015 14:46:58.6723946 Information Closing the document.
9/11/2015 14:46:59.2964226 Information Closed the QlikView Engine successfully. ProcessID=9576
9/11/2015 14:46:59.3900268 Error The task "Performance Monitor" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed --->
QDSMain.Exceptions.ThreadPoolJobStillRunningException: Aborting reload. Error: QDSMain.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)
9/11/2015 14:46:59.3900268 Information Task Execute Duration=00:06:52.1704940
9/11/2015 14:46:59.3900268 Information Sending Alert mail
9/11/2015 14:46:59.8892492 Information TaskResult.status=Finished
9/11/2015 14:46:59.9204506 Information Notifying all triggers of new state:FinishedWithErrors
9/11/2015 14:46:59.9204506 Information Notifying all triggers of new state:FinishedWithErrors - completed
9/11/2015 14:46:59.9360513 Information Saving Task Result

The mentioned XML file (file:///C:/ProgramData/QlikTech/DistributionService/TaskResults/TaskResult_bcafecfc-6f7f-4407-89f7-c...) is empty. When I delete this file, the reload task is again able to run!

Do you know why this error occurs and what is it related to (due to)?

Appriciate your reply

[avinashelite]

can you please share the actual log file? can find this in the document folder with the extension .log

Their we cannot predict the exact reason for the failure.

1.Check the connection once, username and passwords are active.

2.Check whether the Qlikview service account has full access for the document

3.Check for the script  errors

[jonathandienst]

Is the XML file updated during the day as well? Perhaps the reload is happening while another process is copying or creating the XML file so it is attempting to open a partially complete file.

[AliAzizi]

Hi Avinash

Thank you for your reply. The Logfiles are enclosed here. The same Logfiles are created every time the task failed.

Regarding your comments:

- Connection is ok. It’s the only task that fails when at the same time other tasks are running (with the same user ID and password).

- The same answer regardin “Qlikview service account” as I mentioned above. It’s ok.

- Regarding the script error I’m not sure whether there is a script error in the application, but if there is an error, so should it not fail every time?

Best regards

Ali

[AliAzizi]

Hi Jonathan

No, it’s not. E.g. the last time the XML file was updated was on Sep. 11th at 06:36. Afterwards all reload tasks failed until today, where I deleted the concerned XML file.

Best regards

Ali

[#6 · Accepted solution]

Hi

There was a bugfix released in QV11.20 SR11 that fixes a problem with empty TaskResult files.(#65972 see release notes here: QlikView 11.20 Service Release 11 now available

[AliAzizi]

Hi Magnus

As I can see in the release note it is about the disabled tasks with an active trigger:

".xml of 0kb gets created in the taskresult folder when task is disabled but has an active

trigger"

but in my case the task is not disabled, but is running 4 times a day. I don't know, maybe the new QlikView version can also resolve my problem.

Thank you for your reply