What are the challenges you face when working across database platforms? Take the survey
Options

SQL Search Not Working

measterbromeasterbro Posts: 4 New member
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.
Tagged:

Best Answer

Answers

  • Options
    measterbromeasterbro Posts: 4 New member
    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 )
  • Options
    measterbromeasterbro Posts: 4 New member
    The update fixed the problem.
Sign In or Register to comment.