AIQUM failed to discover cluster due to future dates due to Incorrect datetime value for ZAPI calls
Applies to
- ActiveIQ Unified Manager (AIQUM) 9.6+
- OnCommand Unified manager (OCUM) 9.5 and below
- All OS versions
- ZAPI calls
Issue
- Cluster acquisition failed in AIQUM
server_mega.log:
2023-03-08 09:52:44,929 ERROR [default task-372] c.n.s.s.a.OriginatorUpdateServlet (OriginatorUpdateServlet.java:109) - Failed to get update server with the xml, originator 5: com.netapp.oci.server.UpdateTaskException [127-62-34-1674]Failed to get update server with the xml, originator 5com.netapp.oci.server.UpdateTaskException [127-62-34-1674]Failed execute task: class com.netapp.oci.platform.originator.OriginatorUpdateTaskcom.netapp.oci.server.UpdateTaskException [127-62-34-1674]Failed to run NewOriginatorUpdateTask, origin:5 originatorName:10.10.32.45com.netapp.oci.platform.common.table.TableException: Failed to execUpdate: com.netapp.oci.platform.originator.db.InsertOperation@5559013b after 10 retriesat 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)....Caused by: java.sql.SQLSyntaxErrorException: (conn=129) Incorrect datetime value: '2106-02-07 06:28:15' for column 'sisLastOpBeginTimestamp' at row 1at org.mariadb//org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)at org.mariadb//org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)