Skip to main content
FortiZiq
Staff
FortiZiq
Staff
July 17, 2024

Technical Tip: Scheduled reports will not run during rebuild ADOM

  • July 17, 2024
  • 0 replies
  • 610 views
Description

This article describes that scheduled reports will not run when ADOM database is rebuilding.
Scope FortiAnalyzer.
Solution
  1. In this example, the report 'Bandwidth and Applications' has already been scheduled to run at 11:58 AM in the report calendar Reports -> Advanced -> Report Calendar.

 

scheduled_focus.png

 

  1. The SQL database rebuild is initiated via the below CLI command on the FortiAnalyzer CLI and the ADOM DB rebuilding is still in progress at the scheduled time (11:58 AM):

 

execute sql-local rebuild-adom root

 

rebuilding_focus.png

Note: 
Command 'execute sql-local rebuild-adom' is not supported on v7.6 releases. 

 

 

  1. Using the command 'diagnose sql status rebuild-adom', the rebuild DB started at 11:56:55 AM and took 117 seconds to complete, therefore ending at 11:58:52 AM.

 

rebuild_starttime_duration_focus.png

 

  1. Going to the Reports -> Generated Reports page on the FortiAnalyzer shows that no reports were generated at 11:58 AM.

 

generated_reports_focus.png

 

Further, checking on the Report Calendar page shows that there is no report generated at 11:58 AM and the previous entry was removed.

 

calendar_after.png
    Terms & ConditionsAccessibility statement
    Thought Leadership Security Summit. Outpace New Threats with AI - enhanced defense. Tuesday, Septmeber 15, 8:30 AM - 2:30 PM PT. The Golf Club at Newcastle, WA.
    Virtual event | September 2026. SASE summit. The age of autonomous trust. Register here!