Applies to
ApexSQL Complete
Summary
This article explains the reported defect that SQL Server Management Studio crashes randomly after couple of hours of active work with the Auto-complete feature enabled
Symptoms
SQL Server Management Studio is crashing with the following error report:
Exception: Error in AutocompleteProvider::KeyboardEventsKeyUp: Value ‘0’ is not a valid value for Interval. Interval must be greater than 0.
Parameter name: Interval
at System.Windows.Forms.Timer.set_Interval(Int32 value)
at ApexSql.Common.AutocompleteUI.AutocompleteHelper.DisplayDefinitionsBoxAfterDelay()
at ApexSql.Common.AutocompleteUI.AutoCompleteGridExForm.ProcessSelectionChanged()
at ApexSql.Common.AutocompleteUI.AutoCompleteGridExForm.GridSelectionChanged(Object sender, EventArgs e)
at Janus.Windows.GridEX.GridEX.OnSelectionChanged(EventArgs e)
at Janus.Windows.GridEX.GridEX.m()
at Janus.Windows.GridEX.GridEX.a(CurrencyManager )
at Janus.Windows.GridEX.GridEX.a(Object , String , Boolean )
at Janus.Windows.GridEX.GridEX.SetDataBinding(Object dataSource, String dataMember)
at ApexSql.Common.AutocompleteUI.AutoCompleteGridExForm.InitializeHintCollection(IList`1 inHints, HintCollection hintCollection)
at ApexSql.Common.AutocompleteUI.AutocompleteHelper.ProcessNewHintCollection(HintCollection newHintCollection)
at ApexSql.Common.AutocompleteUI.AutocompleteHelper.PopulateListBox(AutomaticGenerateHintsData appliedContextsData)
at ApexSql.Common.AutocompleteUI.AutocompleteHelper.AutoShowAutocompleteFormIfNeed()
at ApexSql.Common.AutocompleteUI.AutocompleteHelper.ProcessPressedKey(Boolean keyUp)
at c5.b(Object A_0, KeyEventArgs A_1)
Background
While writing SQL code, due to a bug in reading the add-in settings file, the add-in causes SQL Server Management Studio to crash
Affected versions:
ApexSQL Complete 2013.04.0022 and previous
Resolution
Resolution
Download the ApexSQL Complete patch from here
