What are the challenges you face when working across database platforms? Take the survey
Options

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

jbursujbursu Posts: 2 New member
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 )

Best Answer

  • Options
    SujaySujay Posts: 47 Bronze 2
    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 

Answers

Sign In or Register to comment.