How can we help you today? How can we help you today?
steveb
Activity overview Badges (0) Posts (0) Comments (5)

Activity overview

Latest activity by steveb

OK - worse than I thought. Now my installation of SCA in VS2019 (which I was retaining just for using SCA) has gone and trying to install the latest for 2019 fails with the same problem as for VS2022. Looks like a general change to the installer. Now unable to use SCA at all.  [image] / comments
  1. Community
  2. SQL Change Automation
  3. Will SCA support Visual Studio 2022
OK - worse than I thought. Now my installation of SCA in VS2019 (which I was retaining just for using SCA) has gone and trying to install the latest for 2019 fails with the same problem as for VS20...
0 votes
Sadly the install fails for me as I have to use an admin account with no internet access. The installer fails trying to download the package 'Microsoft.VisualStudio.Debugger.DbgHelp.Win8'.  [image] Any workaround? Steve Install Error : System.AggregateException: One or more errors occurred. ---> Microsoft.VisualStudio.Setup.PackageFailureException: Package 'Microsoft.VisualStudio.Debugger.DbgHelp.Win8' failed to download;Package 'Microsoft.VisualStudio.Debugger.Remote.DbgHelp.Win8' failed to download    at Microsoft.VisualStudio.Setup.InstallOperation.Run(CancellationToken token)    at Microsoft.VisualStudio.Setup.Engine.RunOperation(InstallOperation installOperation, CancellationToken token, ExecuteAction action, ITelemetryOperation telemetryOperation)    at Microsoft.VisualStudio.Setup.Engine.RunCoreOperation(InstallOperation coreOperation, ExecuteAction action, ITelemetryOperation telemetryOperation, CancellationToken token)    at Microsoft.VisualStudio.Setup.Engine.Install(Product product, String destination, CancellationToken token)    at Microsoft.VisualStudio.ExtensionManager.SetupEngineService.<Install>b__14_0()    at System.Threading.Tasks.Task`1.InnerInvoke()    at System.Threading.Tasks.Task.Execute()    --- End of inner exception stack trace ---    at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)    at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)    at Microsoft.VisualStudio.ExtensionManager.SetupEngineService.Install()    at Microsoft.VisualStudio.ExtensionManager.ExtensionEngineImpl.PerformSetupEngineInstall(InstallableExtensionImpl extension, Boolean installPerMachine, Boolean isPackComponent, IDictionary`2 extensionsInstalledSoFar, List`1 extensionsUninstalledSoFar, IInstalledExtensionList modifiedInstalledExtensionsList, IProgress`1 progress, InstallFlags installFlags, AsyncOperation asyncOp, Version targetedVsVersion, IInstalledExtension& newExtension)    at Microsoft.VisualStudio.ExtensionManager.ExtensionEngineImpl.InstallInternal(InstallableExtensionImpl extension, InstallFlags installFlags, IDictionary`2 extensionsInstalledSoFar, List`1 extensionsUninstalledSoFar, IInstalledExtensionList modifiedInstalledExtensionsList, AsyncOperation asyncOp, IProgress`1 progress, Version targetedVsVersion)    at Microsoft.VisualStudio.ExtensionManager.ExtensionEngineImpl.BeginInstall(IInstallableExtension installableExtension, InstallFlags installFlags, AsyncOperation asyncOp, Version targetedVsVersion)    at Microsoft.VisualStudio.ExtensionManager.ExtensionEngineImpl.InstallWorker(IInstallableExtension extension, InstallFlags installFlags, AsyncOperation asyncOp) ---> (Inner Exception #0) Microsoft.VisualStudio.Setup.PackageFailureException: Package 'Microsoft.VisualStudio.Debugger.DbgHelp.Win8' failed to download;Package 'Microsoft.VisualStudio.Debugger.Remote.DbgHelp.Win8' failed to download    at Microsoft.VisualStudio.Setup.InstallOperation.Run(CancellationToken token)    at Microsoft.VisualStudio.Setup.Engine.RunOperation(InstallOperation installOperation, CancellationToken token, ExecuteAction action, ITelemetryOperation telemetryOperation)    at Microsoft.VisualStudio.Setup.Engine.RunCoreOperation(InstallOperation coreOperation, ExecuteAction action, ITelemetryOperation telemetryOperation, CancellationToken token)    at Microsoft.VisualStudio.Setup.Engine.Install(Product product, String destination, CancellationToken token)    at Microsoft.VisualStudio.ExtensionManager.SetupEngineService.<Install>b__14_0()    at System.Threading.Tasks.Task`1.InnerInvoke()    at System.Threading.Tasks.Task.Execute()<--- / comments
  1. Community
  2. SQL Change Automation
  3. Will SCA support Visual Studio 2022
Sadly the install fails for me as I have to use an admin account with no internet access. The installer fails trying to download the package 'Microsoft.VisualStudio.Debugger.DbgHelp.Win8'.  Any wor...
0 votes
Hi Dan, Yes - that would be good. Many thanks. Steve. / comments
  1. Community
  2. SQL Source Control
  3. SQL Change Automation - error when doing refresh - Sequence contains no matching element
Hi Dan,Yes - that would be good. Many thanks.Steve.
0 votes
Hi Dan, Thanks for the info. My solution consists of a CLR assembly project and 3 SCA projects which reference the CLR project. All are set to use the same version of .NET framework (4.6.2, but I've tried others!). I seem to be able to deploy the databases to my local SQL server initially, but then the error occurs once the deployment has finished and the the SCA window is trying to refresh to show the new comparison of the project with the deployed DB. [There are also 2 other SCA projects in the solution which don't reference the CLR project, and they are fine.] My error (see below) is almost exactly the same as the OP's. Steve Message = Sequence contains no matching element Data = System.Collections.ListDictionaryInternal InnerException = TargetSite = TSource Single[TSource](System.Collections.Generic.IEnumerable`1[TSource], System.Func`2[TSource,System.Boolean]) StackTrace = at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate) at RedGate.Versioning.Client.VsShell.VisualStudio.ShellIntegration.VsDteProjectLocator.GetDteProjectFromPath(String filePath) at RedGate.Versioning.Client.VsShell.VisualStudio.ShellIntegration.VsDteProjectLocator.GetSsdtProjectFromPath(String filePath) at RedGate.Versioning.Client.VsShell.VisualStudio.Settings.SsdtProjectSettingsStrategy..ctor(IDteProjectLocator projectLocator, String filePath) at RedGate.Versioning.Client.VsShell.VisualStudio.Settings.SsdtProjectSettingsStrategyFactory.GetSettingsStrategy(String filePath) at RedGate.Versioning.Engine.Projects.ProjectSettings.SqlProj.ObjectMapping.MsBuildProjectMapper.MapTo(String filePath, IMsBuildSettingsRepresentation msBuildDatabaseProjectSettings) at RedGate.Versioning.Engine.Projects.ProjectSettings.SqlProj.ObjectMapping.MsBuildSettingsLoader`2.LoadSettings(String filePath, IProgressLogger progress) at RedGate.Versioning.Client.VsShell.VisualStudio.PendingChangeModel.d__87.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.Versioning.Client.VsShell.VisualStudio.PendingChangeModel.d__81.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RedGate.Versioning.Client.VsShell.VisualStudio.Commands.RefreshCommand.d__10.MoveNext() HelpLink = Source = System.Core HResult = -2146233079 / comments
  1. Community
  2. SQL Source Control
  3. SQL Change Automation - error when doing refresh - Sequence contains no matching element
Hi Dan,Thanks for the info. My solution consists of a CLR assembly project and 3 SCA projects which reference the CLR project. All are set to use the same version of .NET framework (4.6.2, but I've...
0 votes
Hi, Was a solution found to this problem? I'm getting the same error and stack trace on VS2019 Enterprise 16.7.4 and SQL Change Automation 4.3.20288.22634. Thanks, Steve. / comments
  1. Community
  2. SQL Source Control
  3. SQL Change Automation - error when doing refresh - Sequence contains no matching element
Hi,Was a solution found to this problem? I'm getting the same error and stack trace on VS2019 Enterprise 16.7.4 and SQL Change Automation 4.3.20288.22634.Thanks,Steve.
0 votes
Total activity
7
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2