将AIQUM Windows从9.12升级到9.13失败、并对UM执行数据库创建命令失败
适用场景
- ActiveIQ 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)