AIQUM fails to add cluster due to stale vserver peer in ONTAP
Applies to
- Active IQ Unified Manager (AIQUM)
- ONTAP 9
Issue
- AIQUM fails to add an ONTAP cluster with error:
server_mega.logindicates that AIQUM fails to insert data into tablenetapp_model.vserver_peer
ERROR [default task-5028] c.n.o.p.o.db (AbstractBatchOperation.java:120) -
retry 10 for originId 3 for sql INSERT INTO netapp_model.vserver_peer
(objid,originid,uuid,resourcekey,clusterid,vserverid,peervserveruuid,
peerclustername,peervservername,peerstate,peerstateraw,applications,
checksum,changeDetailChecksum,createtime,updatetime,objState) VALUES
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'LIVE') with error (conn=2794)
Column 'vServerId' cannot be null
ERROR [default task-5028] c.o.s.s.sessions (UpdateTaskExecuteSessionImpl.java:27) -
Fail execute task com.netapp.oci.platform.originator.OriginatorUpdateTask:
com.netapp.oci.server.UpdateTaskException [127-70-34-1674]
Failed to run NewOriginatorUpdateTask, origin:3 originatorName:XXX.XXX.XXX.XXX
com.netapp.oci.platform.common.table.TableException:
Failed to execUpdate: com.netapp.oci.platform.originator.db.InsertOperation@f045fae after 10 retries
at deployment.mega-app.ear.server-core.jar//com.netapp.oci.platform.originator.db.AbstractBatchOperation.execute(AbstractBatchOperation.java:127)
at deployment.mega-app.ear.server-core.jar//com.netapp.oci.platform.originator.OriginatorUpdate.submitWithoutRunner(OriginatorUpdate.java:916)
:
at org.jboss.xnio@3.8.5.Final//org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1280)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=2794) Column 'vServerId' cannot be null
at org.mariadb//org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:70)