Upgraded search today, now completely broken

MattTag

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 )

sam.blackburn

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 support@red-gate.com and we'll try to help you get it running.

Earl

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 )