Activity overview
Latest activity by prozach99
I've found I can use this query in DB Browser for SQLite to get similar behavior, however it would be great if this worked in the SQL History tool: select qv.DateSaved, qv.Contents, qvp.Server, qvp.Database, qvp.Name from Queries as q inner join QueryVersions qv on q.Identity = qv.QueryIdentity inner join QueryVersionProperties as qvp on qvp.Identity = qv.QueryPropertiesIdentity inner join (select QueryIdentity, max(datesaved) as maxDateSaved from QueryVersions group by QueryIdentity) as qv2 on qv2.QueryIdentity = qv.QueryIdentity and qv2.maxdatesaved = qv.DateSaved where Server is not null and Contents like '%<some string>%' order by DateSaved DESC / comments
I've found I can use this query in DB Browser for SQLite to get similar behavior, however it would be great if this worked in the SQL History tool:select qv.DateSaved, qv.Contents, qvp.Server, qvp....
Ahh, yes I have that registry setting. I used this guide to save my history in Onedrive, I have history going back to 2013. Removing that entry resolved the issue; however, I lost all the historical SQL. When I change it back the issue returns. Is there a way to fix the database or something so I don't have to lose all that? On a side note, restoring open queries has been going a bit crazy lately, opening up a ton of duplicate tabs, I'm guessing these two issues are related. / comments
Ahh, yes I have that registry setting. I used this guide to save my history in Onedrive, I have history going back to 2013. Removing that entry resolved the issue; however, I lost all the historica...
Sure thing, thank you for looking into it. I've had it happen before but then it resolved itself, I'm not sure what caused it or fixed it. It would be nice to have a fix. / comments
Sure thing, thank you for looking into it. I've had it happen before but then it resolved itself, I'm not sure what caused it or fixed it. It would be nice to have a fix.
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...
SQL History Search Not working
When I try to search SQL History it doesn't return anything. I see the below error in the logs. I'm able to query the database directly using db browser, but i'd prefer to search SQL history from t...
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.
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...
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...