SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
babaluga
Posts: 5
Joined: Tue 29 Nov 2016 09:53

SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Post by babaluga » Mon 27 May 2019 07:21

Hello,

Everything is in the subject. At startup, SSMS 18 GA stops responding. Can I disable SQL Complete only for this version to see if it is the problem, or do I have a way of logging or debugging it ?
Thanks

alexa
Devart Team
Posts: 2723
Joined: Fri 24 Jun 2011 14:17

Re: SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Post by alexa » Mon 27 May 2019 13:50

You can uninstall dbForge selecting the 'Registry options' and 'Configuration files' options only on the 'Uninstall options' page of the Uninstall wizard with the purpose to find out if that's the problem.

Sam Whiten
Posts: 3
Joined: Thu 14 Mar 2019 19:46

Re: SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Post by Sam Whiten » Mon 27 May 2019 19:48

I installed the latest update (6.1.59) earlier today and since then SSMS (15.0.18118.0) hung on startup each time. Uninstalling it completely fixed it. I reinstalled the previous version (6.1.13 ) and now it's back to work as normal. Something is obviously wrong with 6.1.59.

alexa
Devart Team
Posts: 2723
Joined: Fri 24 Jun 2011 14:17

Re: SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Post by alexa » Tue 28 May 2019 05:21

Thank you for the reply.

Could you please also send us the system information generated by clicking the 'Send Info' button in the 'System Info Report Contents' window invoked by selecting 'SQL Complete -> Help -> About...' from the main menu of SSMS and then clicking the 'View System Info' button in the dialog?

alexa
Devart Team
Posts: 2723
Joined: Fri 24 Jun 2011 14:17

Re: SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Post by alexa » Tue 28 May 2019 06:12

Could you please answer the following questions:
1. Are you using the Documents Sessions feature? If so, what's the approximate amount and size of the documents is restored?
2. Is Document Outline open upon starting SSMS?
3. What the version of the server you are connecting to?
4. What's the size of the file ExecutedQueries.db located in:

Code: Select all

C:\Users\<UserName>\AppData\Roaming\Devart\dbForge SQL Complete\ExecutedQueries\
5. Do you have other versions of SSMS 2018 installed? Is there the same problem?
6. How many object does the database contain?

alexa
Devart Team
Posts: 2723
Joined: Fri 24 Jun 2011 14:17

Re: SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Post by alexa » Tue 28 May 2019 11:29

Please ignore the previous questions.

We were able to reproduce this issue and will fix it soon.

Sam Whiten
Posts: 3
Joined: Thu 14 Mar 2019 19:46

Re: SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Post by Sam Whiten » Tue 28 May 2019 20:47

Great. Thank you.

babaluga
Posts: 5
Joined: Tue 29 Nov 2016 09:53

Re: SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Post by babaluga » Wed 29 May 2019 06:59

Hello,

Great. About your questions, it hangs regardless, even if I'm not connecting to a server. If I start SSMS, cancel the connection that is proposed to me, one second after that, SSMS stops responding.

babaluga
Posts: 5
Joined: Tue 29 Nov 2016 09:53

Re: SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Post by babaluga » Wed 29 May 2019 07:31

One more thing : SQL Complete 6.1.59 is regularly hanging Visual Studio 2019 for about 9 seconds in my SSDT project.

alexa
Devart Team
Posts: 2723
Joined: Fri 24 Jun 2011 14:17

Re: SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Post by alexa » Wed 29 May 2019 10:22

We will notify you once the new product build with the fixes is available for downloading.

Sam Whiten
Posts: 3
Joined: Thu 14 Mar 2019 19:46

Re: SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Post by Sam Whiten » Wed 12 Jun 2019 19:00

I believe it has been fixed with 6.1.72.

alexa
Devart Team
Posts: 2723
Joined: Fri 24 Jun 2011 14:17

Re: SSMS 18 GA is hanging at startup, how to know if it is because of sqlcomplete ?

Post by alexa » Fri 14 Jun 2019 12:41


Post Reply