BUG in Quality Gates in 7.9 LTS on Microsoft SQL

There is a bug in the latest version 7.9 LTS build 26994:

Steps to reproduce: Click on https://sonarqube.domain/quality_gates/show/2

2019.07.06 20:16:29 ERROR web[AWvC2JxiDb32Hg05AKCQ][o.s.s.w.WebServiceEngine] Fail to process request http://sonarqube-test.local/api/qualitygates/search?gateId=2&page=1&pageSize=100&selected=selected
Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ‘key’.
The error may exist in org.sonar.db.qualitygate.ProjectQgateAssociationMapper
The error may involve org.sonar.db.qualitygate.ProjectQgateAssociationMapper.selectProjects-Inline
The error occurred while setting parameters
SQL: SELECT proj.id as id, proj.kee as key, proj.name as name, prop.text_value as gateId FROM projects proj LEFT JOIN properties prop ON prop.resource_id=proj.id AND prop.prop_key=‘sonar.qualitygate’ AND prop.text_value = ? where proj.qualifier = ‘TRK’ and proj.enabled = 1 and proj.main_branch_project_uuid is null and proj.copy_component_uuid is null and proj.organization_uuid=? and prop.text_value IS NOT NULL order by proj.name
Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ‘key’.

Log: https://gist.github.com/jakobjs/5bea79dd24591bf6a670ce6859563d6d


From the log it seems to be a typo:

proj.kee as key

Thanks for the report! This is a known issue and should be fixed in v7.9.1 (coming early next week, from what I understand).

Thanks for the quick reply, good to hear.

Can you point me to the information online that makes this known to us users? :slight_smile: I have only seen the slow migrate warning for this version.

Nevermind, found it: 7.9 LTS Quality Gate search fails due to SQL query syntax error

Maybe you should update the release announcement or release notes/upgrade notes, I had not spotted this bug and would have delayed my upgrade if had been more clear.

Appreciate the feedback.

You can always check out https://jira.sonarsource.com to see known issues (and cool things to come), particularly in the SONAR project! :slight_smile:

I will do that in the future.

Thank you all for the info