5 Replies Latest reply: Feb 26, 2015 3:00 AM by andre potgieter RSS

    Auto reload : Tasks automation

      Dear all,

        I feel sure that this question has been asked before but I could not find it, about one month ago my qlikview documents do not reload automatically anymore. attached qlikview server performance and see below the logs :


      (2014-11-27 08:58:49) Information: Starting task 'QV NAV Sales.Qvw'. Id:887fda15-58c8-4b77-954f-f1a5b37a22ac. Triggered by 'ScheduleTrigger'. Id:c20096bd-ba1a-4423-820d-d0e373c6cc15

      (2014-11-27 08:58:49) Information: Entering Task Execution.

      (2014-11-27 08:58:49) Information: ClusterID=1

      (2014-11-27 08:58:49) Information: QDSID=eacac4cc-f35e-74a3-1a25-83977d14ab60

      (2014-11-27 08:58:49) Information: TaskID=887fda15-58c8-4b77-954f-f1a5b37a22ac

      (2014-11-27 08:58:49) Information: MaxRunTime=06:00:00

      (2014-11-27 08:58:49) Information: MachineName=FMO15G

      (2014-11-27 08:58:49) Information: Max attempts:1

      (2014-11-27 08:58:49) Information: Current Attempt=0

      (2014-11-27 08:58:49) Information: Task Dependencies are OK

      (2014-11-27 08:58:49) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

      (2014-11-27 08:58:49) Information: Opening "D:\QV_NAV\APPLICATION\QV NAV Sales.Qvw"

      (2014-11-27 08:58:49) Information: Allocating new QlikView Engine. Current usage count=1 of 2 (of type non-reader).

      (2014-11-27 08:58:49) Information: Max retries:5

      (2014-11-27 08:58:49) Information: Attempt:01

      (2014-11-27 08:58:50) Information: Allocated QlikView Engine successfully. Current usage count=2 of 2 (of type non-reader). Ticket number=6.

      (2014-11-27 08:58:50) Information: Loading document "D:\QV_NAV\APPLICATION\QV NAV Sales.Qvw" (15.83 Mb)

      (2014-11-27 08:58:51) Information: Loading. LoadTime=00:00:01.0001000

      (2014-11-27 08:58:53) Information: Loading. LoadTime=00:00:03.0003000

      (2014-11-27 08:58:57) Information: Loading. LoadTime=00:00:07.0007000

      (2014-11-27 08:59:05) Information: Loading. LoadTime=00:00:15.0095008

                           ............... .  .   .    ...etc

       

      Thanks in advance for your help.

        • Re: Auto reload : Tasks automation
          Peter Cammaert

          Your log dump stops before it gets interesting.

           

          Put your distribution service logging in very-verbose mode, reload your documents and post the log file instead. Thanks.

           

          Peter

            • Re: Auto reload : Tasks automation

              Thanks for your reply Peter, can you explain more please (Put your distribution service logging in very-verbose mode ??).

                • Re: Auto reload : Tasks automation

                   

                  Good Day

                   

                   

                   

                  I have the same problem.

                   

                   

                   

                  We even uninstalled qlikview, removed all Folders, removed registry keys, removed IIS and installed everything from scratch.

                   

                  The task just keep incrementing with “Information: Loading. LoadTime

                   

                   

                   

                  Setup the same scenario in a VM, uninstalled, removed folders, iis – and reinstall. And Tasks works.

                   

                   

                   

                  If the file is manually opened on the Server with Qlikview Desktop it reloads 100% fine from Excel files or SQL Servers.

                   

                   

                   

                  If the task is then scheduled, it never ends nor bombs out with an error – just constantly “Loading”

                   

              • Re: Auto reload : Tasks automation

                He's saying to open up QEMC and under System>QlikView Servers>Select the server>Logging>Event log verbosity, set it to "High".

                After that, try reloading a document and check out/attach the logs for that document.

                  • Re: Auto reload : Tasks automation

                    Good Day

                     

                    Thanks for the response.

                     

                    The Task below runs for  6-9 sec on my LAB with 10x less resources, and loads from Excel files.

                     

                    On the Server it runs for more then 8h, until you manually cancel it.

                    if you cancel it, the log just increment saying "Loading..." till cancelled.

                     

                    I had to set the maximum run time down to be able to get additional information in the log.

                     

                    Please take note the Server Name and Client Name in the Log was changed to "Server" and "Client" before posting in here.

                     

                    PS: The Server had the Problem on Qlikview 11 SR4, and in the LAB on SR4 it worked in 6-9 sec.

                     

                    Qlikview on the Server and LAB was uninstalled, Folders Removed, Registry keys removed and reinstalled with Qlikview 11 SR10.

                     

                    On the Server it still does the same, and on the LAB it still works.

                     

                     

                    2/25/2015 12:35:57.5896591 Information Starting task 'Client/Client.qvw'. Id:66f8eab1-ab1b-4963-96f1-b4d73ea65038. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c
                    2/25/2015 12:35:57.6365380 Information Entering Task Execution.
                    2/25/2015 12:35:57.6365380 Information ClusterID=1
                    2/25/2015 12:35:57.6365380 Information QDSID=948b171f-c5fb-fc2e-20f2-bf19922226fe
                    2/25/2015 12:35:57.6365380 Information TaskID=66f8eab1-ab1b-4963-96f1-b4d73ea65038
                    2/25/2015 12:35:57.6365380 Information MaxRunTime=00:06:00
                    2/25/2015 12:35:57.6365380 Information MachineName=Server
                    2/25/2015 12:35:57.6521643 Information Max attempts:1
                    2/25/2015 12:35:57.6521643 Information Current Attempt=0
                    2/25/2015 12:35:57.6521643 Information Task Dependencies are OK
                    2/25/2015 12:35:57.8396799 Information Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
                    2/25/2015 12:35:57.8553062 Information Opening "D:\Qlikview\QVDeploy\Client\Client.qvw"
                    2/25/2015 12:35:57.8865588 Information Allocating new QlikView Engine. Current usage count=0 of 6 (of type non-reader).
                    2/25/2015 12:35:57.8865588 Information Max retries:5
                    2/25/2015 12:35:57.8865588 Information Attempt:01
                    2/25/2015 12:35:59.4491888 Information Opened the QlikView Engine successfully. ProcessID=6952
                    2/25/2015 12:35:59.4491888 Information Allocated QlikView Engine successfully. Current usage count=1 of 6 (of type non-reader). Ticket number=1.
                    2/25/2015 12:35:59.4804414 Information Loading document "D:\Qlikview\QVDeploy\Client\Client.qvw" (15.18 Mb)
                    2/25/2015 12:36:00.4492720 Information Loading. LoadTime=00:00:01.0000832
                    2/25/2015 12:36:02.4494384 Information Loading. LoadTime=00:00:03.0002496
                    2/25/2015 12:36:06.4497712 Information Loading. LoadTime=00:00:07.0005824
                    2/25/2015 12:36:14.4504368 Information Loading. LoadTime=00:00:15.0012480
                    2/25/2015 12:36:30.4673943 Information Loading. LoadTime=00:00:31.0182055
                    2/25/2015 12:37:02.5950671 Information Loading. LoadTime=00:01:03.1458783
                    2/25/2015 12:38:02.6156854 Information Loading. LoadTime=00:02:03.1664966
                    2/25/2015 12:39:02.6519300 Information Loading. LoadTime=00:03:03.2027412
                    2/25/2015 12:40:03.1100847 Information Loading. LoadTime=00:04:03.6608959
                    2/25/2015 12:41:03.1150767 Information Loading. LoadTime=00:05:03.6658879
                    2/25/2015 12:42:08.1517373 Error Document open threw an exception. Exception=The currently executing operation was aborted.
                    2/25/2015 12:42:08.4642633 Information Load was aborted
                    2/25/2015 12:42:08.4642633 Information Closed the QlikView Engine successfully. ProcessID=6952
                    2/25/2015 12:42:08.4642633 Information Attempted to load the document without data.
                    2/25/2015 12:42:08.4798896 Error The document failed to open.
                    2/25/2015 12:42:08.4798896 Information Closed the QlikView Engine successfully. ProcessID=6952
                    2/25/2015 12:42:08.7924156 Information Closed the QlikView Engine successfully. ProcessID=6952
                    2/25/2015 12:42:08.7924156 Information Failed to check in document: D:\Qlikview\QVDeploy\Client\Client.qvw
                    2/25/2015 12:42:08.8236682 Error The task "Client/Client.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted. ||    at QVBWrapper.DocumentPool.Checkout(ILogBucket logBucket, eCheckoutMode checkoutMode, String fileName, Boolean clearAll, Boolean clearLocks, Boolean clearOneAndOnlyOnes, Boolean reduce, String variableName, String variableValue, AbortCallbackCheck abortCallbackCheck, String sectionAccessUsername, String sectionAccessPassword, DocumentRestoreMode documentRestoreMode, Boolean withData, Boolean forceQvbAllocation) ||    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)
                    2/25/2015 12:42:08.8392945 Error Task failed with exception
                    2/25/2015 12:42:08.8392945 Error Exception=The currently executing operation was aborted.
                    2/25/2015 12:42:08.8549208 Information TaskResult.status=Finished
                    2/25/2015 12:42:08.8705471 Information Notifying all triggers of new state:FinishedWithErrors
                    2/25/2015 12:42:08.8861734 Information Notifying all triggers of new state:FinishedWithErrors - completed
                    2/25/2015 12:42:08.9017997 Information Saving Task Result