QlikView 12 Application: System Monitor

[MichaelTerenzi]

A derivative of the QlikView System Monitor for versions 10/11, finally the QlikView 12-compatible version has arrived. The UI has undergone some changes and the structure/setup has been simplified. This application will read your QVS machine logs and output all kinds of information for you, such as virtual memory warnings, PGO/.Shared errors, user trending and utilization, and chronological logging events across the system.

If you're looking for the QV 11.2 version, please find it here.

Thanks for your patience and if you have any questions/comments please post to this thread!

Best,

MT !

[cleite2014]

Hi Michael, Yes after I commented out the lines noted above the app did load and I could get the information I was after.  Do you have a code change I should put in to get these lines put back in the app?

Thank you,

Craig Leite

[fmarvnnt]

Here it is:

[michelivor]

Hi Michael,

I've had the same problem as BhanuRekha when running "System monitor 4.1" on a QV 12.2 server. One task logg is empty so it crashes. Throwing away that task logg helps until midnight when it is re-created.

Running QVSystemMonitor_v5.1.23 works fine but with QVSystemMonitor_v6.1.1 I've the same problem as Franseco in above comment.

Regards

Michel

[adcgermany]

Hi Michael,

We were using System Monitor4.1 with Qlikview 11 and it was working fine.

When using System Monitor 4.1 with Qlikview12 ,the DocumentName in the Document usage chart is showing the entire path . We want only the document name .

Some changes happened to the logging of session entries in sessions log file after Q12 upgrade . The ‘\’ is changed to ‘/’  in the path logging. In the code .

In QV code ,it is checking for  ‘\’ in  Document name for extracting application name (code pasted below) .

Is this an expected behaviour with Q12 and how we can overcome this issue.

In the sessions log,Q11 related entries are with '\' and Q12 entries are with '/'.

[Serkan]

Hi,

could you solve this issue?

[insanwwl]

Hi All,

Can you explain me about Plugin Maintenance (< 60 days) in the QV System Monitor Dashboard?

Thank you,

Selva. 

[Jeffrey_Li]

Hi, Michael,

We recently upgraded Qlikview server to May 2021 SR1 release.  After that, QV system monitor app stopped working. Here are related log content:

20211020T084341.099-0500 0792 Inner Join
20211020T084341.099-0500 0793 IntervalMatch (Timestamp, UserID)
20211020T084341.099-0500 0794 Load [Session Start],
20211020T084341.100-0500 0795 Timestamp([Session Start] + [Session Duration], 'YYYY-MM-DD hh:mm:ss') as [Session End]
20211020T084341.100-0500 0796
20211020T084341.100-0500 0797
20211020T084341.101-0500 0798 Resident Sessions
20211020T084341.101-0500 2 fields found: Session Start, Session End,
20211020T084341.101-0500 Error: Interval Fields List not matching number of fields.

My system monitor version is v.6.1.1.

Thanks

Bo

[agigliotti]

Hi @Jeffrey_Li ,

I'm facing the same issue, see below:

I'm using QlikView May 2022 SR1 version.

Did you fix it ?

Please let me know.

Best Regards

@MichaelTerenzi @Sue_Macaluso 

[hanselalf]

Hi agigliotti,

you have to change the script at section "AuditLog" or MichaelTerenzi  gives us a right version:

...

Inner Join

IntervalMatch (Timestamp, AuthenticatedUser) //IntervalMatch (Timestamp, UserID)//, %DocUserKey) 

Load  [Session Start],// as SessionStart,

  Timestamp([Session Start] + [Session Duration], 'YYYY-MM-DD hh:mm:ss') as [Session End],

  AuthenticatedUser

//******Insert Sessions Log File Name here******

Resident Sessions; 

...

[Suhr]

Thanks @hanselalf.
It worked for me.