SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SA 12.2.387 v SSMS 19.0.1

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SA 12.2.387 v SSMS 19.0.1
Author Message
Mindflux



Joined: 25 May 2013
Posts: 807
Country: United States

Post SA 12.2.387 v SSMS 19.0.1 Reply with quote
Every time I launch SSMS, before I even get the Connect to Server modal window SA is throwing an exception in a bubble popup in my taskbar:

Code:
Context: Loading of Object Explorer add-in SqlAssist.Ssms2022 failed.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'SqlPackageBase, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
   at SqlAssist.SsmsOE..ctor()
   --- End of inner exception stack trace ---
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at System.Activator.CreateInstance(Type type)
   at SqlAssist.SSMS_IDE.Init(DTE application)




[/code]
Tue Mar 14, 2023 8:43 am View user's profile Send private message
Frankie



Joined: 16 Feb 2022
Posts: 15
Country: Germany

Post Reply with quote
Code:
ontext: Loading of Object Explorer add-in SqlAssist.Ssms2022 failed.
System.Reflection.TargetInvocationException: Ein Aufrufziel hat einen Ausnahmefehler verursacht. ---> System.IO.FileNotFoundException: Die Datei oder Assembly "SqlPackageBase, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" oder eine Abhängigkeit davon wurde nicht gefunden. Das System kann die angegebene Datei nicht finden.
   bei SqlAssist.SsmsOE..ctor()
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
   bei System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   bei System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   bei System.Activator.CreateInstance(Type type, Boolean nonPublic)
   bei System.Activator.CreateInstance(Type type)
   bei SqlAssist.SSMS_IDE.Init(DTE application)


I have the same problems with SSMS 19.0.2 and SQLAssistant 12.2.387.
Tue Mar 14, 2023 4:02 pm View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
+1
Fri Mar 17, 2023 10:26 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Could you please try installing SqlPackage and see if that fixes the issue?
https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download?view=sql-server-ver16
Fri Mar 17, 2023 2:54 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 807
Country: United States

Post Reply with quote
SysOp wrote:
Could you please try installing SqlPackage and see if that fixes the issue?
https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download?view=sql-server-ver16


No sir, it did not remedy the error.
Sat Mar 18, 2023 11:28 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Could you please confirm you're running SSMS version 19.0.20200.0


Here is my version stack copied from SSMS Help/About. With that version I'm unable to reproduce your message. Maybe I have something else installed that you don't, which is a required dependency.

SQL Server Management Studio 19.0.20200.0+9286509b
SQL Server Management Objects (SMO) 16.200.48036.0+7d3b143d945e1aa638acdb02c0364e263d5ec973
Microsoft T-SQL Parser 16.0.22524.0+62eedb15cd3cde34e51c8fbbdf9b06e575ec912e
Microsoft Analysis Services Client Tools 16.0.19970.0
Microsoft Data Access Components (MDAC) 10.0.19041.2604
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.19044
Sat Mar 18, 2023 12:05 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 807
Country: United States

Post Reply with quote
I'm downloading 19.0.2 now, but here's my info for 19.0.1

SQL Server Management Studio 19.0.20200.0+9286509b
SQL Server Management Objects (SMO) 16.200.48036.0+7d3b143d945e1aa638acdb02c0364e263d5ec973
Microsoft T-SQL Parser 16.0.22524.0+62eedb15cd3cde34e51c8fbbdf9b06e575ec912e
Microsoft Analysis Services Client Tools 16.0.19970.0
Microsoft Data Access Components (MDAC) 10.0.22621.1265
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.22621
Sat Mar 18, 2023 12:59 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 807
Country: United States

Post Reply with quote
Here's 19.0.2's info:

SQL Server Management Studio 19.0.20209.0+f9a9d8f6
SQL Server Management Objects (SMO) 16.200.48036.0+7d3b143d945e1aa638acdb02c0364e263d5ec973
Microsoft T-SQL Parser 16.0.22524.0+62eedb15cd3cde34e51c8fbbdf9b06e575ec912e
Microsoft Analysis Services Client Tools 16.0.19993.0
Microsoft Data Access Components (MDAC) 10.0.22621.1265
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.22621

I still get the same exception popup from the taskbar from SA.
Sat Mar 18, 2023 1:05 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Looks the same as mine. So it got to be some external dependency(ies). We will try to reproduce it on a clean system.
Sat Mar 18, 2023 5:10 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 807
Country: United States

Post Reply with quote
SysOp wrote:
Looks the same as mine. So it got to be some external dependency(ies). We will try to reproduce it on a clean system.

Windows OS and MDAC component is different. If memory serves the 10.0.2x branch is Windows 11 (Thanks for that MS) and 10.0.1x is Windows 10?
Sat Mar 18, 2023 6:09 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
We managed to reproduce this issue. It could happen in case of upgrades, an old version of SSMS 19 add-on gets installed, a version which was developed for the preview version of SSMS 19.0.0, and not forward compatible with 19.0.1 and 19.0.2. We will have a new setup with the upgraded version published soon. Please stay tuned.
Mon Mar 20, 2023 7:54 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Here is a quick fix for this issue that can be applied now.

Make sure SSMS and SQL Assistant are both closed
Download and unzip the following small file to C:\Program Files (x86)\SQL Assistant 12\bin
https://www.softtreetech.com//support/files/sqlassist/SqlAssist.SSMS2022.zip

This is to replace the Object Explorer add-on for SSMS 19 preview version 19.0.0 with the latest version. The former isn't forward compatible with SSMS 19.0.1 and 19.0.2.


Last edited by SysOp on Tue Mar 21, 2023 10:49 am; edited 1 time in total
Tue Mar 21, 2023 9:21 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 807
Country: United States

Post Reply with quote
Trying now, by the way your link says httpa:// not https:// so the the browser wasn't happy until I manually fixed it.
Tue Mar 21, 2023 9:24 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Thank you. I fixed it. Now it's https.
Tue Mar 21, 2023 10:50 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 807
Country: United States

Post Reply with quote
SysOp wrote:
Thank you. I fixed it. Now it's https.


So far so good with the hot patch.
Tue Mar 21, 2023 2:29 pm 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
Page 1 of 1

 
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.