将 AIQUM Windows 从 9.12 升级到 9.13 失败，出现 UM 数据库创建命令失败错误
适用于
- Active IQ Unified Manager (AIQUM) 9.12
- Windows 平台
问题
- 将 AIQUM Windows 从 9.12 升级到 9.13 失败
- 错误：
Database creation command failed for UM.Installer will exit now. Refer logs for more details
C:\ProgramData\NetApp\OnCommandAppData\ocum\log\dbsetup.log：
ERROR [main] [c.n.dfm.migrations.DbMain] Unexpected error: StatementCallback; SQL [ALTER TABLE ocum.alert_script_audit MODIFY snmpDestination VARCHAR(512)]; (conn=12) Cannot add or update a child row: a foreign key constraint fails (`ocum`.`#sql-2b6c_c`, CONSTRAINT `alert_script_audit_eventId_FK` FOREIGN KEY (`eventId`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=12) Cannot add or update a child row: a foreign key constraint fails (`ocum`.`#sql-2b6c_c`, CONSTRAINT `alert_script_audit_eventId_FK` FOREIGN KEY (`eventId`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT)DEBUG [main] [c.n.dfm.migrations.DbMain] Database setup error...
...
Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=12) Cannot add or update a child row: a foreign key constraint fails (`ocum`.`#sql-2b6c_c`, CONSTRAINT `alert_script_audit_eventId_FK` FOREIGN KEY (`eventId`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT)