13 Replies Latest reply: Oct 7, 2015 3:21 PM by Bill Britt RSS

    Server Speed Slow

    Kevin Brown

      Our QlikView server installation performance is poor and would like to know of any quick wins to speed it up

       

      What is the best way to approach the analysis? Is there a set process of deduction that i could use to diagnose any problems? Is there anything specific to look for in the log files?

       

      The QlikView documents are held on a distribution server (QlikView03) which is separate from the from the main QlikView server (QlikView).  I have spent most of the day taking calls from people who are concerned that there dashboards have not been refreshed.

       

      We have 33 dashboards that are refreshed daily (ie 24 hours behind) at specific times and 11 that are refreshed though out the day at intervals ranging from 5 to 360 minutes. This issue does not seem to be consistent on some days it works without needing a restart. Today was exceptional I restarted the service on QlikView03 several times and not all dashboards have been refreshed today.

       

      Any help would be greatly appreciated

       

      Kev

        • Re: Server Speed Slow
          Marcus Sommer

          If I understand you right then worked this system - distribution server (QlikView03) - on some days and on other days it don't worked, right? This excludes that the essential things from the installing to the run of this system is complete wrong and that this issue is temporary.

           

          The reasons for this could be that network- and/or database-connections are slow or instable (timeouts or task-hanging could be follow as well as then further tasks are starting which block each other or ...) or that further processes run then to this time (indexing, windows shadow copies, group policy tasks and many other more).

           

          I suggest that you check and compare the windows event log and the qlikview logging and to have a look on the RAM workload on this server (maybe the working set settings within the qmc needs to be adjusted) then when qlikview swapped data into the virtual RAM it will be very slow.

           

          - Marcus

          • Re: Server Speed Slow
            Bill Markham

            Kevin

             

            In the QMC can you if your Tasks are succeeding, failing and any other useful info ?

              • Re: Server Speed Slow
                Kevin Brown

                I can ask for the logs if it would be usefulRSCH-QlikView_Coding_Completness.jpg

                  • Re: Server Speed Slow
                    Bill Markham

                    If you click on the blue underlined timestamp to the left of where the Status is failed it should bring up the log for that task.

                     

                    Could you copy / paste one of them in here ?

                      • Re: Server Speed Slow
                        Kevin Brown

                        The task "Reload and Distribute of Information Services\Medical_Records.qvw" failed. Part of the log file follows:

                         

                        07/10/2015 15:12:39 Error   The Source Document was NOT reloaded successfully. DocumentPath=\\RSCH-QLIKVIEW03\SourceDocuments\Information Services\Medical_Records.qvw.

                        07/10/2015 15:12:40 Error   The task "Reload and Distribute of Information Services\Medical_Records.qvw" failed. Exception:

                        1. QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=\\RSCH-QLIKVIEW03\SourceDocuments\Information Services\Medical_Records.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)

                          • Re: Server Speed Slow
                            Bill Markham

                            Kevin, 

                             

                            Do look at Marcus idea re too many parallel tasks.

                             

                            Also the Task Log points to the qvw reload log, could you get hold of that and share it.

                              • Re: Server Speed Slow
                                Kevin Brown

                                ok I'll take a look, thanks. Not able to get hold of another log other than one that was downloaded earlier

                                 

                                07/10/2015 15:05:56 Error   Document open threw an exception. Exception=The currently executing operation was aborted.

                                07/10/2015 15:05:57 Error   The task "Reload and Distribute of Information Services\AE_KPIs" failed. Exception:

                                1. QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> 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.DistributeTask.OpenDocument(TaskResult taskResult, String fileName)

                                   at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

                                   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)

                                07/10/2015 15:05:57 Error   Task failed with exception

                                07/10/2015 15:05:57 Error   Exception=The currently executing operation was aborted.

                              • Re: Server Speed Slow
                                Bill Britt

                                Hi Kevin,

                                 

                                How many reload engines do you have set? If you have more than 9 you will need to increase the Desktop Heap setting.

                                 

                                Bill

                            • Re: Server Speed Slow
                              Marcus Sommer

                              If I look on this screenshot it reminds me on my case with too many parallel tasks respectively a too long waiting-time (45 min 1 sec), see: Server-Task delaying

                               

                              - Marcus