Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView Application: System Monitor v5.1.23

themichael
Contributor

QlikView Application: System Monitor v5.1.23

New - Version 5.1.23 (posted 9/25/2014)

***added workaround for "UserAgent" bug where condition is not met but QV reads the Else field anyways

***Edited expressions for TotalMaxCalsInUse charts to reflect max of cluster, not sum of nodes

***Corrected QDS variable typo in script

This app was created by Michael Terenzi of QlikView Support, and has a number of new

features:

New Features:

  • Includes Salesforce Connector and SAP Connector
    logging integration
  • Includes Offline Client logging integration
  • Includes Windows OS Event Application/System/Security
    logging integration (see instructions)
  • Specify how many days’ worth of logs you want to
    retrieve (default is 30 days)
  • Hyperlinks added to data tables so you can quickly
    link an error message to either Salesforce Help (SF Connector messages), EventID.net
    (Windows logs include event and source automagically in URL), and QlikCommunity
    for all others. Now if you get “Invalid Query Locator” error from the
    Salesforce logs, you get sent to the right place to find out why.
  • Added capability for DD/MM/YYYY  webserver logs to be picked up for those of
    you with different time formatting (see instructions)

Previous additions:

  • Optimization – CPU, Table structure
  • New UI (simpler, easier interface)
  • Supports up to 10 QVS nodes
  • Supports up to 2 QDS instances (will read as a "node" but is really an entire resource)
  • Shared file corruption detection (only on builds 11440+ ....please contact Support if you encounter the alert)
  • Analyze concurrency trends over the hour or the minute, even with Performance logging turned off!
  • Includes Deployment Framework integration (by Magnus Berg)
  • Includes Scalability Center Environmental Analytics (see attachments and please email them your results!)
  • Only includes support for QV 11
  • Removed HTTP ERROR, QMS Audit logging due to time constraints

Instructionsfor use:

  • Verify your logs are in the default locations and adjust as needed in the Setup tab
  • Save and reload!
  • For custom/enterprise environments, Clear Defaults (button) in Setup tab and enter Required Components
  • Must be running on QV 11 and must have QVS Event logs to run bare bones

Precautions:

  • Archive your logs and stow them away if not necessary for your analysis. Webserver/IIS logs have the potential to greatly increase table sizes, so limit your source data if possible to optimize performance
  • When navigating to the Troubleshooting tab you will need at least 2 gb RAM on your machine with the sample data (sorry )
  • Over time you are looking at potentially millions and millions of records. Don't be a hoarder!
  • QV10 is not supported, especially on the Publisher side. Feel free to try your luck if necessary.

SM01.png

SM03.png


SM05.png

Attachments
Comments
deepakk
Valued Contributor III

hi Michael

Good Work.

A small concern for which I would like to know if its possible to get a solution on it.

In your report (Distinct User-Doc Sessions) , it displays user who don't have access to the application.

eg: if user "A" clicks an application , naturally he will get message "Access denied no user cal assigned"..

in you report it displays user "A" application"XZY"   session : 1

I hope you got my concern.

Regards

Deepak

Not applicable

I cant found the logs files of the server... can anyone help me?

Not applicable

Hi,

I really like this app.

Have you any plan on supporting 3 clustered QDS soon?

regards

/svante

jlp_laurastar
New Contributor III

I like your application but i'm using the v4 since a long time and the v5 is less usable as the v4.

We can better see the Servers activities with the v5.

But tracking the documents, users, licences activity is very difficult.

Your new choice for the interface give less place for all information and it's difficult to read, select,.....

It's like your v5 is developp for a small device.

Not applicable

I agree - GUI wise v4 is far better. I cannot find my way in v5.

themichael
Contributor

Hi all,

Thank you very much for your feedback

I had a lot of feedback on the old version saying that it was too difficult to navigate, too many tabs etc. Thus the new version, which of course will not suit everyone. The good news is that most of the objects and sheets from the old version should copy/paste over and if needed, require minimal changes in order to make work. If there is something you really need from the older version try to paste it in this one and tweak it. Most objects are fundamentally the same (though not all).

In this version information is broken down primarily by the QVS services; in the old one it was a bit more random. I hope you grow to enjoy the new one however; I think it provides a lot more useful information for you.

Deepak Kurup can you send me your events/session/performance logs from the particular day this occurs?

Also be sure to check out the governance_dashboard - it has a lot of nice features that admins really love and find useful.

Thanks again and best of luck.

-Michael

alex_nerush
Contributor II

hi Michael,

System Monitor has a bug - it doesn't support internationalization (doesn't support various date and time formats). In my particular case, dates in log files has following format "DD.MM.YYYY" and as a result, after reloading i have null values inside appropriate dates fields.

themichael
Contributor

Hi Alex,

Which log are you referring to?

alex_nerush
Contributor II

For example, ManagementService Log files.

p.s. Actually, dates from all my log files has DD.MM.YYYY format.

themichael
Contributor

Hi Alex,

In the load script make sure your variables for Date/Time are set to default. If so, you will have to manipulate the script to get the time format right. There should be comments on most of the parsing - if the delimiter is the only thing different just substitute in the "." with a "-" and see if that works.

Generally I don't use the QMS, QVWS, DSC logs unless I'm troubleshooting. QVS and QDS logs are probably the most important so you might save yourself some time if these are what you're after. Good luck, hope this helps.

Best Regards,

Michael

Version history
Revision #:
1 of 1
Last update:
‎05-29-2013 04:32 PM
Updated by: