13 Replies Latest reply: Sep 2, 2013 6:25 AM by Dicky Mohanty RSS

    Some tasks hangings

      Hello,

       

      I have a significant issue at the moment with a number of Qlikview tasks that are hanging in the middle of a reload and not completing. Since 1:00am this morning we should have had about 100 tasks reloaded (some of the tasks reload every hour, while some are just one offs) and because some of the tasks are hanging it has resulted in about 70 of the tasks failing to complete. Nothing has changed from a Qlikview point of view (I'm not sure whether other issues could affect this) and these jobs have been running for years now with no problems.

       

      - The tasks that seem to be the problem do an incremental load (although not all incremental loads are failing)

      - We use QV 10 SR3 and have a cluster environment

      - I don't think it is an issue with Publisher as I've manually run through the development application and same thing exists

      - Publisher server has been restarted and have had no effect at all.

       

      If anyone has ever encountered a situation like this please let me know!

       

      Thanks in advance,


      Ralph

        • Re: Some tasks hangings
          Rajesh Vaswani

          Hi Ralph,

           

          Any very recent changes in the data sources?

           

          thanks,

          Rajesh Vaswani

            • Re: Some tasks hangings

              Not that I'm aware of, and some of the jobs that have failed bear no relation to each other (i.e. they don't go near the same data set). It seems to be an issue on files that are doing incremental loads and concatenating onto 4M+ rows.

               

              Thanks,

               

              Ralph

            • Re: Some tasks hangings
              Rajesh Vaswani

              Any new software installations on that server by another team? Could you check the windows eventviewer as to what happened in the recent? What do the QlikView server logs say on failure?

               

              Any new windows hot fix hit the server?

               

              thanks,

              Rajesh Vaswani

              • Re: Some tasks hangings
                Michael Solomovich

                Ralph,

                 

                I had something similar recently. Publisher usually executes reload in 30 min, and distributes (copies to another machine) in two or three additional minutes.  In one case last week, the distribution portion took more than 30 min, although the reload took the expected time.

                I don't know what's the reason.  Worked fine before and after.  Maybe some network issue (?)

                 

                Regards,

                Michael

                • Re: Some tasks hangings
                  dhiraj kumar

                  Hi Graham,

                   

                  Qlikview task hanging is a know issue and I think the case is already raised for the same. Meanwhile can you let me know  the "Chunk size" value in the config file.

                  C:\Program Files\QlikView\Management Service\QVManagementService.exe.config

                   

                      <add key="QMSChunkSize" value="100"/>

                  If the value is 100 then please change it to 20.

                   

                  Thanks,

                  D J

                  • Re: Some tasks hangings

                    I've managed to identify the reason why the jobs were hanging:

                     

                    • There was an issue on the server (this is something that I'm not clear of yet but essentially is the root of everything) and a couple of tasks that were running basically corrupted the qvds that they were being stored to (looks like they were only partially saved as the usual file size 2GB but it was just 650MB this time). As these qvds were used elsewhere it caused an adverse effect on other jobs which caused the rebuilds to hang
                    • Another thing that has happened since the 1am server problem on Saturday morning is that a qvd that usually gets overwritten (again around 2GB) is failing on the store. I removed the qvd that it was overwriting and it worked fine but seems to fail if the qvd already exists

                     

                    Any ideas why the store would fail?

                     

                    Thanks,

                     

                    Ralph