Unable to use in Visual Studio 2022 Any solution for this?
thilehoffer
Posts: 2 New member
in SQL Prompt
From the log file
<record>2879</record>
<time>2022/08/09 15:04:40.974</time>
<type>Error</type>
<source>VisualStudio</source>
<description>SetSite failed for package [SQLPromptPackage]Source: 'RedGate.SqlPrompt.VsPackage2022' Description: Could not load file or assembly 'Microsoft.VisualStudio.Threading, Version=17.2.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.VisualStudio.Threading, Version=17.2.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.VisualStudio.Threading, Version=17.2.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'
 at RedGate.SqlPrompt.VsPackage.SQLPromptPackage.InitializeAsync(CancellationToken cancellationToken, IProgress`1 progress)
 at Microsoft.VisualStudio.Shell.AsyncPackage.<>c__DisplayClass20_0.<<Microsoft-VisualStudio-Shell-Interop-IAsyncLoadablePackageInitialize-Initialize>b__1>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
 at Microsoft.VisualStudio.Threading.JoinableTask.<JoinAsync>d__76.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
 at Microsoft.VisualStudio.Services.VsTask.RethrowException(AggregateException e)
 at Microsoft.VisualStudio.Services.VsTask.InternalGetResult(Boolean ignoreUIThreadCheck)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
</description>
<guid>{A2B70F9A-F164-4D38-9D96-9C87B1582BF2}</guid>
<hr>80070002</hr>
<errorinfo></errorinfo>
Tagged:
Best Answer
-
thilehoffer
Posts: 2 New member
Hey dkim, I put in a ticket with support and this was solved. I deleted the contents %localappdata%\Microsoft\VisualStudio\17_xxxx\ComponentModelCache then I updated Visual Studio to 17.3.0 and it started working again.
Answers