How can we help you today?

How can we help you today?

SQL Search Not Working

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.

Michael June 10, 2020 15:31

0

Comments

3 comments

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 June 10, 2020 15:38

0
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

Martin_K June 11, 2020 15:40

0
The update fixed the problem.

measterbro June 11, 2020 16:45

0

Add comment

Please sign in to leave a comment.