Risk matrix values not updating after control changes in risk management dashboard

QMS Sparta Systems TrackWise
, , , , , , , ,
1

We’ve implemented new risk controls in our Risk Management module, but the risk matrix dashboard is showing stale values. After updating control effectiveness ratings and mitigation strategies, the residual risk scores should decrease, but the dashboard still displays the original pre-mitigation risk levels.

I’ve manually refreshed the dashboard and even logged out and back in, but the risk matrix calculation doesn’t seem to be picking up the control changes. The individual risk records show the updated control information correctly, so the data is there. The issue appears to be with the risk matrix calculation job not running or the dashboard auto-refresh mechanism not triggering properly.

Our compliance team needs accurate real-time risk visibility for upcoming audits. Has anyone experienced issues with risk matrix calculations not updating after control modifications in TW 10.0?

2

Be careful with hourly risk calculations if you have a large number of risks and controls. The calculation job can be resource-intensive. A better approach is to use event-driven recalculation so that only affected risks are recalculated when controls change, rather than recalculating the entire matrix on a schedule. This is more efficient and provides near real-time updates.

3

Thanks for the suggestions. I found that the Risk Calculation Job is scheduled to run daily at midnight, which explains the delay. However, we need more frequent updates for our risk dashboard. Can I safely change this to run hourly without impacting system performance?

4

I’ve implemented risk matrix solutions across multiple Trackwise instances and can provide a comprehensive fix for all three areas:

Risk Matrix Calculation Job: The daily midnight schedule is insufficient for real-time risk visibility. Navigate to Admin > System Jobs > Risk Matrix Calculation and modify the job configuration:

  1. Change frequency to every 2 hours during business hours (8 AM - 6 PM) to balance performance with currency
  2. Enable ‘Incremental Calculation Mode’ - this only recalculates risks that have changed since the last run, significantly reducing processing time
  3. Set the job priority to ‘Medium’ to ensure it doesn’t interfere with user transactions
  4. Enable notification on job failure so you’re alerted if calculations don’t complete

For immediate updates when needed, you can manually trigger the calculation job from Admin > System Jobs > Run Now. However, the better approach is event-driven recalculation.

Event Trigger Mapping: This is the key to near real-time updates. Configure event triggers to automatically recalculate affected risks when controls change:

Go to Admin > Risk Management > Event Configuration and set up these triggers:

  • Event: ‘Control Effectiveness Updated’ → Action: ‘Recalculate Associated Risks’
  • Event: ‘Mitigation Strategy Modified’ → Action: ‘Recalculate Risk Score’
  • Event: ‘Control Assignment Changed’ → Action: ‘Update Risk Matrix’

Enable the ‘Asynchronous Processing’ option for these triggers so they don’t slow down the user’s control update action. The recalculation will happen in the background within 1-2 minutes.

Also verify that the event handlers are active by checking Admin > System Health > Event Processing Status. Sometimes these handlers get disabled during system maintenance and aren’t re-enabled.

Dashboard Auto-Refresh: The dashboard caching is likely your immediate problem. Configure the Risk Management dashboard to refresh more frequently:

  1. Edit the Risk Matrix Dashboard (Admin > Dashboards > Risk Matrix)
  2. For each widget, set ‘Auto-Refresh Interval’ to 5 minutes
  3. Enable ‘Real-Time Data Mode’ which bypasses the cache layer for risk calculations
  4. Configure the dashboard data source to use the ‘Current Risk Matrix View’ not ‘Cached Risk Summary’

For the main risk matrix widget specifically:

  • Data Source: Select ‘vw_current_risk_matrix’ instead of ‘vw_risk_matrix_snapshot’
  • Refresh Mode: ‘On Data Change’ with 5-minute fallback
  • Cache: Disable widget-level caching for real-time accuracy

Immediate Resolution Steps:

  1. Manually run the Risk Matrix Calculation job now to update all current values
  2. Clear the dashboard cache: Admin > System Maintenance > Clear Dashboard Cache
  3. Configure event triggers for future automatic updates
  4. Update dashboard refresh settings for all risk management dashboards
  5. Test by updating a control and verifying the risk matrix updates within 5 minutes

Performance Considerations: With these changes, you’ll have near real-time risk visibility without overwhelming the system. The combination of event-driven incremental calculations and smart dashboard caching provides the best balance. Monitor system performance for the first week and adjust the auto-refresh interval if needed.

Your compliance team will now see updated risk scores within minutes of control changes, which is essential for audit readiness and accurate risk reporting.

5

We had this exact problem during our ISO audit prep. The dashboard was showing outdated risk scores, which created confusion. The solution involved both fixing the calculation job schedule and enabling the dashboard auto-refresh feature. Also make sure your dashboard widgets are configured to pull from the current risk matrix view, not a cached snapshot.

6

I think the issue might be with event triggers. When you update a control, there should be an event that triggers a recalculation of associated risks. Check your event trigger mapping in Admin > Risk Management > Events. Make sure the ‘Control Updated’ event is configured to trigger ‘Recalculate Risk Matrix’.