5 Replies Latest reply: Aug 29, 2011 4:31 AM by Miguel Angel Baeyens de Arce RSS

    Qlikview services not restarting

    Shubhasheesh Chakraverty

      Dear Community,

       

      In my scenario, We have Qlikview Small Business server QVS 10 SR1 on Windows server 2003 64 bit. We have hosted 8 documents on it.

      The problem started one month ago, when document reload getting failed again and again. Manually they were reloading, if we restart qlikview services and then reload the documents then they were reloading and again next morning scheduled jobs were failed.

       

      So we did 2 things, Wrote a batch file for restarting qlikview services using net stop and net start, and migrated scheduled jobs from qlikview server to windows scheduler.

       

      Again the batch file for restarting qlikview services failed.

       

      Any idea what can be the reasons. I have framed out some of the possible reasons.

       

      1. QVS 10 SR1 should be replaced with QVS 10 SR3.

      2. Some windows updates hindering it.

      3. In the first batch file for restarting qlikview services using net start / stop commands, using echo for logging errors is blocking the execution.

       

      Please suggest.

       

      Reg,

      Shubhu

        • Qlikview services not restarting
          Miguel Angel Baeyens de Arce

          Shubu,

           

          Updating to the latest version is always recommended, since they keep improving and debugging the software. Anyway, Are you running the 64 bit of QlikView Server or the 32 bit one? What happens if you click on the "play" button in the QEMC to reload? Are you creating log files (Settings menu, Document Properties, General, Generate Logfile) so you can see when the script stops or even if the reload starts?

           

          Since it's not working in the scheduled task in Windows I think of something related to the operating system, such as problems with the drivers you use to pull data from your database, IP addresses change or something.

           

          Did you check the Event Viewer (startup, run, eventvwr.msc) to see if those errors are being recorded in Windows?

           

          Hope that helps.

           

          Miguel Angel Baeyens

          BI Consultant

          Comex Grupo Ibérica

            • Qlikview services not restarting
              Shubhasheesh Chakraverty

              Miguel,

               

              I am using 64 bit of QVS.

              If Qlikview management console shows failed in tasks ( red ) and i click Play button it fails again.

              If i restart services from services.msc and click Play then it works.

               

              That's why i used two batch files, one for restarting qv services and second for reloading.

              First batch file for restarting qv services failed.

               

              Reg,

              Shubhu

                • Qlikview services not restarting
                  Miguel Angel Baeyens de Arce

                  Ok, so the restarting of services is what fails. Are you allowing (using PAUSE in your batch file) some time for each service to stop and then to start again or even killing the services should they don't respond to the "net stop"? Depending on how much memory are the services running, it can take longer to stop a service than to execute the next "net start" line.

                   

                  Apart from that, when services restart right, do the logs say anything regarding the reload? Are they performed fine?

                   

                  Regards.

                   

                  Miguel Angel Baeyens

                  BI Consultant

                  Comex Grupo Ibérica

                    • Qlikview services not restarting
                      Shubhasheesh Chakraverty

                      Miguel,

                      I am not batch file expert, so no pause in this just net stop "Qlikview Server" and net start "Qlikview Server".

                      Can you send me such a batch sample.

                       

                      Also QVS log shows successfull restart of qlikview server, then qlikview document start reloading and reload complete if server tasks used.

                       

                      Documents are very small, around 40 users accessing them ( not at same time ) and i never saw memory full or two much load on system.

                       

                      For last 1 year it was working and this is happening from last momth only.

                       

                      Reg,

                      Shubhu