Technical Tip: Scheduled reports will not run during rebuild ADOM

[haziqsulaiman]

Description	This article describes that scheduled reports will not run when ADOM database is rebuilding.
Scope	FortiAnalyzer.
Solution	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. 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 Note:  Command 'execute sql-local rebuild-adom' is not supported on v7.6 releases.  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. Going to the Reports -> Generated Reports page on the FortiAnalyzer shows that no reports were generated at 11:58 AM. Further, checking on the Report Calendar page shows that there is no report generated at 11:58 AM and the previous entry was removed.