Be the star of a SQL Prompt case study. Learn more.

Unable to use in Visual Studio 2022 Any solution for this?

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: &apos;RedGate.SqlPrompt.VsPackage2022&apos; Description: Could not load file or assembly &apos;Microsoft.VisualStudio.Threading, Version=17.2.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a&apos; or one of its dependencies. The system cannot find the file specified.&#x000D;&#x000A;System.IO.FileNotFoundException: Could not load file or assembly &apos;Microsoft.VisualStudio.Threading, Version=17.2.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a&apos; or one of its dependencies. The system cannot find the file specified.&#x000D;&#x000A;File name: &apos;Microsoft.VisualStudio.Threading, Version=17.2.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a&apos;&#x000D;&#x000A;   at RedGate.SqlPrompt.VsPackage.SQLPromptPackage.InitializeAsync(CancellationToken cancellationToken, IProgress`1 progress)&#x000D;&#x000A;   at Microsoft.VisualStudio.Shell.AsyncPackage.&lt;&gt;c__DisplayClass20_0.&lt;&lt;Microsoft-VisualStudio-Shell-Interop-IAsyncLoadablePackageInitialize-Initialize&gt;b__1&gt;d.MoveNext()&#x000D;&#x000A;--- End of stack trace from previous location where exception was thrown ---&#x000D;&#x000A;   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()&#x000D;&#x000A;   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)&#x000D;&#x000A;   at Microsoft.VisualStudio.Threading.JoinableTask.&lt;JoinAsync&gt;d__76.MoveNext()&#x000D;&#x000A;--- End of stack trace from previous location where exception was thrown ---&#x000D;&#x000A;   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()&#x000D;&#x000A;   at Microsoft.VisualStudio.Services.VsTask.RethrowException(AggregateException e)&#x000D;&#x000A;   at Microsoft.VisualStudio.Services.VsTask.InternalGetResult(Boolean ignoreUIThreadCheck)&#x000D;&#x000A;&#x000D;&#x000A;WRN: Assembly binding logging is turned OFF.&#x000D;&#x000A;To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.&#x000D;&#x000A;Note: There is some performance penalty associated with assembly bind failure logging.&#x000D;&#x000A;To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].&#x000D;&#x000A;</description>
    <guid>{A2B70F9A-F164-4D38-9D96-9C87B1582BF2}</guid>
    <hr>80070002</hr>
    <errorinfo></errorinfo>

Best Answer

  • thilehofferthilehoffer Posts: 2 New member
    edited August 10, 2022 9:11PM Answer ✓
    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

  • Hi there,

    Thank you for reaching out and I apologize that you are running into issues with SQL Prompt.

    Can I ask what version of Visual Studio and SQL Prompt you are running?

    Kind Regards,
    David Kim
    Product Support Engineer
Sign In or Register to comment.