22 Replies Latest reply: Dec 16, 2014 2:16 AM by Friedrich Hofmann RSS

    QlikViewServer - how to track it over Christmas

    Friedrich Hofmann

      Hi,

       

      we have a very current problem here:

      Probably because of our version of QlikViewServer - we don't know for sure - it repeatedly stops altogether - no more reloads are executed until we restart it all. A ticket with QlikTech is open because of this, but I guess we'll just have to upgrade to the newest version.

      The issue is, that won't be done until we have a cconsultant on site which in turn won't happen before the end of January.

      Now the Christmas holidays are approaching and the two of us - we only have two QlikView_developers - are out for a while.

      Moreover, when the QlikView_Server stops altogether, the emails sent by the QMC about reload_failures are not triggered, so unless someone actually looks at the QMC, nobody will notice.

      I think we'll have to insert someone else into the group of "QlikView_administrators" so that he will be able to look at the QMC.

       

      Does anyone know another way we could do that?

       

      Thanks a lot!

      Best regards,

       

      DataNibbler

        • Re: QlikViewServer - how to track it over Christmas
          Rob Cleek

          It's not the greatest solution in the world, but you could just have a job set up with alerting enabled in the application to email you every hour.  If you stop getting that email, you could assume your server has stopped working.

            • Re: QlikViewServer - how to track it over Christmas
              Peter Rieper

              You may watch the server via remote control,

              else create a batch to restart the server at regular intervals (triggered by WINDOWS-scheduler).

              This might ensure, that even without watching, the server might get restarted once a day (or each 12 hours), thus you may loose not that much production-time ...

               

              we use a script like fllws:

              :*******************************************************************************************
              :******
              :***Start/Stop the QlikView-Server***
              :***in order to free memory / supposed to run daily at midnight***
              :******
              : *** added stopping of all services (recommended by QlikTech 20140506                    ***
              :*******************************************************************************************

               

               

              :SET CalDirectory= "C:\ProgramData\QlikTech\QlikViewServer\"
              SET UserCal= "C:\ProgramData\QlikTech\QlikViewServer\CalData.pgo"
              SET BorrCal= "C:\ProgramData\QlikTech\QlikViewServer\BorrowedCalData.pgo"

               

               

              :Stop Servers
              net stop qlikviewserver
              net stop QlikviewWebserver
              net stop QlikviewManagementService
              net stop QlikviewDirectoryServiceConnector

               

               

              :Wait a moment
              ping -n 31 127.0.0.1 > NUL

               

               

               

              :Start the servers
              net start qlikviewserver
              net start QlikviewWebserver
              net start QlikviewManagementService

              net start QlikviewDirectoryServiceConnector

               

              HTH Peter

                • Re: QlikViewServer - how to track it over Christmas
                  Friedrich Hofmann

                  Hi Peter,

                   

                  thanks for the suggestion! I think it's good - QlikTech has told us the server should be restarted regularly, though daily does seem a bit much - but it wouldn't be for long. Only until we can update to the newest version at the end of January.

                  Only, that is not up to me - I've already made a similar suggestion to our IT_guys to have a batch to restart the server once a month and they told me that they won't do that - don't ask me why, it's not open to comprehension, nor to discussion ;-)

                    • Re: QlikViewServer - how to track it over Christmas
                      Dave Riley

                      You only need to stop/start the SERVICES not the SERVER, if your IT think it's the latter I can understand their concerns, but restarting services shouldn't be an issue.

                       

                      Incidentally I run my services reboot via a scheduled task in QMC rather than Windows Scheduler. If you have the ability to get a batch file on the server (with the net stop and net start commands), a new QVW doc on the server (to execute the .bat/.cmd file) and have rights in QMC to schedule it, then you may not need IT support.

                       

                      flipside


                  • Re: QlikViewServer - how to track it over Christmas
                    Friedrich Hofmann

                    Thanks! Yes, that solution seems very worth trying.

                    We'll just have a small app that must fail every time, so we should get email.

                    Can we forward that email or re-route it to a private account?

                  • Re: QlikViewServer - how to track it over Christmas
                    Peter Cammaert

                    BTW If you want to know your current QV version, visit one of the last pages of the QMC (System->About). Every service is listed with its build number. Post the "Product Version" of QlikView Server (QVS) and I'll get back to you with a release number.

                    • Re: QlikViewServer - how to track it over Christmas
                      Peter Rieper

                      Hi,

                      actually we do a restart each night. I always feel uncomfortable to have the day starting with a high amount of RAM still blocked / not released by QlikView. Was told, that all files are unloaded, but the server still keeps the cached selections in memory. Was also told, that this would not harm the performance, but .....

                       

                      In order to prevent a failure due to non-starting of a service, have made another batch, which runs 10 mins after the above and which contains only the starting params. Thus in case that - for whatever reason - some service does not start, it will be triggered in a second batch to start.

                       

                      HTH Peter

                        • Re: QlikViewServer - how to track it over Christmas
                          Friedrich Hofmann

                          Hi all,

                           

                          we face an additional problem now (it's twofold)

                          - We have a rather large reload_cascade (one task being triggered by successful completion of the one before)

                          => When the QlikView_server crashes during the day, there is a chance that the next cascade (to start every even nr. of hrs, all 2 hrs)

                          => Is there a way we can implement in the batch_file we'll have for the restarting of the services a command to trigger the cascade (in addition to the normal scheduled trigger)

                          Oh - last, but not least - WE DO NOT HAVE QV_PUBLISHER ;-)

                           

                          The other problem is just as hairy:

                          - Quite a few times over the last weeks, that reload_cascade has stopped at one app that is to fetch a lot of data from a copy of our database in another plant - the code is exactly the same as in our copy since the database they use is an exact copy of ours (the app for our database, which always works, is called LOAD_AOS and theirs is called LOAD_AOS_08.)

                          => Same question: Is there any way we can have some automatism to start the cascade once again (it usually works when we start it again, which is as sure a sign as one can expect that something is wrong with their database) in case it fails?

                           

                          Thanks a lot!

                          Best regards,

                           

                          DataNibbler

                        • Re: QlikViewServer - how to track it over Christmas
                          Peter Rieper

                          We do not have the publisher and do not need the distribution-service.

                          But you should be able to extract service-name from the running tasks

                           

                          Peter