The time taken to login to Foglight is very slow and the longer the FMS is up and running.
The following errors appear in the FMS log:
com.quest.nitro.service.persistence.obs.storage.StorageManagerService - Failed to check storage for the Binary handler.
java.lang.RuntimeException: Attempt to change table state failed.
Caused by: java.sql.BatchUpdateException: ORA-02292: integrity constraint (FGLADMIN.XXXXXXXXXX) violated - child record found
Observation timeslices in the storage configuration can contain temporary table objects that are used during the rollup operations. The temporary tables should be removed when the operation has completed but could potentially remain.
Issue fixed in version 5.5.4. The latest version of Foglight can be downloaded at: https://support.quest.com/foglight/download-new-releases