Database maintenance fails at 2 AM each day. Errors similar to the following appear in the FMS log.
YYYY-MM-DD 02:00:00.006 VERBOSE [QuartzScheduler.PersistencePolicy_Worker-1] com.quest.nitro.service.persistence.management.DatabaseMaintenanceController - The ObservationRollup database maintenance operation started at MM/DD/YY 2:00 AM.
YYYY-MM-DD 02:00:00.008 INFO [IntelliProfile-Learn-pool-thread-165] com.quest.qsi.intelliProfile.learner.BlLearnManager - Initialize Learner properties
YYYY-MM-DD 02:00:02.098 VERBOSE [EventPublisher-0] Forward to SDE - Forward to SDE invoked
YYYY-MM-DD 02:00:04.189 ERROR [QuartzScheduler.PersistencePolicy_Worker-1] com.quest.nitro.service.persistence.management.DatabaseMaintenanceController - The ObservationRollup database maintenance operation has failed.
java.lang.RuntimeException: Terminating the rollup since 51 rollup batches have failed. Please investigate the cause of the failure.
at com.quest.nitro.service.persistence.RollupContext$BatchIterator.next(RollupContext.java:1188)
at com.quest.nitro.service.persistence.RollupContext$BatchIterator.next(RollupContext.java:1170)
Followed by entries similar to the following
YYYY-MM-DD 02:00:11.865 ERROR [QuartzScheduler.PersistencePolicy_Worker-1] com.quest.nitro.service.persistence.PersistenceService - An error has occurred while the MetricHandler observation handler was purging observations.
java.lang.RuntimeException: Rollup of long-term data failed.
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '170-0-1590994048604-20825736' for key 'PRIMARY'