Qlik Community

Qlik Sense Deployment & Management

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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)

4 Replies
Highlighted
Employee
Employee

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

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

Highlighted
Contributor
Contributor

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

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

Highlighted
Employee
Employee

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

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

Highlighted
Contributor
Contributor

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

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