QlikView Governance Dashboard 2.0.4 Field Not Found <SeverityID>

[jkoelemeijer]

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)

[Tyler_Waterfall]

I would love to open source this so Please share! Thanks!

[ddelozier]

I am getting the same error, what is the solution to this?

[Tyler_Waterfall]

@ddelozier - have you tried using the latest version 2.1.4 available here? QV GovDash > QlikCommunity > Topic Groups > Qlik Management & Administration 

[ddelozier]

Yes I am running that version and get the same error.

[langelwong]

Hey

Have you found a solution for this? I have the same problem using Governance Dashboard 2.1.4