6 Replies Latest reply: Sep 16, 2015 7:27 AM by Ali Azizi RSS

    Reload task fails

    Ali Azizi

      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-c24d53745e0b.xml) 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

        • Re: Reload task fails
          Avinash R

          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

            • Re: Reload task fails
              Ali Azizi

              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

            • Re: Reload task fails
              Jonathan Dienst

              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.

              • Re: Reload task fails
                Magnus Lovsten

                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

                  • Re: Reload task fails
                    Ali Azizi

                    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