SQL Search Returns No Results

btsui

After updating Redgate, my SQL Search returns nothing. It is still able to connect to Servers and Databases, but seems to have an index problem. I am using SQL Search version 3.2.6.2313 and SSMS version 17.9.1

Log File Shows:
"ERROR DatabaseObjectIndexer - Exception while indexing database.." 
System.EntryPointNotFoundException: Unable to find an entry point named 'sqlite3_open_interop' in DLL 'SQLite.Interop.dll'.   at System.Data.SQLite.UnsafeNativeMethods.sqlite3_open_interop(Byte[] utf8Filename, Byte[] vfsName, SQLiteOpenFlagsEnum flags, Int32 extFuncs, IntPtr& db)   at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)   at System.Data.SQLite.SQLiteConnection.Open()   at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.EnsureConnectionOpen()   at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.CreateCommand()   at RedGate.SQLSearch.Indexing.SQLite.DatabaseObjectStorage.Initialise()   at RedGate.SQLSearch.Indexing.DatabaseObjectIndexer.Index(CancellationToken )
I have tried: 

• Reindexing
• Clearing my %LocalAppData%\Red Gate\SQLSearch 3\Indexes content
• Rebooting
• Replacing the System.Data.SQLite.dll in C:\ProgramData\Red Gate\SQL Search\Source with the older version (1.0.85.0, copied from SQL Prompt 9 folder, C:\Program Files (x86)\Red Gate\SQL Prompt 9). 
  

Thanks in advance


UPDATE: 

I uninstalled / reinstalled SQL Search version 3.2.6.2313 and it works. 

kwilliams

I'm experiencing the exact same issue 

sql search v 3.2.6.2313
ssms v 17.9.1


the last error in my log (there's one for each database)

23 Apr 2019 17:23:19.115 [92] ERROR DatabaseObjectIndexer - Exception while indexing database tempdb: 

System.EntryPointNotFoundException: Unable to find an entry point named 'sqlite3_open_interop' in DLL 'SQLite.Interop.dll'.

   at System.Data.SQLite.UnsafeNativeMethods.sqlite3_open_interop(Byte[] utf8Filename, Byte[] vfsName, SQLiteOpenFlagsEnum flags, Int32 extFuncs, IntPtr& db)

   at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)

   at System.Data.SQLite.SQLiteConnection.Open()

   at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.EnsureConnectionOpen()

   at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.CreateCommand()

   at RedGate.SQLSearch.Indexing.SQLite.DatabaseObjectStorage.Initialise()

   at RedGate.SQLSearch.Indexing.DatabaseObjectIndexer.Index(CancellationToken )

notstock78

I am also having a similar issue.  Sql Search version 3.3.0.2332 and SSMS version 17.9.1.  SQL Search returns no results.
My error message is the following.
24 Apr 2019 16:29:34.228 [70] ERROR RedGate.SQLSearch.Addin.Connect - Error during update
System.MissingMethodException: Method not found: 'Void RedGate.Client.UpdatePluginShim.UpdateShim..ctor(Redgate.Client.Common.IRedGateClientLogger)'.
   at RedGate.SQLSearch.Addin.CheckForUpdates.UpdateAttempter.GetUpdateManager()
   at System.Lazy`1.CreateValue()
   at System.Lazy`1.LazyInitValue()
   at System.Lazy`1.get_Value()
   at RedGate.SQLSearch.Addin.CheckForUpdates.UpdateAttempter.DoUpdate()

snaphooks2

Same issue.  SQL Search is not working at all.

kwilliams

Is it possible to roll back to the previous version?

from now on I'll check the forum before blindly updating

kwilliams

FIXED! update the latest version of Sql Prompt (9.5.0.9311)

see this thread for the explanation

https://forum.red-gate.com/discussion/84956/sql-search-not-returning-any-results#latest