10.0 analysis failure: "Sequence contains more than one matching element" error on profile search

petercli · June 2, 2023, 8:24am

Must-share information (formatted with Markdown):

which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
Recently upgrade to v10
how is SonarQube deployed: zip, Docker, Helm
Zip
what are you trying to achieve
Running quality checks from Azure DevOps
what have you tried so far to achieve this
It was working fine prior to a recent upgrade then without anything else changing we got the following error when trying to run code analysis from an Azure DevOps build
Do not share screenshots of logs – share the text itself (bonus points for being well-formatted)!

00:03:35.683  Fetching analysis configuration settings...
##[error]00:03:37.015  Failed to request and parse 'https://ourdomain/api/qualityprofiles/search?projectKey=ourproject': Sequence contains more than one matching element
00:03:37.015  Failed to request and parse 'https://ourdomain/api/qualityprofiles/search?projectKey=ourproject': Sequence contains more than one matching element

##[error]Unhandled Exception:
##[error]System.InvalidOperationException: Sequence contains more than one matching element
   at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
   at SonarScanner.MSBuild.PreProcessor.SonarWebService.<>c__DisplayClass6_0.<TryGetQualityProfile>b__0()
   at SonarScanner.MSBuild.PreProcessor.SonarWebService.DoLogExceptions[T](Func`1 op, String url, Action`1 onError)
   at SonarScanner.MSBuild.PreProcessor.SonarWebService.TryGetQualityProfile(String projectKey, String projectBranch, String organization, String language, String& qualityProfileKey)
   at SonarScanner.MSBuild.PreProcessor.TeamBuildPreProcessor.FetchArgumentsAndRulesets(ISonarQubeServer server, ProcessedArgs args, TeamBuildSettings settings, IDictionary`2& serverSettings, List`1& analyzersSettings)
   at SonarScanner.MSBuild.PreProcessor.TeamBuildPreProcessor.DoExecute(ProcessedArgs localSettings)
   at SonarScanner.MSBuild.BootstrapperClass.PreProcess()
   at SonarScanner.MSBuild.BootstrapperClass.Execute()
   at SonarScanner.MSBuild.Program.Execute(String[] args, ILogger logger)
   at SonarScanner.MSBuild.Program.Main(String[] args)
System.InvalidOperationException: Sequence contains more than one matching element
   at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
   at SonarScanner.MSBuild.PreProcessor.SonarWebService.<>c__DisplayClass6_0.<TryGetQualityProfile>b__0()
   at SonarScanner.MSBuild.PreProcessor.SonarWebService.DoLogExceptions[T](Func`1 op, String url, Action`1 onError)
   at SonarScanner.MSBuild.PreProcessor.SonarWebService.TryGetQualityProfile(String projectKey, String projectBranch, String organization, String language, String& qualityProfileKey)
   at SonarScanner.MSBuild.PreProcessor.TeamBuildPreProcessor.FetchArgumentsAndRulesets(ISonarQubeServer server, ProcessedArgs args, TeamBuildSettings settings, IDictionary`2& serverSettings, List`1& analyzersSettings)
   at SonarScanner.MSBuild.PreProcessor.TeamBuildPreProcessor.DoExecute(ProcessedArgs localSettings)
   at SonarScanner.MSBuild.BootstrapperClass.PreProcess()
   at SonarScanner.MSBuild.BootstrapperClass.Execute()
   at SonarScanner.MSBuild.Program.Execute(String[] args, ILogger logger)

##[error]The process 'D:\a\_tasks\SonarQubePrepare_15b84ca1-b62f-4a2a-a403-89b77a063157\4.11.0\classic-sonar-scanner-msbuild\SonarScanner.MSBuild.exe' failed with exit code 3762504530
Finishing: Prepare Analysis Configuration

petercli · June 2, 2023, 10:18am

Note that it seems a similar error to that described in the following issue which my reading of suggests there were multiple profiles for C# (one for .Net Core the other for .Net Framework) but that doesn’t seem to be the case for us unless mistaken

github.com/SonarSource/sonar-scanner-msbuild

Sequence contains more than one matching element exception when there's multiple profiles for a language

opened 07:41AM - 16 Nov 20 UTC

closed 03:56PM - 26 Feb 21 UTC

simonvandermeer

Type: Bug

### Description Last week someone in our organization installed the C# Sonar ….NET Core way in addition to the C# Sonar way we already had installed. Since then we started consistently getting the following exception in the Prepare Analysis Configuration Azure DevOps task. >Failed to request and parse 'http://.../api/qualityprofiles/search?project=...': Sequence contains more than one matching element With the following (partial) stacktrace: ``` ##[error]Unhandled Exception: ##[error]System.InvalidOperationException: Sequence contains more than one matching element at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source, Func`2 predicate) at SonarScanner.MSBuild.PreProcessor.SonarWebService.<>c__DisplayClass6_0.<<TryGetQualityProfile>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- ``` The request for quality profiles includes the following two profiles: ```json { "profiles": [ { "key": "cs-sonar-way-16701", "name": "Sonar way", "language": "cs", "languageName": "C#", "isInherited": false, "isDefault": true, "activeRuleCount": 143, "activeDeprecatedRuleCount": 0, "rulesUpdatedAt": "2017-06-23T08:34:07+0000", "lastUsed": "2020-11-10T17:48:00+0100", "userUpdatedAt": "2017-06-23T10:34:07+0200" }, { "key": "cs-sonar-way-net-core-23051", "name": "Sonar way .NET Core", "language": "cs", "languageName": "C#", "isInherited": false, "isDefault": false, "activeRuleCount": 142, "activeDeprecatedRuleCount": 0, "projectCount": 1, "rulesUpdatedAt": "2020-08-03T13:16:55+0000", "lastUsed": "2020-11-04T16:07:44+0100", "userUpdatedAt": "2020-08-03T15:16:55+0200" } ] } ``` The C# Sonar .NET Core way is only assigned to a single project which is not one we are analyzing so we expected it to just use the default C# profile which is the one which was already installed. ### Repro steps Please provide the steps required to reproduce the problem 1. Install two profiles for C#. 2. Run the Prepare Analysis Configuration Azure DevOps task on a C# project. ### Expected behavior Sonar scanner uses the profile which is assigned to that project or the default one. ### Actual behavior Sonar scanner throws an InvalidOperationException. ### Known workarounds None. ### Related information * SonarScanner for MSBuild version: 5.0.4 * SonarQube server version: 6.3.1 * Languages in your solution: C# * Azure DevOps task version: 4.17.0

jacek.poreda · June 7, 2023, 11:44am

Hello @petercli ,

Welcome to the community!

It seems like you are using an old .NET ms build scanner which is no longer compatible with current SQ version.

In the recent version of SonarQube 10.0, the deprecated parameter projectKey of this Web Service https://ourdomain/api/qualityprofiles/search?projectKey=ourproject has been dropped in favour of project.

Though latest version of scanner have it fixed. Could you please use the latest version of scanner? I believe it should resolve your issue.

Let me know if you have more questions.

Best,
Jacek

system · June 14, 2023, 11:44am

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.