SQL Search Not Working

measterbro

I am running version 3.5.0.2590. The Search does nothing, it just says "no search results". I have deleted the files in C:\Users\xxx\AppData\Local\Red Gate\SQLSearch 3\Indexes and re-started SSMS. I also tried re-indexing.

Martin_K

Hi,

Sometimes issues like this can crop up when there's a mismatch in the DLL SQL Search shares with other Redgate tools. Would you mind running the below installer to upgrade any other tools you may have installed. Should do the trick:

http://download.red-gate.com/SQLToolbelt.exe

measterbro

These errors are in the log:

10 Jun 2020 11:26:44.688 [87] ERROR ServerObjectIndexer - Exception while indexing server:
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.ServerObjectStorage.Initialise()
   at RedGate.SQLSearch.Indexing.ServerObjectIndexer.Index(CancellationToken )
10 Jun 2020 11:26:44.688 [86] ERROR DatabaseObjectIndexer - Exception while indexing database SalesOps:
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 )
10 Jun 2020 11:26:45.171 [83] ERROR ServerObjectIndexer - Exception while indexing server:
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.ServerObjectStorage.Initialise()
   at RedGate.SQLSearch.Indexing.ServerObjectIndexer.Index(CancellationToken )
10 Jun 2020 11:26:45.171 [84] ERROR DatabaseObjectIndexer - Exception while indexing database SalesOps:
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 )

measterbro

The update fixed the problem.