Upgraded search today, now completely broken

My search is not working anymore. It does not appear to be indexing correctly (takes 0 seconds to index anything, even my huge database). Logs are showing the error below. I did see a similar post from MArch with this error, but the fix is not working for me...

25 Nov 2019 11:12:43.589 [42] ERROR DatabaseObjectIndexer - Exception while indexing database master: 
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 )
Tagged:

Best Answer

  • sam.blackburnsam.blackburn Posts: 224 Gold 1
    Accepted Answer
    This can occasionally happen if you have an old version of one product and a new version of another product both running in SSMS.  If you have SQL Prompt or SQL Source Control installed, it may help to upgrade them to the latest version.  If this doesn't solve your problem, please contact [email protected] and we'll try to help you get it running.
    Software Developer
    Redgate Software

Answers

  • EarlEarl Posts: 7 New member
    I updated SQL Search today, 2019-12-02, and now I'm seeing this issue.  I updated SQL Source Control too in the hopes the issue was different versions of products.  I notice another person started a thread today on this issue and I commented there as well.  Unless there is another product I have installed that I don't know about, all products have been updated and yet SQL Search doesn't work.

    02 Dec 2019 11:57:51.245 [81] ERROR DatabaseObjectIndexer - Exception while indexing database marginmax_engine: 
    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 )
Sign In or Register to comment.