Hi, i try to upgrade from 8.9.10 LTS to 9.7.1 I got this DB Migration error , any hints? org.sonar.server.platform.db.migration.step.MigrationStepExecutionException: Execution of migration step #6006 'Drop 'user_managed' column from 'metrics' table' failed at org.sonar.server.platform.db.migratio…

After manually deleting the constraint - it does work ALTER TABLE dbo.metrics DROP CONSTRAINT DF__metrics__user_ma__084B3915; GO

Hello, Between 8.9 and 9.7, we dropped the column user_managed from the metrics table. This process is handled automatically by SonarQube and in the case of Microsoft SQL server, we need to drop constraints of the column before. This is done by introspecting the schema to find the default constrain…

[image] Steve Marion: SELECT d.name FROM sys.tables t JOIN sys.default_constraints d ON d.parent_object_id = t.object_id JOIN sys.columns c ON c.object_id = t.object_id AND c.column_id = d.parent_column_id WHERE t.name = 'metrics' AND c.name in ('user_managed'); Hi , I ran the query an i go…

The SQL Server Version is Microsoft SQL Server 12.00.816

Migration error when upgrading to 9.7.1

SonarQube Server / Community Build

pierreguillot (Pierre Guillot) February 28, 2023, 9:40am 10

We identified the issue, more details in this post.

Topic		Replies	Views
DB Migration issues during Upgrade from 8.9.10 LTS to 9.9 LTS SonarQube Server / Community Build database , mssql , migration	3	1406	February 28, 2023
SonarQube does not start after update - ERROR web[][DbMigrations] #6006 'Drop 'user_managed' column SonarQube Server / Community Build migration	3	819	March 29, 2023
9.5 to 9.6 MS SQL DB upgrade error [SOLVED] SonarQube Server / Community Build sonarqube , upgrade	3	504	August 19, 2022
Possible db migration error when updating to Sonarqube Enterprise 9.8.0 with MSSQL SonarQube Server / Community Build sonarqube , bug	3	1335	February 6, 2023
Upgrade 9.5 to 9.8 / 9.9 SonarQube Server / Community Build migration	15	1391	May 26, 2023

Migration error when upgrading to 9.7.1

Related topics