Latest version of SQL Prompt (9.2.7.6282) causing SSMS (17.8.1) to hang?

Ever since I installed the latest version of SQL Prompt (9.2.7.6282), after less than five minutes of working in SSMS, SSMS hangs, and I get a notice in the system tray that says, "Microsoft SQL Server Management Studio is waiting for an internal operation to complete."  Eventually, I have to end the SSMS task and restart it.  If I disable SQL Prompt, it seems OK, but as soon as I re-enable it, it will hang within a few minutes.

Best Answer

Answers

  • MagnusHMagnusH Posts: 5 Bronze 1
    Some developers at our office are experiencing exactly the same problem. There are no apparent differences between the configurations of those that are experiencing it and those who aren't, either.
  • We're looking into this, but without much success. Without any way to reproduce it I suspect it may be difficult. Can you share any information about your environment?
    Have you visited our Help Centre?
  • MagnusHMagnusH Posts: 5 Bronze 1
    edited September 3, 2018 12:06PM
  • KnedelKnedel Posts: 1 New member
    Same here.
    Problems started immediately after installing SQL Prompt 9.2.7.6282 on SSMS 17.8.1.

    Microsoft SQL Server Management Studio 14.0.17277.0
    Microsoft Analysis Services Client Tools 14.0.1016.262
    Microsoft Data Access Components (MDAC) 6.1.7601.17514
    Microsoft MSXML 3.0 4.0 6.0 
    Microsoft Internet Explorer 9.11.9600.19080
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 6.1.7601
  • In my particular instance, I'm running Windows 7 Experience N, SP 1, with 16 GB memory, 64-bit O/S.
    SQL Server Management Studio is v17.8.1, with: 
    Microsoft SQL Server Management Studio 14.0.17277.0
    Microsoft Analysis Services Client Tools 14.0.1016.262
    Microsoft Data Access Components (MDAC) 6.1.7601.17514
    Microsoft MSXML 3.0 4.0 6.0 
    Microsoft Internet Explorer 9.11.9600.19080
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 6.1.7601

  • TheoL said:
    Same problems - reverting to 9.1.16 "solved" the issues for me.  I shall be waiting for 9.2.x release that fixes the issue, as this bug makes SSMS unusable for me.

    Investigation with logs: last 5 lines show:
    04 Sep 2018 11:25:24,736 [1] DEBUG RedGate.SqlPrompt.Engine.AutoCompletion.AutoCompleter - Inserted text : .
    04 Sep 2018 11:25:24,736 [34] ERROR RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [12760] Abandoning current task 'Matching object names'.
    04 Sep 2018 11:25:24,937 [8] INFO  RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [12776] Started task 'Code analysis task <a.sql - localhost.master (c\d (53))*>'.
    04 Sep 2018 11:25:31,465 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
    04 Sep 2018 11:25:31,465 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 551067436


    After this - the only action I can take is kill SSMS using Task Manager.

    If I am not connected to the database, it does not crash.

    Reverting to an earlier version of SQL Prompt solved the problem for me as well.
  • NgainerNgainer Posts: 16 Bronze 3
    I reverted to version 9.2.6.6145 and everything seems to be working again. We have been experiencing the same issues as above. Makes SSMS totallly unusable. Current environment info:

    Microsoft SQL Server Management Studio 14.0.17277.0
    Microsoft Analysis Services Client Tools 14.0.1016.262
    Microsoft Data Access Components (MDAC) 10.0.17134.1
    Microsoft MSXML 3.0 6.0 
    Microsoft Internet Explorer 9.11.17134.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 6.3.17134
Sign In or Register to comment.