The SQL Search is not working with this error (tried versions 3.4 & 3.5):
jbursu
Posts: 2 New member
in SQL Search
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 )
Tagged:
Best Answer
-
Sujay
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
After installing the SQL Prompt 9.5 it started working.
Thanks,
JB
Thank you for the update. Good to know that it is working for you now.
Regards,
Sujay