1 Reply Latest reply: Feb 16, 2018 10:06 AM by Tyler Waterfall Branched from an earlier discussion. RSS

    QlikView Governance Dashboard 2.0.4 Field Not Found <SeverityID>

    Jean-Luc Koelemeijer

      great tool! super usefull

       

       

      however there is a bug maybe you can help with

       

      here is the error message when I reload:

       

      Field not found - <SeverityID>

      Concatenate (Events)

      Load

      RecNo() as EventsEntry,

      'C:\ProgramData\QlikTech\QlikViewServer\Events_QLIKVIEW_2017-04-12.log' as EventsFileName,

      'C:\ProgramData\QlikTech\QlikViewServer\Events_QLIKVIEW_2017-04-12.log' & RecNo() as _EventsId,

      Timestamp( ConvertToLocalTime ([Timestamp])) as EventsTimestamp,

      date(floor(Timestamp)) as EventsDate,

      num(date(floor(Timestamp))) as EventsDateNum,

      (Severity='Error')*-1 as [Server Error Count],

      (Severity='Warning')*-1 as [Server Warning Count],

      SubStringCount(Message,'Restart: S') + SubStringCount(Message,'Server shutting down') as [Server Restart],

      EventID,

      Severity,

      Message,

      1 as EventCount,

      'QLIKVIEW'&'|' & round(num(Timestamp( ConvertToLocalTime ([Timestamp]))),0.001) as Node_TS

       

       

      FROM 'C:\ProgramData\QlikTech\QlikViewServer\Events_QLIKVIEW_2017-04-12.log' (txt, utf8, embedded labels, delimiter is '\t', msq)

      WHERE NOT EXISTS(_EventsId,'C:\ProgramData\QlikTech\QlikViewServer\Events_QLIKVIEW_2017-04-12.log' & RecNo())

      AND isnum(SeverityID)