How can we help you today? How can we help you today?

SQL Search Returns No Results

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. 

Ben
0

Comments

5 comments

Sort by
  • 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 )
    kwilliams
    0
  • 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()
    notstock78
    0
  • snaphooks2
    Same issue.  SQL Search is not working at all.
    snaphooks2
    0
  • kwilliams
    Is it possible to roll back to the previous version?
    from now on I'll check the forum before blindly updating :o
    kwilliams
    0
  • kwilliams
    FIXED! update the latest version of Sql Prompt (9.5.0.9311)

    see this thread for the explanation


    kwilliams
    0

Add comment

Please sign in to leave a comment.