After upgrading DevTest to 10.7.2, IAM is not starting.

Products

• Service Virtualization

Issue/Introduction

10.7.2 DevTest was installed over the existing 10.6 installation.
But the IAM (Identity and Access Manager) service stopped shortly after being started. 

The following errors were found in the IAM server.log file: 
ERROR [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0230: Vault is not initialized; resolution of vault expressions is not possible

ERROR [org.keycloak.connections.jpa.updater.liquibase.conn.DefaultLiquibaseConnectionProvider] (ServerService Thread Pool -- 54) Change Set META-INF/jpa-changelog-1.0.0.Final.xml::1.0.0.Final::[email protected] failed.  Error: Can't write; duplicate key in table '#sql-2935_14' [Failed SQL: ALTER TABLE iamdatabase.CLIENT_SESSION_ROLE ADD CONSTRAINT FK_11B7SGQW18I532811V7O2DV76 FOREIGN KEY (CLIENT_SESSION) REFERENCES iamdatabase.CLIENT_SESSION (ID)]: liquibase.exception.DatabaseException: Can't write; duplicate key in table '#sql-2935_14' [Failed SQL: ALTER TABLE iamdatabase.CLIENT_SESSION_ROLE ADD CONSTRAINT FK_11B7SGQW18I532811V7O2DV76 FOREIGN KEY (CLIENT_SESSION) REFERENCES iamdatabase.CLIENT_SESSION (ID)]

Environment

Release : 10.7.2

Resolution

The error "Vault is not initialized; resolution of vault expressions is not possible" at the start of the server.log can be ignored.

The "ALTER TABLE" error was resolved by restoring the database to an earlier backup. The environment was configured with an automatic reinstall of DevTest 10.6. Switching between 10.6 and 10.7.2 probably caused this error.