SQL Prompt 8 locks up and freezes SSMS
Turgid_demon
Posts: 1 New member
Happens very intermittently but when it does I have to dump SSMS from task manager to recover.
edit: Using SSMS 11.0.2100.60 and SQL Prompt 8.0.9.2226
This screen shot is after I recovered but its at the exact spot everything froze up.
Event viewer is showing the following two errors
___________________________________________________________
- System
- Provider
[ Name] .NET Runtime
- EventID 1026
[ Qualifiers] 0
Level 2
Task 0
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2017-11-27T19:37:00.944998800Z
EventRecordID 425859
Channel Application
Computer somecomputername
Security
- EventData
Application: Ssms.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.IO.FileNotFoundException at RedGate.SQLPrompt.CommonUI.Utils.ErrorDialog.ShowError(System.Exception) at RedGate.SQLPrompt.CommonUI.Utils.ErrorDialog.Do(System.Action) at RedGate.SQLPrompt.CommonUI.Forms.CandidateList.CandidateList2.m_SchemaPanelTimer_Tick(System.Object, System.EventArgs) at System.Windows.Forms.Timer.OnTick(System.EventArgs) at System.Windows.Forms.Timer+TimerNativeWindow.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)
__________________________________________________________________
And
__________________________________________________________________
- System
- Provider
[ Name] Application Error
- EventID 1000
[ Qualifiers] 0
Level 2
Task 100
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2017-11-27T19:37:01.192380700Z
EventRecordID 425860
Channel Application
Computer somecomputername
Security
- EventData
Ssms.exe
2011.110.2100.60
4f35e2d9
KERNELBASE.dll
10.0.15063.726
32774c02
e0434352
000ecbb2
30e0
01d367893aad776e
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe
C:\WINDOWS\System32\KERNELBASE.dll
5fc80018-dbce-441a-8280-05c3c2fa852c
___________________________________________________________
Any suggestions would be welcome as this is a real pain.
If this is not the right place for this please point me in the right direction.
edit: Using SSMS 11.0.2100.60 and SQL Prompt 8.0.9.2226
This screen shot is after I recovered but its at the exact spot everything froze up.
Event viewer is showing the following two errors
___________________________________________________________
- System
- Provider
[ Name] .NET Runtime
- EventID 1026
[ Qualifiers] 0
Level 2
Task 0
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2017-11-27T19:37:00.944998800Z
EventRecordID 425859
Channel Application
Computer somecomputername
Security
- EventData
Application: Ssms.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.IO.FileNotFoundException at RedGate.SQLPrompt.CommonUI.Utils.ErrorDialog.ShowError(System.Exception) at RedGate.SQLPrompt.CommonUI.Utils.ErrorDialog.Do(System.Action) at RedGate.SQLPrompt.CommonUI.Forms.CandidateList.CandidateList2.m_SchemaPanelTimer_Tick(System.Object, System.EventArgs) at System.Windows.Forms.Timer.OnTick(System.EventArgs) at System.Windows.Forms.Timer+TimerNativeWindow.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)
__________________________________________________________________
And
__________________________________________________________________
- System
- Provider
[ Name] Application Error
- EventID 1000
[ Qualifiers] 0
Level 2
Task 100
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2017-11-27T19:37:01.192380700Z
EventRecordID 425860
Channel Application
Computer somecomputername
Security
- EventData
Ssms.exe
2011.110.2100.60
4f35e2d9
KERNELBASE.dll
10.0.15063.726
32774c02
e0434352
000ecbb2
30e0
01d367893aad776e
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe
C:\WINDOWS\System32\KERNELBASE.dll
5fc80018-dbce-441a-8280-05c3c2fa852c
___________________________________________________________
Any suggestions would be welcome as this is a real pain.
If this is not the right place for this please point me in the right direction.
Answers
Sorry to hear you are having this issue.
Can you please upgrade your .NET Framework (Microsoft .NET Framework 4.6.1) and SQL Prompt?
If problem persists, please let us know!
Tianjiao Li | Redgate Software
Have you visited our Help Center?