How is SQL Prompt helping your team? Share your experience.
SQLSearchSSMSPackage Not Loading Correctly
ShuttleBILL
Posts: 3 New member
in SQL Prompt
I've been getting this for a while now. The XLM referenced looks like this:
<entry>
<record>316</record>
<time>2020/06/11 18:57:35.553</time>
<type>Warning</type>
<source>VisualStudio</source>
<description>Unexpected system error mode before loading package [SQLSearchSsmsPackage]</description>
<guid>{26218D92-039D-466C-BF66-EAE1098379BE}</guid>
</entry>
<entry>
<record>317</record>
<time>2020/06/11 18:57:35.553</time>
<type>Information</type>
<source>VisualStudio</source>
<description>Begin package load [SQLSearchSsmsPackage]</description>
<guid>{26218D92-039D-466C-BF66-EAE1098379BE}</guid>
</entry>
<entry>
<record>318</record>
<time>2020/06/11 18:57:35.563</time>
<type>Error</type>
<source>VisualStudio</source>
<description>SetSite failed for package [SQLSearchSsmsPackage]Source: 'RedGate.SQLSearch.SSMSPackage18' Description: Could not load file or assembly 'RedGate.SIPFramework.Services, Version=0.2.1.208, 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.SIPFramework.Services, Version=0.2.1.208, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified.
File name: 'RedGate.SIPFramework.Services, Version=0.2.1.208, Culture=neutral, PublicKeyToken=7f465a1c156d4d57'
 at RedGate.SQLSearch.SSMSPackage.SQLSearchSsmsPackage.<InitializeAsync>d__1.MoveNext()
 at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
 at RedGate.SQLSearch.SSMSPackage.SQLSearchSsmsPackage.InitializeAsync(CancellationToken cancellationToken, IProgress`1 progress)
 at Microsoft.VisualStudio.Shell.AsyncPackage.<>c__DisplayClass17_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 Microsoft.VisualStudio.Services.VsTask.RethrowException(AggregateException e)
 at Microsoft.VisualStudio.Services.VsTask.InternalGetResult(Boolean ignoreUIThreadCheck)
 at Microsoft.VisualStudio.Services.VsTask.GetResult()

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>{26218D92-039D-466C-BF66-EAE1098379BE}</guid>
<hr>80070002</hr>
<errorinfo></errorinfo>
</entry>
<entry>
<record>319</record>
<time>2020/06/11 18:57:35.568</time>
<type>Error</type>
<source>VisualStudio</source>
<description>End package load [SQLSearchSsmsPackage]</description>
<guid>{26218D92-039D-466C-BF66-EAE1098379BE}</guid>
<hr>80070002</hr>
<errorinfo></errorinfo>
</entry>
</activity>
Answers
After at least 10 different methods of uninstalling and re-installing all 3 components in my errors, SSMS, Red Gate products & Visual Studio, I decided to go into the program directory and root around for any old hangers-on.
Sure enough, the Red Gate dlls were all in their program directory, and the Red Gate IDE Extensions for SSMS were all still in 18's directories... So I removed all these, did clean installs of SSMS & Red Gate products. And it looks like everything is running without problems.
Mucky. But done.
To resolve, I uninstalled SQL Search, deleted the "C:\Program Files (x86)\Red Gate" folder and installed SQL Search again.