FortiAnalyzer
FortiAnalyzer can receive logs and Windows host events directly from endpoints connected to EMS, and you can use FortiAnalyzer to analyze the logs and run reports.
haziqsulaiman
Article Id 326326
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

 

  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