Error loading package

tschlichtschlich Posts: 5 Bronze 1
in SQL Test
I am on SSMS 19.1.56.0 and SQL Test 4.1

SQL Test errors upon load of SSMS and the plugin is not able to load

Here is the error from the activity logs:

<div>&nbsp;<entry></div><div>&nbsp; &nbsp; <record>299</record></div><div>&nbsp; &nbsp; <time>2023/08/02 21:32:52.203</time></div><div>&nbsp; &nbsp; <type>Information</type></div><div>&nbsp; &nbsp; <source>VisualStudio</source></div><div>&nbsp; &nbsp; <description>Begin package load [SQLTestSSMSPackage]</description></div><div>&nbsp; &nbsp; <guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid></div><div>&nbsp; </entry></div><div>&nbsp; <entry></div><div>&nbsp; &nbsp; <record>300</record></div><div>&nbsp; &nbsp; <time>2023/08/02 21:32:52.211</time></div><div>&nbsp; &nbsp; <type>Error</type></div><div>&nbsp; &nbsp; <source>VisualStudio</source></div><div>&nbsp; &nbsp; <description>LegacySitePackage failed for package [SQLTestSSMSPackage]Source: &apos;RedGate.SQLTest.SSMS.19&apos; Description: Could not load file or assembly &apos;RedGate.SQLTest.Shell, Version=4.1.4.2200, Culture=neutral, PublicKeyToken=7f465a1c156d4d57&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;RedGate.SQLTest.Shell, Version=4.1.4.2200, Culture=neutral, PublicKeyToken=7f465a1c156d4d57&apos; or one of its dependencies. The system cannot find the file specified.&#x000D;&#x000A;File name: &apos;RedGate.SQLTest.Shell, Version=4.1.4.2200, Culture=neutral, PublicKeyToken=7f465a1c156d4d57&apos;&#x000D;&#x000A; &nbsp; at RedGate.SQLTest.SSMSPackage.SQLTestSSMSPackage.Initialize()&#x000D;&#x000A; &nbsp; at Microsoft.VisualStudio.Shell.Package.Microsoft.VisualStudio.Shell.Interop.IVsPackage.SetSite(IServiceProvider sp)&#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></div><div>&nbsp; &nbsp; <guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid></div><div>&nbsp; &nbsp; <hr>80070002</hr></div><div>&nbsp; &nbsp; <errorinfo></errorinfo></div><div>&nbsp; </entry></div>
· Share on Twitter

Answers

  • SpiralSpiral Posts: 1 New member
    edited September 26, 2023 11:31AM
    I'm having the same issue. I have 2 instances on my local server. 
    1. Default:
      Microsoft SQL Server 2019 (RTM-CU22) (KB5027702) - 15.0.4322.2 (X64)   Jul 27 2023 18:11:00   Copyright (C) 2019 Microsoft Corporation  Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 19045: ) (Hypervisor) 

    2. Microsoft SQL Server 2022 (RTM-CU7) (KB5028743) - 16.0.4065.3 (X64)   Jul 25 2023 18:03:43   Copyright (C) 2022 Microsoft Corporation  Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 19045: ) (Hypervisor) 

    When I click the "SQL Test" icon I get this error :

    The ActivityLog.xml shows:

    <entry>
        <record>407</record>
        <time>2023/09/26 11:22:04.736</time>
        <type>Information</type>
        <source>VisualStudio</source>
        <description>Entering function CVsPackageInfo::HrInstantiatePackage</description>
        <guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid>
      </entry>
      <entry>
        <record>408</record>
        <time>2023/09/26 11:22:04.737</time>
        <type>Information</type>
        <source>VisualStudio</source>
        <description>Begin package load [SQLTestSSMSPackage]</description>
        <guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid>
      </entry>
      <entry>
        <record>409</record>
        <time>2023/09/26 11:22:04.739</time>
        <type>Error</type>
        <source>VisualStudio</source>
        <description>LegacySitePackage failed for package [SQLTestSSMSPackage]Source: &apos;RedGate.SQLTest.Shell.19&apos; Description: Could not load file or assembly &apos;Microsoft.SqlServer.Management.SDK.SqlStudio, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91&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.SqlServer.Management.SDK.SqlStudio, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91&apos; or one of its dependencies. The system cannot find the file specified.&#x000D;&#x000A;File name: &apos;Microsoft.SqlServer.Management.SDK.SqlStudio, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91&apos;&#x000D;&#x000A;   at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus.HookUpEvents(DTE2 application)&#x000D;&#x000A;   at RedGate.SQLTest.Shell.SsmsFunctionalityProvider.Initialize(DTE2 dte)&#x000D;&#x000A;   at RedGate.SQLTest.Shell.SsmsFunctionalityProvider..ctor(DTE2 dte, WrappingFactory wrappingFactory)&#x000D;&#x000A;   at RedGate.SQLTest.Shell.AddinLoader..ctor(DTE2 dte, ILog log)&#x000D;&#x000A;   at RedGate.SQLTest.SSMSPackage.SQLTestSSMSPackage.Initialize()&#x000D;&#x000A;   at Microsoft.VisualStudio.Shell.Package.Microsoft.VisualStudio.Shell.Interop.IVsPackage.SetSite(IServiceProvider sp)&#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>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid>
        <hr>80070002</hr>
        <errorinfo></errorinfo>
      </entry>
      <entry>
        <record>410</record>
        <time>2023/09/26 11:22:04.739</time>
        <type>Error</type>
        <source>VisualStudio</source>
        <description>SetSite failed for package [SQLTestSSMSPackage](null)</description>
        <guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid>
        <hr>80070002</hr>
        <errorinfo></errorinfo>
      </entry>
      <entry>
        <record>411</record>
        <time>2023/09/26 11:22:04.739</time>
        <type>Error</type>
        <source>VisualStudio</source>
        <description>End package load [SQLTestSSMSPackage]</description>
        <guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid>
        <hr>80070002</hr>
        <errorinfo></errorinfo>
      </entry>
    </activity>

    Using SQL Test 4.1
    How can this be solved?
    Thanks
    · Share on Twitter
Sign In or Register to comment.