2 Replies Latest reply: Sep 13, 2017 2:36 PM by Tyler Waterfall RSS

    QlikView Governance Dashboard 2.0.4 released!

    Tyler Waterfall

      Hello everyone -

      QlikView Governance Dashboard 2.0.4 was just released and is available on the download site. Wahoo!

      See: QlikView 12.10 Service Release 8 and QlikView Governance Dashboard 2.0.4 now available


      It includes several bug fixes which should improve all of our lives.



        • Re: QlikView Governance Dashboard 2.0.4 released!
          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)


          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],




          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)