20 Replies Latest reply: May 15, 2017 2:13 AM by Anjali Ahlawat RSS

    Qlikview task in QMC seems running forever

    Sk Sakir Ali

      Hi All,

       

      I am experiencing a strange issue from last few days, a task in QMC seems running forever, usually it takes 3mins to run but currently its running for last 3days, have tried to stop the task manually but it didn't  work. Have restarted management services and distribution services still no luck. Finally had to restart the server still the task is running. Is this some kind of a bug in qlikview??? Is there any way to stop this task??? Has any one of you faced this kind issue???

       

      Product Details:

      QlikViewServer 64-bit Edition (x64)

      Version 11.0.11440.0

       

      Please give your valuable suggestion.

       

      Regards,

      Sakir

        • Re: Qlikview task in QMC seems running forever
          Friedrich Hofmann

          Hi Sakir,

           

          we had this issue several times, unfortunately. It seems to be a bug in QlikView.- not the only one ...

          - An important thing is: Is the log file still growing or has that stopped - if it's the latter, I assume that your task isn't  
             actually running, only the icon in QMC is "frozen" - happens ... I still have a frozen "Reload NOW"-icon (the reload
              was done and finished more than a week ago)

          - Usually, however, restarting the QV_Distribution_service should help. If not, I'm at my wits'  end ...

           

          Sorry I can't help any more.

           

          Best regards,

           

          DataNibbler

            • Re: Qlikview task in QMC seems running forever
              Sk Sakir Ali

              Thanks man for quick reply.


              The log file has stopped growing. The task appears to be running is not actually running, had it been running then the server restart would have stopped the task. Right now my only concern is to stop the task.

               

              Any idea about how to fix the "frozen" icon issue in qmc ?

               

              Regards

                • Re: Qlikview task in QMC seems running forever
                  Friedrich Hofmann

                  Hi Sakir,

                   

                  well, IS your task actually still running?

                  => For me, when I right-click on the icon in QMC, it says "cannot find task" - so I assume it isn't in my instance.

                  As for that "frozen icon" issue, I have no idea whatsoever.

                  - I would try deleting - or temporarily moving - the qvw, then it should disappear as QMC cannot find it anymore - but
                     at the moment I cannot do that as I still need the work done in that qvw.

                  - Have you tried deactivating the reload_schedule? Again, I cannot do that since the qvw in question is a
                     working_copy and not scheduled for reload to begin with, I did it manually ...

              • Re: Qlikview task in QMC seems running forever
                Dave Riley

                Try this and see if it fixes it ...

                 

                1)     Disable the Reload Schedule for the document under Documents > Reload (remember to click apply), then stop the job under Status > Tasks.

                2)     Stop/start the Qlikview services (might just need to stop/start Distribution Service).

                3)     Re-enable the Reload Schedule for the document.

                 

                flipside

                  • Re: Qlikview task in QMC seems running forever
                    Sk Sakir Ali

                    Thanks your reply.

                    This is not solving the problem. After re-enabling, the task again starts running .

                      • Re: Qlikview task in QMC seems running forever
                        Paul Routledge

                        We encountered something similar but it was about 3 years ago and I can't remember the full details. But this is the best I can recall.

                         

                        Check in the distribution service log area normally

                             C:\ProgramData\QlikTech\DistributionService\1\temp

                         

                        Stop all Qlikview Services on the server and if there is still an XML file in the above directory then that may be the cause of your problem. Delete the files in this temp directory and start the services back up again.

                         

                        When the Distribution Service starts up again it will continue with any tasks described by the xml files it finds in this temp directory.

                          • Re: Qlikview task in QMC seems running forever
                            Sk Sakir Ali

                            Hi Paul,

                             

                            The temp folder in the above mentioned path is empty. Can there be any other location for this temp files???

                             

                            Have raised this issue with qlik. Will keep you  posted.

                             

                            Regards,

                            Sakir

                              • Re: Qlikview task in QMC seems running forever
                                Dave Riley

                                Just checking, but do you have the document log enabled on this document, and if so, is the last line 'Execution finished'?

                                  • Re: Qlikview task in QMC seems running forever
                                    Sk Sakir Ali

                                    Document log is enabled. But the log has been overwritten since its a live server we had to re-run the task manually after a certain period of time. So cannot share the log.

                                     

                                    As far as I remember execution did not get finish. It stuck somewhere in the load statement.

                                      • Re: Qlikview task in QMC seems running forever
                                        Paul Routledge


                                        Consider adding a timestamp to your log file, this way every execution of the task will create a separate log file and you can always look back at the history.

                                         

                                        This is set on a document by document basis. In designer got to Settings/General and enable Timestamp In Logfile Name.

                                         

                                        You will then have to manage those log files as they accumualte, zip and archive or delete after n days. But we have found having this history available is really useful, the actual log file created by the QVW sometimes has extra final entries you don't get to see in QMC mined from the Distribution Service xml files.

                                          • Re: Qlikview task in QMC seems running forever
                                            Dave Riley

                                            I'm not sure if this is due to my server configuration, as I set it up a long time ago, but on your server if you go to ...

                                             

                                            C:\ProgramData\QlikTech\DistributionService\1\Log (where the drive and folder 1 might be different) ...

                                             

                                            you may see folders for each day in the format 'YYYYMMDD'. Within these folders are subfolders for time and tasks in the format 'HHMMSS - {mounted folder}_{name of qvw}.qvw' and these folders contain the document log for each task run. So you may be able to go 'back in time' and look at them if you know when the failure was.

                                             

                                             

                                            flipside

                              • Re: Qlikview task in QMC seems running forever
                                Sk Sakir Ali

                                For the time being we came up with a solution.

                                 

                                Solution is to remove and then create a new task. I dont know whether its advisable or not.

                                 

                                Please share your views.

                                  • Re: Qlikview task in QMC seems running forever
                                    Dave Riley

                                    Your earlier reply where you said the task hadn't completed suggests there's a problem in your document load script, rather than the task itself - I'd be surprised if it didn't re-occur. It could be something like an ODBC or OLEDB connection being locked out or something similar. Have a look at my reply to Paul Routledge to see if you can get to your earlier document logs where the task failed.

                                     

                                    flipside

                                     


                                    • Re: Qlikview task in QMC seems running forever
                                      Nizam HM

                                      it wont take three days to load the task and all first thing

                                      main thing u have scheduled a task before in qmc after some days u might have chnged the file name and removed a file from the location so what qmc shows is that task is keep on running ..closely look at the file file and check in the path file wont be present there .for this problem .change a file name and scheduled the task again .and if u want to remove the running old task mean in status u have option called disable .disable the task it wont show the old running task for 3 days i hope it helps

                                    • Re: Qlikview task in QMC seems running forever
                                      Erik Gustafsson

                                      The version you are running is quite an old one. I would recommend you to upgrade and see if the situation improves, considering there have been lots of improvements in the product since. Might be some corruption in the QVPR that causes this.

                                      What is the QDS log files saying?

                                      If the issue persists after an upgrade, you might want to file a support case with QV Support.

                                      • Re: Qlikview task in QMC seems running forever
                                        Simen Kind Gulbrandsen

                                        Hi, Sakir.

                                         

                                        I don't know if you have found a  solution to your problem, but we faced a very similary problem with a task stuck at "running" after reset of the server to a previous snapshot.

                                         

                                        Anyways, the solution I found was to delete the corresponding file in the C:\ProgramData\QlikTech\DistributionService\TaskResults\ folder or the custom folder for det QDS log files.

                                         

                                        The file should be named something like: TaskResult_e6bcba42-95e4-4406-86e1-ac7caf4cb8ef.xml.

                                         

                                        It should have a modified date similar to the "last execution" column for the freezed task.

                                         

                                        Removing this file and restarting the service fixed everything for us.

                                         

                                         

                                        Regards

                                         

                                        Simen Kind Gulbrandsen

                                        • Re: Qlikview task in QMC seems running forever
                                          Anjali Ahlawat

                                          Hi Sakir,

                                           

                                          Even I am facing similar problem and because of one task running forever,other tasks are still in waiting state.

                                           

                                          Could you please tell what all files I need to delete as there are many files in that folder?

                                           

                                          Thanks.