When purging old data from the "Data Management" dashboard, it does not appear to do anything.
The following error is seen in the FMS logs:
[[StorageManagerQuartzScheduler_Worker-2] com.quest.nitro.service.persistence.obs.storage.StorageManagerService - Failed to check storage for the AggregateMetric handler.
java.lang.RuntimeException: Attempt to change table state failed.
Caused by: java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`foglight/persistence_obs_temp_table`, CONSTRAINT `FK9D1EF5E2B4A62393` FOREIGN KEY (`pott_timeslice_id`) REFERENCES `persistence_obs_timeslice` (`pot_id`))
The aggregate metric handler is encountering errors, when attempting to remove time slices, because there are still temporary tables attached, that are not being deleted automatically
- Go to the Foglight JMX console: