How can we help you today? How can we help you today?
Mike Patrick
Activity overview Badges (0) Posts (0) Comments (2)

Activity overview

Latest activity by Mike Patrick

I opened a support request and got a pretty fast response: I've been advised that this is a bug when you're using SQL Search with SQL Prompt installed and it's been escalated to the developers. Using SSMS 21/22 or downgrading to SQL Prompt 11.2.0 will get around this issue for the time being. https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_11.2.0.19838.exe Downgrading SQL Prompt (from 11.2.1 to 11.2.0) resolved my issue. Note, from my preceding post, I'm on a fairly old OS and not-very-new SSMS, so YMMV. / comments
  1. Community
  2. SQL Search
  3. SQL search doesn't give results anymore
I opened a support request and got a pretty fast response:I've been advised that this is a bug when you're using SQL Search with SQL Prompt installed and it's been escalated to the developers.Using...
0 votes
Experiencing the same. Relevant config info from “current log”: [ { "eventType": "session.started", "headers": { "productId": "sql-search", "productVersion": "3.9.1.6302", "createdTimeUtc": "2025-12-10T10:51:05Z" }, "payload": { "hostMachine": { "software": { "operatingSystem": { "is64Bit": true, "kernelVersion": "10.0.14393.6343", "name": "Microsoft Windows Server 2016 Standard", "platform": "Win32NT", "servicePack": "", "compatibilityVersion": "10.0.14393.0", "systemDrive": "C:" }, "processInformation": { "filename": "Ssms.exe", "fileVersion": "20.2.37.0", "fullPath": "C:\\Program Files (x86)\\Microsoft SQL Server Management Studio 20\\Common7\\IDE\\Ssms.exe", "productVersion": "20.2.37.0" } } } } } ] Related log errors: 2025-12-10 05:51:26.876 -05:00 [Error] [ServerObjectIndexer]: Exception while indexing server: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) at System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(SQLiteConfigOpsEnum op) at System.Data.SQLite.SQLite3.StaticIsInitialized() at System.Data.SQLite.SQLiteLog.PrivateInitialize(String className) at System.Data.SQLite.SQLiteLog.Initialize(String className) at System.Data.SQLite.SQLiteConnection..ctor(String connectionString, Boolean parseViaFramework) at System.Data.SQLite.SQLiteConnection..ctor(String connectionString) 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 token) 2025-12-10 05:51:26.895 -05:00 [Error] [DatabaseObjectIndexer]: Exception while indexing database SampleDB: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) 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.DatabaseObjectStorage.Initialise() at RedGate.SQLSearch.Indexing.DatabaseObjectIndexer.Index(CancellationToken token) 2025-12-10 05:51:27.337 -05:00 [Error] [ServerObjectIndexer]: Exception while indexing server: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) 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 token) 2025-12-10 05:51:27.338 -05:00 [Error] [DatabaseObjectIndexer]: Exception while indexing database SampleDB: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) 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.DatabaseObjectStorage.Initialise() at RedGate.SQLSearch.Indexing.DatabaseObjectIndexer.Index(CancellationToken token) 2025-12-10 05:51:28.507 -05:00 [Error] [DatabaseObjectIndexer]: Exception while indexing database SampleDB: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) 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.DatabaseObjectStorage.Initialise() at RedGate.SQLSearch.Indexing.DatabaseObjectIndexer.Index(CancellationToken token) 2025-12-10 05:51:28.509 -05:00 [Error] [ServerObjectIndexer]: Exception while indexing server: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) 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 token) / comments
  1. Community
  2. SQL Search
  3. SQL search doesn't give results anymore
Experiencing the same. Relevant config info from “current log”:[ { "eventType": "session.started", "headers": { "productId": "sql-search", "productVersion": "3.9.1.6302", ...
Edited 0 votes
Total activity
4
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
1
Subscriptions
1