UMでのAIQUM Windowsの9.12から9.13へのアップグレードが失敗し、データベース作成コマンドが失敗する
環境
- 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)