1 Reply Latest reply: Jul 25, 2015 7:32 PM by Alec Harf RSS

    Operations and License Monitors app failed to load on QlikSense

    Alec Harf

      hi all,

       

      Operations sand licenses monitors app failed due to not founding a column in one of the log files..

       

      Here is part of the log where the fail appear.

       

       

      CONCATENATE (working_counterEngine)

      2015-07-25 18:50:23 0386               Load

      2015-07-25 18:50:23 0387                 timestamp(Timestamp(Timestamp#(Replace(Left(Timestamp,15),'T',' '), 'YYYYMMDD hhmmss')),'YYYY-MM-DD hh:mm:ss[.fff]') AS LogTimeStamp,

      2015-07-25 18:50:23 0388                 CounterName,

      2015-07-25 18:50:23 0389                 CounterValue,

      2015-07-25 18:50:23 0390                 lower(Hostname) as Hostname,

      2015-07-25 18:50:23 0391                 Id as Id_temp

      2015-07-25 18:50:23 0392              

      2015-07-25 18:50:23 0393               FROM 'lib://ArchivedLogsFolder/colo-qlik.metroftz.com\Engine\Audit\COLO-QLIK_QixCounter_Engine_2015-07-18T10.49.41Z.log'

      2015-07-25 18:50:23 0394               (txt, utf8, embedded labels, delimiter is '\t', msq)

      2015-07-25 18:50:23 0395               WHERE isnum(Sequence#)

      2015-07-25 18:50:23 0396                    AND CounterName <> 'Layout' and CounterName <> 'Properties'

      2015-07-25 18:50:23              Error: Field not found - <CounterName>

      2015-07-25 18:50:23              General Script Error

      2015-07-25 18:50:23              Execution Failed

      2015-07-25 18:50:23              Execution finished.


      Anyone knows what could be the reason and how to fix?


      Best,

      Alec