Db Migration Fails When Upgrading Sonarqube from 9.2 to 9.7

Hello Community,

We are trying to upgrade Sonarqube from 9.2 to 9.7. When we start the upgrade from http://sonar/setup address, it fails in the db migration step. Logs indicates, “Fix usage of deprecated column in MSSQL”. But it does not gives any clue which column generates this error. Even when we use the trace level logging. How can we solve this problem? Thank you for the help.

image

Hi,
Looks like the column is named “BinaryData”.
I don’t think this column is part of any table created by sonarqube, so you probably have other tables in the database used by sonarqube.

1 Like

Hello,
Thanks for the suggestion. We found the column and deleted it. But we are started to getting another problem. After completing the Db migration step, sonarqube failed and stopped the service. Now, the service is not starting at all. I added the logs to txt file. Can you help us with this?
sonarlog.txt (3.3 KB)

Do you encounter the error every time you start the application?
Looks like it’s related to elasticsearch but it’s impossible to tell what it is exactly based on the logs.