SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQLA 12.3.427 - SSMS 19.0.2 No Autocomplete
Goto page Previous  1, 2
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQLA 12.3.427 - SSMS 19.0.2 No Autocomplete
Author Message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
This support board sanitizes messages and removes part of text it considers potentially unsafe, html/xml tags are sort of disallowed.
Can you please confirm that in your extension.vsixmanifest, the content of the Identifier line matches the below line and not what appears like missing in the sanitized version above?

Identifier Id="SqlAssist.vs..3d117742-b761-4b83-86ce-ca2aa58a8660"
Thu May 04, 2023 9:47 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
One more thing. Do you have by any chance a second copy of extension.vsixmanifest in
C:\Program Files (x86)\Microsoft SQL Server\160\Tools\Binn\ManagementStudio\Extensions\SoftTree Technologies\SqlAssist.vs\1.0\extension.vsixmanifest
If yes, does it have the same content and the same file path referencing C:\Program Files (x86)\SQL Assistant 12\bin\SqlAssist.vs.14.dll?
Thu May 04, 2023 10:00 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
Here is what we think may resolve this issue.

Please try deleting C:\Users\your user name\AppData\Local\Microsoft\SQL Server Management Studio\19.0_IsoShell\ComponentModelCache. This needs to be done while SSMS isn't running. It will rebuild that folder with cached files on startup.
Sat May 06, 2023 2:53 am View user's profile Send private message
stynx



Joined: 03 May 2023
Posts: 9
Country: United States

Post Reply with quote
Sorry couldn't reply soon enough. Here's what I found:

    *No line with Identifier Id="SqlAssist.vs..3d117742-b761-4b83-86ce-ca2aa58a8660" in SADiag output.
    *Deleting ComponentModelCache didn't fix it
    *No extra vsixmanifest. In fact, that folder does not exist at all.

Sat May 06, 2023 11:29 pm View user's profile Send private message
stynx



Joined: 03 May 2023
Posts: 9
Country: United States

Post Reply with quote
I got it working. In addition to deleting the "ComponentModelCache" folder, I deleted "extensions.*.cache" in %localappdata%\Microsoft\SQL Server Management Studio\19.0_IsoShell\Extensions as well.
Mon May 08, 2023 6:41 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
First of all, congrats for getting it to work!

This is very interesting, we will look into that, I don't think extensions.*.cache files are referenced in any documentation. Usually deleting ComponentModelCache is sufficient.
Mon May 08, 2023 8:21 pm View user's profile Send private message
stynx



Joined: 03 May 2023
Posts: 9
Country: United States

Post Reply with quote
Thanks. I renamed ComponentModelCache and extensions.*.cache so I have the ability to restore them if something went wrong. Tried just renaming ComponentModelCache and it definitely doesn't fix the problem. I needed to do both.
Tue May 09, 2023 12:21 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Goto page Previous  1, 2
Page 2 of 2

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.