Why am I getting a "Updating Report failed. You can not initiate live-update of this report at this time because report generation has already been initiated by a different process" error?
I see the following error during the most recent data collection trigger run for a report. When attempting to collect the data manually, I am getting the same error:
Updating Report failed. You can not initiate live-update of this report at this time because report generation has already been initiated by a different process.
What does this mean and why is this happening?
This error is caused by a hanging data collection thread for that report. Normally, the thread closes upon completion, but this error indicates the thread is still open. Therefore, any subsequent data collection attempts, whether through the trigger or a manual collection, is prevented from executing to prevent data duplication.
Please follow the steps below to end the running thread:
1.) SSH to the Metric Insights server with "root" privileges.
2.) Run the following command to search for running processes:
ps -ef | grep report_generator
The output lists the PID (second column) and the element ID (number listed after report_generator.py)
In this example, the PID is 18081 and the element ID for the report is 1844.
3.) Run following command to kill the running process in question by referencing the PID:
Killing this long running thread allows the system to complete the data collection and automatically update the database. You should see a completion time in the report's Run History and you can proceed with running data collection again. For any additional questions, please contact firstname.lastname@example.org.