The SQL Search is not working with this error (tried versions 3.4 & 3.5):

jbursu

15 Apr 2021 18:10:26.860 [BatchingUsageApiClient] INFO  RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents

  Number of submitted usage events = 1

  HTTP status code = 200 OK

  Response body =

15 Apr 2021 18:10:26.866 [BatchingUsageApiClient] INFO  RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://productusage.red-gate.com/v1/usageevents

  Number of submitted usage events = 1

  HTTP status code = 200 OK

  Response body =

15 Apr 2021 18:10:28.591 [101] 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 )

Sujay

Hi Julian,

Thank you for your forum post.
This issue is usually observed when there's a mismatch in the DLL SQL Search shares with other Redgate tools.
Do you have any other Redgate Tools installed? An update of the other tools (SQL Prompt in particular) usually resolves this error.
Could you check if this works for you?

Regards,
Sujay 

jbursu

Hi Sujay,
After installing the SQL Prompt 9.5 it started working.
Thanks,
JB

Sujay

Hi Julian,

Thank you for the update. Good to know that it is working for you now.

Regards,
Sujay