Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

jkoelemeijer
New Contributor

QlikView Governance Dashboard 2.0.4 Field Not Found <SeverityID>

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)

1 Reply
Employee
Employee

Re: QlikView Governance Dashboard 2.0.4 Field Not Found <SeverityID>

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

Community Browser