Skip to main content
NetApp Knowledge Base

Active IQ Unified Manager 9.7 polling fails

Views:
407
Visibility:
Public
Votes:
0
Category:
oncommand-unified-manager
Specialty:
om
Last Updated:

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

 

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device