5 Replies Latest reply: Jan 12, 2015 10:43 AM by Alexandru Chirica RSS

    Qlikview server hangs, logs errors, requires service restart

      Hi, I have a problem with our QV deployment - every couple of days, the Qlikview Server process will hang, requiring a restart of the QlikviewServer service in order to get things to working correctly.

       

      Soon after it stops working, I get log entries like this:

       

      Log: Application

      Type: Error

      Event: 300

      Agent Time: 04:57:55 PM 10-Jan-2012

      Event Time: 10:57:55 PM 10-Jan-2012 UTC

      Source: QlikViewServer

      Category: None

      Username: N/A

      Computer: qv.domainname

      Description: DOC loading: DocumentC:\PROGRAMDATA\QLIKTECH\DOCUMENTS\docname.QVW became obsolete whileloading - retrying.

       

      Clients typically get a completly white screen - they are using the webclient.

       

      A few notes on our environment:

      I recently upgraded to QV11 (but it was happening previously with QV10)

      All qlikview services are running on a single windows server (Server 2008 R2).

      I'm using the builtin Qlikview Web Server, not IIS.

       

      • Any recommendations to fix this?
      • Would running another qlikview server help?  E.g. if I had two systems running QlikView server, would one pick up all clients if the other wasn't working in this manner?
      • Any recommendations for monitoring this?  I started watching the event log entries with our monitoring applicaiton (kaseya) and was going to have it restart the QlikViewServer service, but this isn't fast enough for our users - they are on me to get things working before I get the notification.

       

      Thanks,


      ~ Alex

        • Qlikview server hangs, logs errors, requires service restart
          Daniel Rozental

          Alex, you should look at the events.log file on your server for more information.

           

          It might also be a good idea to restart all services periodically, even daily if you can live with that.

            • Qlikview server hangs, logs errors, requires service restart

              I could definetly restart the services daily in the early morning - is there a recommended/required startup order for them?

               

              Here's an excerpt from the log when it starts looking strange:

               

              For easier reading, see: http://pastebin.com/KFMAPDLL

               

              2012-01-08 11:26:21          2012-01-10 16:14:07          4          700          Information          CAL usage: Named CAL "domain\user4" now used - ok.`

              2012-01-08 11:26:21          2012-01-10 16:14:07          4          100          Notice          CAL usage: Using CAL of type "Document" for user "domain\user4". Document cals in use: 8

              2012-01-08 11:26:21          2012-01-10 16:14:35          2          500          Warning          Document Load: The document C:\ProgramData\QlikTech\Documents\document name.qvw failed to load because anonymous access is not allowed

              2012-01-08 11:26:21          2012-01-10 16:18:22          4          700          Information          DOC loading: Purging old copy of document C:\PROGRAMDATA\QLIKTECH\DOCUMENTS\document name.QVW.

              2012-01-08 11:26:21          2012-01-10 16:18:22          4          700          Information          DOC loading: Unloading document C:\PROGRAMDATA\QLIKTECH\DOCUMENTS\document name.QVW, state UNLOADING.

              2012-01-08 11:26:21          2012-01-10 16:19:23          4          700          Information          Ticket created: Ticket for domain\user4.

              2012-01-08 11:26:21          2012-01-10 16:19:23          4          700          Information          Ticket Lookup: Ticket 1FBAFA72783CA3059599D1E966B23FB82A7601D9 was found.

              2012-01-08 11:26:21          2012-01-10 16:19:23          4          700          Information          DOC loading: Beginning load of document C:\PROGRAMDATA\QLIKTECH\DOCUMENTS\document name.QVW.

              2012-01-08 11:26:21          2012-01-10 16:20:29          4          700          Information          Ticket created: Ticket for domain\user4.

              2012-01-08 11:26:21          2012-01-10 16:20:29          4          700          Information          Ticket Lookup: Ticket F028E903B9E4A8EBFDC0A03AEF86DDCF1B30D493 was found.

              2012-01-08 11:26:21          2012-01-10 16:21:30          4          700          Information          Ticket created: Ticket for domain\user4.

              2012-01-08 11:26:21          2012-01-10 16:21:30          4          700          Information          Ticket created: Ticket for domain\user4.

              2012-01-08 11:26:21          2012-01-10 16:21:30          4          700          Information          Ticket created: Ticket for domain\user4.

              2012-01-08 11:26:21          2012-01-10 16:21:30          4          700          Information          Ticket Lookup: Ticket 1D115DFFFCB2B5ED89904274CDEF31A05C39E0FD was found.

              2012-01-08 11:26:21          2012-01-10 16:21:30          4          700          Information          Ticket created: Ticket for domain\user4.

              2012-01-08 11:26:21          2012-01-10 16:21:30          4          700          Information          Ticket Lookup: Ticket F63E743F733757C54F726EE1E1D1B6D23EC89CFD was found.

              2012-01-08 11:26:21          2012-01-10 16:21:30          4          700          Information          Ticket Lookup: Ticket ACADFB4F0468520B220313EA5AE00A395C427298 was found.

              2012-01-08 11:26:21          2012-01-10 16:21:30          4          700          Information          Ticket Lookup: Ticket F230C3961159AEC13183055FEB149CF23000B85B was found.

              2012-01-08 11:26:21          2012-01-10 16:22:40          4          700          Information          Ticket created: Ticket for domain\user4.

              2012-01-08 11:26:21          2012-01-10 16:22:40          4          700          Information          Ticket Lookup: Ticket 235988E6CE51FEF4DBDA3591048B8A895DB7889B was found.

              2012-01-08 11:26:21          2012-01-10 16:23:41          4          700          Information          Ticket created: Ticket for domain\user4.

              2012-01-08 11:26:21          2012-01-10 16:23:41          4          700          Information          Ticket Lookup: Ticket 2CAEBE00DD5A4E0106F54326229F1D84EF9679EB was found.

              <snip>

              2012-01-08 11:26:21          2012-01-10 16:57:48          4          700          Information          Ticket created: Ticket for domain\user3.

              2012-01-08 11:26:21          2012-01-10 16:57:48          4          700          Information          Ticket Lookup: Ticket F3E9D74FCA2F781DDD8D4561C55BF18F1471AEF7 was found.

              2012-01-08 11:26:21          2012-01-10 16:57:54          4          700          Information          Document PreLoad: Stop

              2012-01-08 11:26:21          2012-01-10 16:57:55          4          700          Information          DOC loading: Unloading document C:\PROGRAMDATA\QLIKTECH\DOCUMENTS\document name.QVW, state UNLOADING.

              2012-01-08 11:26:21          2012-01-10 16:57:55          1          300          Error          DOC loading: Document C:\PROGRAMDATA\QLIKTECH\DOCUMENTS\document name.QVW became obsolete while loading - retrying.

              2012-01-08 11:26:21          2012-01-10 16:57:55          4          700          Information          DOC loading: Beginning load of document C:\PROGRAMDATA\QLIKTECH\DOCUMENTS\document name.QVW.

              2012-01-08 11:26:21          2012-01-10 16:57:55          1          300          Error          DOC loading: Document C:\PROGRAMDATA\QLIKTECH\DOCUMENTS\document name.QVW became obsolete while loading - retrying.

              <repeat last line about 50 times until I restarted the server process>

            • Qlikview server hangs, logs errors, requires service restart
              Graeme Smith

              We had similar symptoms, although the server process was hanging after hours rather than days.  It turned out to be an issue with QV compatibility with Unix based NAS. Remounting the share in the server as a LUN resolved the issue (but complicates DR/HA).  If you're using a Unix base NAS, might be worth investigating.

              • Re: Qlikview server hangs, logs errors, requires service restart
                Alexandru Chirica

                Hi guys,

                I have a similar problem with akochkipp's , maybe even the same one.

                 

                My observation is that this error does not occur randomly, but when you modify and save the document (in my case).

                 

                1/9/2015 4:021/9/2015 16:354700InformationDOC loading: Purging old copy of document X.
                1/9/2015 4:021/9/2015 16:354700InformationDOC loading: Unloading document X, state UNLOADING.
                1/9/2015 4:021/9/2015 16:364700InformationSession stop reason: invalid iis authentication string
                1/9/2015 4:021/9/2015 16:374700InformationDOC loading: Beginning load of document X.
                1/9/2015 4:021/9/2015 16:374700InformationDebug: Opening file X on disk
                1/9/2015 4:021/9/2015 16:384700InformationSession stop reason: invalid iis authentication string
                1/9/2015 4:021/9/2015 16:384700InformationDebug: File X opened OK
                1/9/2015 4:021/9/2015 16:384700InformationDocument Load: The document X was loaded.
                1/9/2015 4:021/9/2015 16:384700InformationSession stop reason: invalid iis authentication string
                1/9/2015 4:021/9/2015 16:391300ErrorDOC loading: Document X became obsolete while loading - retrying.
                1/9/2015 4:021/9/2015 16:392500WarningDOC loading: Retrying load of document X because it started UNLOADING.
                1/9/2015 4:021/9/2015 16:434700InformationSession stop reason: invalid iis authentication string
                1/9/2015 4:021/9/2015 16:472500WarningDOC loading: Retrying load of document X because it started UNLOADING.
                1/9/2015 4:021/9/2015 23:484700InformationSession stop reason: invalid iis authentication string

                 

                And this went on until the services were restarted (this is done daily).

                 

                Any ides why this is happening?