Active IQ Unified Manager shows less than 72 hours worth of data despite successfully polling
Applies to
- Active IQ Unified Manager (AIQUM) 9.6+
- OnCommand Unified Manager (OCUM) 6.x +
Issue
- Unified Manager will show less than 72 hours worth of data in the default 72 hour performance views.
- Data previously shown within the last 72 hours will appear to roll off.
1-07-07 16:57:00,150 ERROR [oncommand] [org.springframework.jms.listener.DefaultMessageListenerContainer#2-1] [c.n.i.s.r.dao.AcquisitionInfoDao] Data Acquistion Save exception: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT INTO opm.acquisition_info (time,success,clusterId,analysisDuration,collectionDuration,msgRcvTime,isHistorical) VALUES (?,?,?,?,?,?,?)]; (conn=19056) Duplicate entry '1625690077171-9342' for key 'acquisition_info.PRIMARY'; nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=19056) Duplicate entry '1625690077171-9342' for key 'acquisition_info.PRIMARY' at deployment.dfm-app.war//org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:242)