8 Replies Latest reply: Nov 27, 2015 12:54 AM by abhay singh RSS

    Qlik Sense has stopped logging

    Simon Hogg

      I run Qlik Sense on a virtual server.  Yesterday we shut down the server, assigned some more memory, then restarted the server.

       

      Today I was looking in the "License Monitor" and the "Operations Monitor" apps and noticed both of their last entries were just before we shut down the server.

       

      Going into the Tasks panel in QMC, I can see the reload tasks for both these apps has the status "Failed", and when I look closer I can see this error (this is from "Reload License Monitor.log";

       

      Any ideas?  All the Qlik services are up and running.

       

      2015-09-17 14:06:38 0374       file_List:

      2015-09-17 14:06:38 0375           Load

      2015-09-17 14:06:38 0376             'lib://ArchivedLogsFolder/SERVER\Engine\Audit\SERVER_QixCounter_Engine_2015-09-17T06.07.41Z.log' as txtName,

      2015-09-17 14:06:38 0377             FileTime( 'lib://ArchivedLogsFolder/SERVER\Engine\Audit\SERVER_QixCounter_Engine_2015-09-17T06.07.41Z.log' ) as fTime

      2015-09-17 14:06:38 0378           AutoGenerate 1

      2015-09-17 14:06:38            2 fields found: txtName, fTime,

      2015-09-17 14:06:38            1 lines fetched

      2015-09-17 14:06:38 0380       Let file_time = num(peek('fTime'))

      2015-09-17 14:06:38 0383       If 42264.29700857 >= 42262.587986111 then

      2015-09-17 14:06:38 0384      

      2015-09-17 14:06:38 0385         CONCATENATE (working_counterEngine)

      2015-09-17 14:06:38 0386               Load

      2015-09-17 14:06:38 0387                 timestamp(Timestamp(Timestamp#(Replace(Left(Timestamp,15),'T',' '), 'YYYYMMDD hhmmss')),'YYYY-MM-DD hh:mm:ss[.fff]') AS LogTimeStamp,

      2015-09-17 14:06:38 0388                 CounterName,

      2015-09-17 14:06:38 0389                 CounterValue,

      2015-09-17 14:06:38 0390                 lower(Hostname) as Hostname,

      2015-09-17 14:06:38 0391                 Id as Id_temp

      2015-09-17 14:06:38 0392              

      2015-09-17 14:06:38 0393               FROM 'lib://ArchivedLogsFolder/SERVER\Engine\Audit\SERVER_QixCounter_Engine_2015-09-17T06.07.41Z.log'

      2015-09-17 14:06:38 0394               (txt, utf8, embedded labels, delimiter is '\t', msq)

      2015-09-17 14:06:38 0395               WHERE isnum(Sequence#)

      2015-09-17 14:06:38 0396                AND CounterName <> 'Layout' and CounterName <> 'Properties'

      2015-09-17 14:06:38              Error: Field not found - <CounterName>

      2015-09-17 14:06:38              General Script Error

      2015-09-17 14:06:38              Execution Failed

      2015-09-17 14:06:38              Execution finished.