Active IQ Unified Manager 9.7 polling fails

Applies to

Active IQ Unified Manager 9.7

Issue

• Active IQ Unified Manager 9.7 does not show new data from clusters.
• In /var/log/ocum/ocumserver.log we see the following errors :

ERROR [oncommand] [org.springframework.jms.listener.DefaultMessageListenerContainer#0-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=15) Duplicate entry '1576218002482-1' for key 'PRIMARY'; nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=15) Duplicate entry '1576218002482-1' for key 'PRIMARY'

ERROR [oncommand] [pool-31-thread-1] [c.n.i.s.s.h.d.AggregateHeadroomStatDao] Exception while inserting statistics into netapp_performance.sample_opm_headroom_aggr_1
org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT INTO netapp_performance.sample_opm_headroom_aggr_1 (objid,time,`empty`,cOperationalPointAllWorkloads,cOperationalPointInternalWorkloads,isObservationBased,mConfidenceLevel,mOptimalPointLatency,mOptimalPointOps,mOptimalPointUtil,mcOptimalPointLatency,mcOptimalPointOps,mcOptimalPointUtil,oOperationalPointAllWorkloads,oOperationalPointInternalWorkloads,obConfidenceLevel,obOptimalPointLatency,obOptimalPointOps,obOptimalPointUtil,obcOptimalPointLatency,obcOptimalPointOps,obcOptimalPointUtil,serviceTime,cHRoomUsedPercent,cHRoomUsedNoInternalPercent,availableOps) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; (conn=15) Duplicate entry '17-1576218002482' for key 'PRIMARY'; nested exception is java.sql.BatchUpdateException: (conn=15) Duplicate entry '17-1576218002482' for key 'PRIMARY