Error with SQL Dependency Tracker With latest SSMS release

With the latest release of SSMS there is an error at startup.

The log shows <description>LegacySitePackage failed for package [SQLDependencyTrackerSSMSPackage]Source: &apos;RedGate.SharedSSMS&apos; Description: Encountered unknown SSMS version 15.100.0.0&#x000D;&#x000A;System.ApplicationException: Encountered unknown SSMS version 15.100.0.0&#x000D;&#x000A;   at RedGate.SharedSSMS.Util.VersionUtils.get_RunningSsmsVersion()&#x000D;&#x000A;   at RedGate.SharedSSMS.Util.SharedSsmsObjectFactory.get_VersionSpecificAssembly()&#x000D;&#x000A;   at RedGate.SharedSSMS.VersionSpecificObjectFactory.Create[T]()&#x000D;&#x000A;   at RedGate.SharedSSMS.Util.VersionSpecificClass`1.get_Implementation()&#x000D;&#x000A;   at RedGate.SIPFramework.Services.ServicesToPlugins.SsmsFunctionalityProvider.Initialize(DTE2 dte)&#x000D;&#x000A;   at RedGate.SIPFramework.Services.ServicesToPlugins.SsmsFunctionalityProvider..ctor(DTE2 dte, ILog log, WrappingFactory wrappingFactory)&#x000D;&#x000A;   at RedGate.SIPFramework.Services.AddinLoader..ctor(DTE2 dte, ILog log)&#x000D;&#x000A;   at RedGate.SQLDependencyTracker.SSMSPackage.SQLDependencyTrackerSSMSPackage.Initialize()&#x000D;&#x000A;   at Microsoft.VisualStudio.Shell.Package.Microsoft.VisualStudio.Shell.Interop.IVsPackage.SetSite(IServiceProvider sp)</description>


Tagged:

Answers

  • Sergio RSergio R Posts: 610 Rose Gold 5
    Hi Paul,

    We have just released SQL Dependency Tracker 3.3.0 which supports SSMS 18.5.

    Can you please update and test with that version? 
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
  • JBHJBH Posts: 1 New member
    edited July 6, 2020 7:24PM
    Downloaded the latest trial today for SQL Dependency Tracker. Installed against SSMS version 15.0.18333.0

    I get the following error starting SSMS:

    The 'SQLDependencyTrackerSSMSPackage' package did not load correctly.

    It would be nice if this issue could be resolved before my 14-day trial has expired. I need to evaluate this tool to see if it meets our needs - which are immediate.


    LegacySitePackage failed for package [SQLDependencyTrackerSSMSPackage]Source: 'RedGate.SIPFramework.Services' Description: Could not load file or assembly 'RedGate.SharedSSMS, Version=3.6.352.0, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified. System.IO.FileNotFoundException: Could not load file or assembly 'RedGate.SharedSSMS, Version=3.6.352.0, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified. File name: 'RedGate.SharedSSMS, Version=3.6.352.0, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' at RedGate.SIPFramework.Services.ServicesToPlugins.SsmsFunctionalityProvider.Initialize(DTE2 dte) at RedGate.SIPFramework.Services.ServicesToPlugins.SsmsFunctionalityProvider..ctor(DTE2 dte, ILog log, WrappingFactory wrappingFactory) at RedGate.SIPFramework.Services.AddinLoader..ctor(DTE2 dte, ILog log) at RedGate.SQLDependencyTracker.SSMSPackage.SQLDependencyTrackerSSMSPackage.Initialize() at Microsoft.VisualStudio.Shell.Package.Microsoft.VisualStudio.Shell.Interop.IVsPackage.SetSite(IServiceProvider sp) 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!


  • OlegMurOlegMur Posts: 1 New member
    Hi, I'm having the same issue as the OP. I have SSMS version 15.0.18333.0 installed and the latest of SQL Dependency Tracker and getting the same error.

        <description>LegacySitePackage failed for package [SQLDependencyTrackerSSMSPackage]Source: &apos;RedGate.SIPFramework.Services&apos; Description: Could not load file or assembly &apos;RedGate.SharedSSMS, Version=3.6.352.0, 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.SharedSSMS, Version=3.6.352.0, Culture=neutral, PublicKeyToken=7f465a1c156d4d57&apos; or one of its dependencies. The system cannot find the file specified.&#x000D;&#x000A;File name: &apos;RedGate.SharedSSMS, Version=3.6.352.0, Culture=neutral, PublicKeyToken=7f465a1c156d4d57&apos;&#x000D;&#x000A;   at RedGate.SIPFramework.Services.ServicesToPlugins.SsmsFunctionalityProvider.Initialize(DTE2 dte)&#x000D;&#x000A;   at RedGate.SIPFramework.Services.ServicesToPlugins.SsmsFunctionalityProvider..ctor(DTE2 dte, ILog log, WrappingFactory wrappingFactory)&#x000D;&#x000A;   at RedGate.SIPFramework.Services.AddinLoader..ctor(DTE2 dte, ILog log)&#x000D;&#x000A;   at RedGate.SQLDependencyTracker.SSMSPackage.SQLDependencyTrackerSSMSPackage.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>

    Please advise
  • I'm pleased to tell you that this problem should be fixed in SQL Dependency tracker 3.3.4
    Development Lead
    Redgate Software
Sign In or Register to comment.