Why am I getting the error, "You can not initiate live-update of this report at this time because report generation has already been initiated by a different process"?
One of my reports failed to update earlier today. When looking at the Run History, I see the following error for each time the data collection trigger ran:
Updating Report 50's failed. You can not initiate live-update of this report at this time because report generation has already been initiated by a different process.
I then tried to update my report manually by clicking the Update Live Report button but that also shows the same error. What's going on? And where do I find this "different process"?
The error is saying that your report basically never finished during the initial data collection. This rarely happens, and in most cases the data collection is finished or aborted. When it does happen, you have to fix the stuck report directly in the databse. To fix, please follow the steps below (you will need ssh access to the Metric Insights server):
1. SSH to the Metrc Insights server
2. At the command line enter: mysql dashboard (note, if the system database has been renamed previously, replace dashboard with the actual name)
3. Enter the following mysql statement: delete from generator_lock;
4. You should be able to manually update your report now by clicking Update Live Report in the Report Editor. If it's still stuck, please contact firstname.lastname@example.org.