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 )
Comments
3 comments
-
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 -
Hi Sujay,
After installing the SQL Prompt 9.5 it started working.
Thanks,
JB -
Hi Julian,
Thank you for the update. Good to know that it is working for you now.
Regards,
Sujay
Add comment
Please sign in to leave a comment.