Troubleshooting Tip: How to fix 'Log View' not loading after FortiAnalyzer upgrade to v7.4.6

[jjdope]

Description	This article describes how to fix the 'Log View' page not loading after an upgrade to v7.4.6.
Scope	FortiAnalyzer v7.4.6 and onwards.
Solution	The FortiAnalyzer was upgraded to v7.4.6, and after that, the Log View page does not load.  To resolve this issue, run the following command. diagnose system fsck harddisk - This will reboot the FortiAnalyzer and repair the file system. Also, the FortiAnalyzer database should be rebuilt if necessary. execute sql-local rebuild-adom <AdomName> <----- Before v7.6, it does not require a restart. execute sql-local rebuild-db Regarding the rebuild, follow the article below: Technical Tip: FortiAnalyzer SQL database delete and rebuild In some cases, stopping the SIEM module is also necessary: Technical Tip: How to improve FortiAnalyzer performances when FortiSIEM module is not needed If the issue persists, open a TAC ticket and attach the commands below the output: diagnose test application fazcfgd 6 db 10 diagnose sql hcache status all diagnose test app sqlrptcached 2  <------------ Run this 5 times in the interval of 5 seconds.