Upgrade 7.3 to 7.4 using SQL Server

When upgrading from 7.2.1 to 7.4, the upgrade fails and the server stops with the error below.
A migration from 7.2 to 7.3 succeeded but the subsequent migration from 7.3 to 7.4 failed with the same error.

SonarQube is installed on Windows and using SQL Server Database.

The error message is:
ERROR web[o.s.s.p.Platform] Web server startup failed
java.lang.IllegalStateException: Can not check that table schema_migrations exists
at org.sonar.db.DatabaseUtils.wrapSqlException(DatabaseUtils.java:324)
at org.sonar.db.DatabaseUtils.doTableExists(DatabaseUtils.java:319)
at org.sonar.db.DatabaseUtils.tableExists(DatabaseUtils.java:290)
at org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl.start(MigrationHistoryTableImpl.java:44)

Greetings,

You might be facing SONAR-11443, where in 7.4 the database name accidentally became case sensitive.

Colin

2 Likes

Replaced:
sonar.jdbc.url=jdbc:sqlserver://server;databaseName=sonarqube;integratedSecurity=true

with
sonar.jdbc.url=jdbc:sqlserver://server;databaseName=SonarQube;integratedSecurity=true

in sonar.properties to the correct case as defined in the SQL Server.

1 Like