Technical Tip: How to stop a running FortiAnalyzer report
Description
This article explains how to stop a report from running on a FortiAnalyzer. This may be useful during troubleshooting when resources need to be freed up.
Scope
FortiAnalyzer.
Solution
From the GUI: Select the report that is running and delete it.
From CLI:
From CLI:
- Find the PID for the sqlrptcached and sqlreportd processes (use the command exec top to determine the PID).
- An alternative to find the PID of sqlrptcached and sqlreportd using the below command:
diagnose system process list
- To kill the PID process:
diagnose sys process kill 11 <PID>
- Or run the following commands to restart the processes.
diagnose test application sqlreportd 99
diagnose test application sqlrptcached 99
- Run the diagnose report status to view currently pending reports.
-
If the problem persists and the reports have not stopped, run the following commands:
diagnose report status
diagnose report status pending
diagnose report status running
diagnose report clean report-queue
diagnose report status
