Comments
Sort by recent activity
That version did not fix the issue. I'm attaching the log file from today that includes that error here. / comments
That version did not fix the issue. I'm attaching the log file from today that includes that error here.
Thank you for the reply. I installed that but it didn't fix the issue. The problem is SQL History not SQL Search. For example there are recent queries that reference the table fw_error_log, but when I type it in the filter box nothing returns and I can see the error referenced above in the error log. [image] [image] [image] / comments
Thank you for the reply. I installed that but it didn't fix the issue. The problem is SQL History not SQL Search. For example there are recent queries that reference the table fw_error_log, but whe...
Hello, This issue is happening again, I'm not sure what fixed it previously but right now I'm unable to search with the same error: 2024-10-01 13:01:01.816 -04:00 [Error] Error while searching for 'mentor' (page: 1, object type: Everything, start date: <not set>, end date: <not set>, server: <not set>, database: <not set>, starred state: NotSet, open state: NotSet, sort: Relevance): Additional non-parsable characters are at the end of the string. I see this error earlier in the log: 2024-10-01 10:26:40.640 -04:00 [Error] Error processing command: StoreContentsRevision
System.FormatException: Additional non-parsable characters are at the end of the string.
/ comments
Hello,This issue is happening again, I'm not sure what fixed it previously but right now I'm unable to search with the same error:2024-10-01 13:01:01.816 -04:00 [Error] Error while searching for 'm...
My current workaround is to use DB Browser for SQLite and run the query there. select * from QueryVersions where Contents like '%mentor%' Gets me what I need but not as easy as the integrated tool. / comments
My current workaround is to use DB Browser for SQLite and run the query there.select *from QueryVersionswhere Contents like '%mentor%'Gets me what I need but not as easy as the integrated tool.
I see this at the beginning of the log for today. Is there a way to repair/clean the database? 2024-04-17 07:31:52.961 -04:00 [Information] Trimming history... 2024-04-17 07:31:53.115 -04:00 [Information] History trimming complete (time taken = 00:00:00.1536573) 2024-04-17 07:31:56.531 -04:00 [Information] [Startup status] Size on disk (bytes) = 75513856, Number of queries = 4212, Number of revisions = 9698, Highest revisions per query = 209, Longest contents (characters) = 907601 2024-04-17 07:31:56.558 -04:00 [Information] Indexing SQL History to C:\Users\zgelnett\OneDrive\Documents\WorkStuff\Settings\SSMS\SQL Prompt\SqlHistoryIndex... 2024-04-17 07:31:57.105 -04:00 [Error] Error indexing database System.FormatException: Additional non-parsable characters are at the end of the string. at J2N.Numerics.ParseNumbers.StringToLong(String s, Int32 radix, Int32 flags, Int32 sign, Int32& currPos, Int32 length) at J2N.Numerics.Int64.Parse(String s, Int32 startIndex, Int32 length, Int32 radix) at Lucene.Net.Index.SegmentInfos.GetLastCommitGeneration(String[] files) at Lucene.Net.Index.SegmentInfos.FindSegmentsFile.Run(IndexCommit commit) at Lucene.Net.Index.SegmentInfos.Read(Directory directory) at Lucene.Net.Index.IndexWriter..ctor(Directory d, IndexWriterConfig conf) at RedGate.SqlPrompt.SqlHistory.Storage.Search.Indexing.IndexWriterWrapper..ctor(Directory directory) at RedGate.SqlPrompt.SqlHistory.Storage.Search.Indexing.Indexer.ReIndex(IDbCommand command) at RedGate.SqlPrompt.SqlHistory.Storage.Search.Indexing.Indexer.Index(IDbCommand command) at RedGate.SqlPrompt.SqlHistory.Storage.Search.CacheInitializer.Initialize(String sqlHistoryPath) / comments
I see this at the beginning of the log for today. Is there a way to repair/clean the database?2024-04-17 07:31:52.961 -04:00 [Information] Trimming history...2024-04-17 07:31:53.115 -04:00 [Informa...
Hello, I am not seeing any error messages when i sign in. I just tried updating to the new version of sql prompt but that didn't fix the issue / comments
Hello, I am not seeing any error messages when i sign in. I just tried updating to the new version of sql prompt but that didn't fix the issue
@Dinomite thank you!! This seems like an issue that MS needs to fix. They obviously installed the dll with SSMS, but apparently forgot to register it. / comments
@Dinomite thank you!! This seems like an issue that MS needs to fix. They obviously installed the dll with SSMS, but apparently forgot to register it.
Same issue here. Downgrading corrected the problem. I found you can get the previous version of SSMS here: https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16#1901 / comments
Same issue here. Downgrading corrected the problem.I found you can get the previous version of SSMS here: https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16#1901