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.

      Enjoy!

      Tyler

        • 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)

          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)