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

Activity overview

Latest activity by Earl

That is a fair question.  I open the RedGate product like Source Control and click on the top right Help.  Under there should be an option to check for updates.  [image] / comments
That is a fair question.  I open the RedGate product like Source Control and click on the top right Help.  Under there should be an option to check for updates.  
0 votes
This problem is due to different versions of RedGate products installed.  I updated all RedGate products that I had a license to use.  I uninstalled all RedGate trial products that wasn't licensed to use.  That fixed SQL Search for me. / comments
This problem is due to different versions of RedGate products installed.  I updated all RedGate products that I had a license to use.  I uninstalled all RedGate trial products that wasn't licensed ...
0 votes
SQL Test is 1.5.2.448 Unlicensed Trial.  I don't use this.  SQL Search is 3.4.0.2481.  I do use this.  SQL Source Control is 7.1.2.10022.  I use this.  SQL Doc 3 is 3.0.3.9.  I don't use this.  SQL Dependency Tracker 0 is 2.8.1.182.  I don't use this.  I did email support and I received a response.  I updated all of the RedGate products that show as installed, but SQL Search is still not finding search values that it should find.  RedGate support emailed a link to a toolbelt product that I need to install and try.  I got busy with work yesterday and didn't finish troubleshooting. Still seeing this in the log: 03 Dec 2019 08:19:10.531 [66] ERROR DatabaseObjectIndexer - Exception while indexing database sync_registry:  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 ) / comments
SQL Test is 1.5.2.448 Unlicensed Trial.  I don't use this.  SQL Search is 3.4.0.2481.  I do use this.  SQL Source Control is 7.1.2.10022.  I use this.  SQL Doc 3 is 3.0.3.9.  I don't use this.  SQL...
0 votes
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 ) / comments
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 ...
0 votes
I just installed the 3.4.0.2481 SQL Search update this morning and now no values are found for terms that I can prove are in the instance.  Does this update only work with a new version of SSMS or newer versions of SS than 11.0.7001.0? I'm not seeing any errors as mentioned in the original post.  I did try reindexing, but no terms are found.  I found a similar post from March and another thread started today on this same topic.  Each of the threads says SQL Search can quite working after being updated if there are other products installed that have not also been updated.  I have SQL Source Control installed and I found two updates for it.  I'm installed those now and then I will retry SQL Search and post an update here. I installed two SQL Source Control updates but SQL Search still is not working.  I found the log file for SQL Search and I found similar messages as in this original post: 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 ) / comments
I just installed the 3.4.0.2481 SQL Search update this morning and now no values are found for terms that I can prove are in the instance.  Does this update only work with a new version of SSMS or ...
0 votes