AIQUM升级失败、并显示错误"对UM执行数据库创建命令失败"

最后更新
另存为PDF

Views:: 2

Visibility:: Public

Votes:: 0

Category:: active-iq-unified-manager

Specialty:: om

Last Updated:

适用场景

ActiveIQ Unified Manager (AIQUM) 9.14.
Windows平台

问题描述

将AIQUM Windows从9.12升级到9.13失败、并显示以下错误。

Database creation command failed for UM.Installer will exit now. Refer logs for more details

在NetApp Data\ocum\log\dbsetup.log中观察到以下错误

INFO  [main] [c.n.d.m.MigrationsManager] MIGRATIONS_INITIALIZING_DATABASE_START [21.005, 23.001, jdbc:mysql://localhost:3306/ocum?cachePre...atements=true]

ERROR [main] [c.n.dfm.migrations.DbMain] Unexpected error: StatementCallback; bad SQL grammar [CREATE TABLE IdpServerDetails( uuid VARCHAR(36) NOT NULL, objVersion integer NOT NULL, useLocalRoles bit NOT NULL, idpName VARCHAR(255) NOT NULL, idpUri VARCHAR(255) NOT NULL, clientId VARCHAR(255) , clientSecret VARCHAR(255) , remoteUserClaim VARCHAR(255) NOT NULL, validationMethod VARCHAR(255) NOT NULL, introspectionEndpoint VARCHAR(255) , introspectionEndpointParams VARCHAR(255) , introspectionAuthenticationMethod VARCHAR(255) , jwksLocation VARCHAR(255) , jwksRefreshIntervalSeconds integer, CONSTRAINT IdpServerDetails_PK PRIMARY KEY (uuid), CONSTRAINT IdpServerDetails_name_UQ UNIQUE (idpName) )]; nested exception is java.sql.SQLSyntaxErrorException: (conn=12) Table 'idpserverdetails' already exists

DEBUG [main] [c.n.dfm.migrations.DbMain] Database setup error

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [CREATE TABLE IdpServerDetails( uuid VARCHAR(36) NOT NULL, objVersion integer NOT NULL, useLocalRoles bit NOT NULL, idpName VARCHAR(255) NOT NULL, idpUri VARCHAR(255) NOT NULL, clientId VARCHAR(255) , clientSecret VARCHAR(255) , remoteUserClaim VARCHAR(255) NOT NULL, validationMethod VARCHAR(255) NOT NULL, introspectionEndpoint VARCHAR(255) , introspectionEndpointParams VARCHAR(255) , introspectionAuthenticationMethod VARCHAR(255) , jwksLocation VARCHAR(255) , jwksRefreshIntervalSeconds integer, CONSTRAINT IdpServerDetails_PK PRIMARY KEY (uuid), CONSTRAINT IdpServerDetails_name_UQ UNIQUE (idpName) )]; nested exception is java.sql.SQLSyntaxErrorException: (conn=12) Table 'idpserverdetails' already exists

        at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:93)

Caused by: java.sql.SQLSyntaxErrorException: (conn=12) Table 'idpserverdetails' already exists