Availability report loads slowly in Operator Console BI - DX UIM

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Availability reports within the DX Unified Infrastructure Management (UIM) Operator Console (OC) Business Intelligence (BI) portlet may experience significant slowness or failure to load data. This typically occurs when the maintenance history contains a high volume of records, leading to database query timeouts.

Environment

• DX Unified Infrastructure Management 23.4.7.x
• UIM BI sample dashboards
• Maintenance Mode (mm) probe

Cause

The maintenance_mode  probe configuration for purge_windows_history_days is set to -1 by default, which prevents the purging of historical maintenance window data. Over time, this table can accumulate hundreds of thousands of rows (e.g., >500,000), causing the queries used by BI reports to timeout.

Resolution

To improve report performance, reduce the retention period for maintenance window history:

1. Open Infrastructure Manager or Admin Console.
2. Locate the maintenance_mode (mm) probe.
3. Open the Raw Configure window for the probe.
4. Navigate to the setup 
5. Locate the key: purge_windows_history_days.
6. Change the value from -1 to 60 (or the desired number of days for your retention policy).
7. Click OK and restart the probe.

The probe will begin purging records older than the specified limit during its next maintenance cycle. Verify that the record count in the database decreases to ensure the purge is successful.