Version 10.7.1.22264 table autocomplete crash
This is new... I'm receiving frequent error pop-ups when SQL Prompt attempts to auto-complete (especially) temp tables.
I'm not seeing anything to report in the error box. I've sent in a few reports.
SQL Prompt version: Version 10.7.1.22264
SSMS Version: 18.9.1
Windows 10 20H2
Looking at the log, here is the result of the most recent issue. It's happening so frequently I figured I had better report it:
2021-08-31 10:26:28.259 -07:00 [Error] Report error dialog UI shown
System.InvalidOperationException: No server found for this candidate
at RedGate.SqlPrompt.Metadata.CandidateInterfaces.CandidateExtensions.GetDatabaseAndServer(ICandidate candidate)
at RedGate.SqlPrompt.Metadata.CandidateInterfaces.CandidateExtensions.GetConnectionProperties(ICandidate candidate)
at RedGate.SQLPrompt.CommonUI.ProductIntegration.DependencyTracker.DependenciesAvailabilityChecker.IsSupportedAuthenticationType(ICandidate candidate)
at RedGate.SQLPrompt.CommonUI.ProductIntegration.DependencyTracker.DependenciesAvailabilityChecker.CanGetDependencies(ICandidate candidate)
at RedGate.SQLPrompt.CommonUI.Forms.SchemaInformation.ObjectDefinitionBox.SetTabs(Boolean isColumnCandidate)
at RedGate.SQLPrompt.CommonUI.Forms.SchemaInformation.ObjectDefinitionBox.ShowSchemaInformationForm(Boolean isColumnCandidate, Int32 y, Int32 left, Int32 right)
at RedGate.SQLPrompt.CommonUI.Forms.SchemaInformation.ObjectDefinitionBox.ShowSchemaInformationForm(ICandidate candidate, Int32 left, Int32 right, Int32 y)
at RedGate.SQLPrompt.CommonUI.Forms.CandidateList.CandidateList.<OnSchemaPanelTimerTick>b__70_0()
at RedGate.SQLPrompt.UsageReporting.ErrorReporting.ErrorReporterWithUI.Do(Action action)
Best Answers
-
ATurner Posts: 204 Silver 2
Hi jsreynolds1
This is a known issue and the team are currently looking into it.
-
ATurner Posts: 204 Silver 2Hi jsreynolds1
The fix for this has been released in version 10.7.2.22957. This can be downloaded from here https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.7.2.22957.exe
Please can you update to this and let us know if the issue reoccurs?
Answers
Thank you,
-J