Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

How Many Months Of History Should Be Available In The Operation Monitor App

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Seo
Support
Support

How Many Months Of History Should Be Available In The Operation Monitor App

Last Update:

Apr 5, 2022 4:40:48 AM

Updated By:

Sonja_Bauernfeind

Created date:

Aug 10, 2019 8:16:08 PM

How to reduce the size of the Operations Monitor App or decide how much history is being stored.

Scenario: There are only 3 months of history/data in Operation Monitor app. Even though there are enough logs in Archived log folder to provide information for more months. 

Scenario 2: There are 3 months of history/data seen but less data is required due to too high traffic. 

This article explains how Operation monitor app can be displayed more or less than 3 months of history/data. Note: We do not recommend configuring the Operations Monitor to provide a history longer than 3 months as this amount of data will lead to long loading times and large apps.

 

Resolution:

 

  1. Duplicate the Operation Monitor app. You can do so from the Hub or the Qlik Sense Management Console if you have access to the App.

  2. Open the Qlik Sense Hub, Navigate to Work and open your copy of the Operations Monitor(1)

  3. Open the Data load editor

  4. Locate line 24 in the Initialize tab (first tab)

  5. Line 24 will read: SET monthsOfHistory = 3

  6. Modify SET monthsOfHistory = 3  to your preferred value.  The Operations Monitor will be able to load data as long as you have log files that go that far back. 

    Example:
    "SET monthsOfHistory = 3"        -- 3 Months
    "SET monthsOfHistory = 6"        -- 6 Months
    "SET monthsOfHistory = 12"      -- 12 Months​

     

  7. Open a Windows file browser and navigate to: %PROGRAMDATA%\Qlik\Sense\Log (default install folder)

  8. Remove all “governance” QVDs from this folder. This step is crucial for the changes to work.

  9. Go to the Qlik Sense Management Console

  10. Open Apps

  11. Locate your copy of the Operations Monitor.

  12. Click publish

  13. Select the Monitoring Apps stream

  14. Check the Replace existing app checkbox

  15. Select the original Operations Monitor 
  16. Click OK

  17. Go to Tasks and start the Operations Monitor task

  18. Your app will now show the desired number of months. 

 

Note: 
Please note that the reload time for that long of data will be rather long.

Labels (2)
Comments
Ken_T
Specialist
Specialist

Hi , can you give some guidance on how to correct the Latest activity filter in top left corner of the session overview ?  This filter no longer functions properly when it has been increased for example to 12 months worth of data. It has 3 values, 30 days, 60 days and 90 days. selecting any of these values has no affect on the data shown and results calculated this article should explain how to fix that problem.   thanks!

Ken_T
Specialist
Specialist

I logged a ticket on this issue and got no assistance. This is a hard coded filter and it does not function properly after applying the changes from this article. Can Qlik confirm that after performing this change to bump up the data to be more than 3 months, the Latest activity filter on Session overview stops functioning and will require some code changes to try to correct the problem.

also, a list of the governance qvd's could help clarify this article.

 

Sonja_Bauernfeind
Digital Support
Digital Support

Hello Ken,

The setting has been confirmed to work and no additional changes to the app itself are needed (except step 8 in the instructions: deleting the old .qvds).

I've reached out to our SMEs for an additional review though and will update you accordingly.

All the best,

Sonja 

Ken_T
Specialist
Specialist
The built-in filter named "Latest activity" with values of 30+ Days, 60+ Days and 90+Days does not work properly after performing these steps.
So far I have not found the configuration/script changes required to make this filter work after increasing the months of history.
That filter is hard coded and cannot be easily removed and must have one value selected.
I logged a support ticket about a year ago and got not confirmation or assistance on the issue.
Sonja_Bauernfeind
Digital Support
Digital Support

This article was verified and the steps were updated to reflect all required steps. Should you run into issues, please report a ticket with support.

505018417
Contributor
Contributor

For the cluster environment where would you find below qvds?

  1. Open a Windows file browser and navigate to: %PROGRAMDATA%\Qlik\Sense\Log (default install folder)

  2. Remove all “governance” QVDs from this folder. This step is crucial for the changes to work.
Sonja_Bauernfeind
Digital Support
Digital Support

Hello @505018417 

They will be stored in whichever folder you have defined during setup in the Data Connection (see Configuring multi-node environments).

All the best,
Sonja 

505018417
Contributor
Contributor
What do I look for? What file/folders should I be looking for to change that. We would like to have 12 months of History in the Operation Monitor App.
Sonja_Bauernfeind
Digital Support
Digital Support

Hello @505018417 

Can you be more specific with your request? Do you need assistance locating the folder where the .qvds are stored in your multi-node environment? Suppose you have configured the monitoring apps correctly as per Configuring multi-node environments. In that case, you can find this folder as per step 1 in the multi-nod instructions (Configuring multi-node environments)

Update the data connections ServerLogFolder, by replacing C:\ProgramData\Qlik\Sense\Log with the FQDN path to the central node: \\<FQDN>\<UNC_Share>\Log.

This refers to the data connection in the Qlik Sense Management Console:

Open your Data Connections, scroll down and locate ServerLogFolder (1) and click Edit (2).

serverlogfolder.png

This opens the connection, and there you can see what the connection string was configured to:

serverlogfolder configured.png

Note that in my screenshot, it is the default folder since this is a single-node environment where I have not set up the monitoring apps to work with a multi-node.

 

All the best,
Sonja 

Contributors
Version history
Last update:
‎2022-04-05 04:40 AM
Updated by: