I reran the update again and this time watched the Azure LogStream from and actually saw the error message (for some reason I did not see this error when logging back at the logs as opposed to watching ‘live’)
2023-01-19T09:21:37.312570884Z: [INFO] 2023.01.19 09:21:37 INFO web[o.s.s.p.d.m.DatabaseMigrationImpl] Starting DB Migration and container restart
…
2023-01-19T09:24:12.599097580Z: [INFO] 2023.01.19 09:24:12 INFO web[DbMigrations] #6703 ‘Drop project measure variation column’…
2023-01-19T09:24:12.635942690Z: [INFO] 2023.01.19 09:24:12 ERROR web[DbMigrations] #6703 ‘Drop project measure variation column’: failure | time=40ms
2023-01-19T09:24:12.636717705Z: [INFO] 2023.01.19 09:24:12 ERROR web[DbMigrations] Executed DB migrations: failure | time=155226ms
2023-01-19T09:24:12.645227469Z: [INFO] 2023.01.19 09:24:12 ERROR web[o.s.s.p.d.m.DatabaseMigrationImpl] DB migration failed | time=155334ms
2023-01-19T09:24:12.653407627Z: [INFO] 2023.01.19 09:24:12 ERROR web[o.s.s.p.d.m.DatabaseMigrationImpl] DB migration ended with an exception
2023-01-19T09:24:12.654044139Z: [INFO] org.sonar.server.platform.db.migration.step.MigrationStepExecutionException: Execution of migration step #6703 ‘Drop project measure variation column’ failed
No I see the error message, I see this has already been reported Possible db migration error when updating to Sonarqube Enterprise 9.8.0 with MSSQL - SonarQube - Sonar Community (sonarsource.com), and it is supposedly fixed in 9.9