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

  • SujaySujay Posts: 34 Bronze 1
    Accepted Answer
    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 
    Product Support Engineer | Redgate Software

    Have you visited our 
    Help Center?

Answers

Sign In or Register to comment.