SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 9.0.0151 Pro BETA] Error to load SqlAssist.DocMng.dll
Goto page 1, 2  Next
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 9.0.0151 Pro BETA] Error to load SqlAssist.DocMng.dll
Author Message
EricM



Joined: 27 Sep 2016
Posts: 4
Country: France

Post [SA 9.0.0151 Pro BETA] Error to load SqlAssist.DocMng.dll Reply with quote
I Have the error in the subject with Sql Server 2014 Management Studio
Tue Sep 27, 2016 7:06 am View user's profile Send private message
jeffw8713



Joined: 17 Nov 2010
Posts: 10
Country: United States

Post SSMS.exe failed to load SqlAssist.DocMng.dll Reply with quote
Received this error in SSMS 2014 for the 9.0 beta. What do we need to do to get this fixed?

Correction: also fails to load in SSMS 2012 but launches in 2008 R2.
Tue Sep 27, 2016 11:02 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Please open SQL Assistant Options dialog, click the About tab, the click the troubleshooting link at the bottom. This will generate the self diagnostics log file.

Please post the contents of the file. It should refer to some errors related to the addon registration.
Tue Sep 27, 2016 11:41 am View user's profile Send private message
jeffw8713



Joined: 17 Nov 2010
Posts: 10
Country: United States

Post Reinstalled - here are the errors Reply with quote
I uninstalled and reinstalled 7.5 - when I just now retried the install for 9.0 I got an error stating the self-integrity check failed. I then selected to correct the issues and continued. Here is the debug log:

*************************************************************
* SQL Assistant files *
*************************************************************
Installation directory: C:\Program Files (x86)\SQL Assistant 9
SQL Assistant version: 9.0.151
SqlAssist.exe ... OK
SqlEditor.exe ... OK
sacmd.exe ... OK
sareg.exe ... OK
saddl.exe ... OK
sascan.exe ... OK
sqleditor_std.exe ... OK
SQLEditor64.exe ... OK
sacmd64.exe ... OK
SqlAssist.pdf ... OK
data\SqlAssist.sas ... OK
data\SqlAssist.setup.sas ... OK
data\SqlAssistDTMap.xml ... OK
data\dbdiagram.themes ... OK
data\SqlAssist.dll ... OK
data\SqlAssistPrefs.dll ... OK
data\SqlAssist64.dll ... OK
data\SqlAssistPrefs64.dll ... OK
data\SqlAssist.Sms.dll ... OK
data\SqlAssist.Dbm.dll ... OK
data\SqlAssist.Ase.dll ... OK
data\SqlAssist.Dex.dll ... OK
data\SqlAssist.Mso.dll ... OK
data\SqlAssist.vs.dll ... OK
data\SqlAssist.vs.14.dll ... OK
data\SqlAssist.DocMng.dll ... OK
data\SqlAssist.mwb.dll ... OK
data\SqlAssist.mwb4.dll ... OK
data\SqlAssist.Ase4.dll ... OK
data\SqlAssist.Dex4.dll ... OK
data\SqlAssist.DDL.dll ... OK
data\SqlAssist.re.dll ... OK
data\SqlAssist.DocMng.dll ... OK
data\SqlAssist.Sms.Bars.dll ... OK
data\SqlAssist.SSMS2005.dll ... OK
data\SqlAssist.SSMS2005Ent.dll ... OK
data\SqlAssist.SSMS2005Std.dll ... OK
data\SqlAssist.SSMS2008.dll ... OK
data\SqlAssist.SSMS2008R2.dll ... OK
data\SqlAssist.SSMS2012.dll ... OK
data\SqlAssist.SSMS2014.dll ... OK
data\SqlAssist.SSMS2016.dll ... OK
data\SA_SqlEdit.dll ... OK
data\SA_SqlEdit9.bpl ... OK
data\SA_SqlEdit10.bpl ... OK
data\SA_SqlEdit11.bpl ... OK
data\SA_SqlEdit12.bpl ... OK
data\SA_SqlEdit14.bpl ... OK
data\SA_SqlEdit15.bpl ... OK
data\SA_SqlEdit16.bpl ... OK
data\SA_SqlEdit17.bpl ... OK
data\SA_SqlEdit18.bpl ... OK
data\SA_SqlEdit19.bpl ... OK
data\SA_SqlEdit20.bpl ... OK
data\SA_SqlEdit21.bpl ... OK
data\SA_SqlEdit22.bpl ... OK
data\SA_SqlEdit23.bpl ... OK
data\sqlite3.dll ... OK
data\sqlite3x64.dll ... OK
data\git-credential-winstore.exe ... OK

*************************************************************
* User registration *
*************************************************************
Access rights: elevated
UAC Level: DISABLED (0)
Registration mode: Current User
All users serial ... NO
Current user serial ... NO
SQL Assistant is not registered

*************************************************************
* COM Objects *
*************************************************************
Loading SqlAssist.CSqlClient... OK
Loading SqlAssist.CSmsAddin... OK
Loading SqlAssist.Ase.Editor... OK
Loading SqlAssist.Ase.DbManager... OK
Loading SqlAssist.Dex.XtraBars... OK
Loading SqlAssist.Dex.DotNetBars... OK
Loading SqlAssist.Dbm.DbManager... OK
Loading SqlAssist.Mso.Addin... OK
Loading SqlAssist.DDLLoader... OK
Loading SqlAssist.CSmsAddin10... FAILED
Exception:
Loading SqlAssist.MySQLWBAddin... OK
Loading SqlAssist.MySQLWBAddin4... OK
Loading SqlAssist.saRegExpr... OK
Loading SqlAssist.Ase.Editor... OK
Loading SqlAssist.Ase.DbManager... OK
Loading SqlAssist.Dex.XtraBars... OK
Loading SqlAssist.Ase.ToadDocumentManager... OK
Loading SqlAssist.Ase.ToadDocumentManager... OK

*************************************************************
* SQL Assistant Add-ons *
*************************************************************
SSMS 2005 ... REGISTERED FOR Current User and All Users
SSMS 2008 ... REGISTERED FOR Current User and All Users
SSMS 2012, 2014, 2016 COM Add-on ... REGISTERED FOR Current User and All Users
AU: Manifest file not found: c:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Extensions\SoftTree Technologies\SqlAssist.vs\1.0\extension.vsixmanifest
SSMS 2012 MEF ... REGISTRATION ERROR
SSMS 2012 MEF ... REGISTERED
SSMS 2014 MEF ... REGISTERED
SSMS 2016 MEF ... TARGET NOT INSTALLED

VS 2005 ... REGISTERED FOR Current User and All Users
VS 2008 ... REGISTERED FOR Current User and All Users
VS 2010, 2012, 2013, 2015 COM Add-on ... REGISTERED
VS 2010 MEF ... REGISTERED
VS 2012 MEF ... REGISTERED
VS 2013 MEF ... REGISTERED
VS 2015 MEF ... TARGET NOT INSTALLED

MS Access ... NOT REGISTERED

Delphi 2005 ... NOT INSTALLED
Delphi 2006 ... NOT INSTALLED
Delphi 2007 ... NOT INSTALLED
Delphi 2009 ... NOT INSTALLED
Delphi 2010 ... NOT INSTALLED
Delphi XE ... NOT INSTALLED
Delphi XE 2 ... NOT INSTALLED
Delphi XE 3 ... NOT INSTALLED
Delphi XE 4 ... NOT INSTALLED
Delphi XE 5 ... NOT INSTALLED
Delphi XE 6 ... NOT INSTALLED
Delphi XE 7 ... NOT INSTALLED
Delphi XE 8 ... NOT INSTALLED
Delphi XE 10 ... NOT INSTALLED

SQL Assistant diagnostics completed ... WITH ERRORS
[/img]
Tue Sep 27, 2016 12:17 pm View user's profile Send private message
EricM



Joined: 27 Sep 2016
Posts: 4
Country: France

Post Reply with quote
approximately same log

AU: Manifest file not found: c:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Extensions\SoftTree Technologies\SqlAssist.vs\1.0\extension.vsixmanifest
difference is the 120 in the path

same error for :
Loading SqlAssist.CSmsAddin10... FAILED
Tue Sep 27, 2016 12:27 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
The errors are different, refer to different components.
Here is what I would do. Start SQL Assistant in Run as Administrator mode.
Open the Options dialog.
On the Targets page select Management Studio target
In the Advanced options section on the right change add on registration status to No, click Apply, then set it back to Yes and Apply again. That should do it.
Start SQL. Server Management Studio and see if the error is gone.
Tue Sep 27, 2016 2:10 pm View user's profile Send private message
jeffw8713



Joined: 17 Nov 2010
Posts: 10
Country: United States

Post Reply with quote
This did not work - still getting the error in both 2014 and 2012. After opening a new query window - I get an error stating: SQL Assistant is unable to join database connection in MS Management Studio and SSMS crashes.

Still seeing the same issues in the diagnostic log - both the add-in failed and the manifest not found.
Tue Sep 27, 2016 2:35 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
That indicates that the add on isn't registered correctly. Basically SSMS isn't loading it or some parts of it.

I'm asked for advice from our team on how to resolve that and this is what they asked to check

Check this COM registration in the registry:

[HKEY_CLASSES_ROOT\CLSID\{754CF073-05B3-4E97-880D-1D88D8D524BE}]
"AppID"="{754CF073-05B3-4E97-880D-1D88D8D524BE}"
@="SqlAssist.CSmsAddin10"

[HKEY_CLASSES_ROOT\CLSID\{754CF073-05B3-4E97-880D-1D88D8D524BE}\InprocServer32]
@="mscoree.dll"
"CodeBase"="C:\\Program Files\\SQL Assistant\\data\\SqlAssist.DocMng.dll"
"Assembly"="SqlAssist.DocMng, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"
"Class"="SqlAssist.CSmsAddin10"
"RuntimeVersion"="v4.0.30128"
"ThreadingModel"="Both"

[HKEY_CLASSES_ROOT\CLSID\{754CF073-05B3-4E97-880D-1D88D8D524BE}\ProgId]
@="SqlAssist.CSmsAddin10"

In version 7.5 this COM object was in SqlAssist.vs.dll. Verify that after installing 9.0 it now refers to SqlAssist.DocMng.dll
Tue Sep 27, 2016 5:20 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Hi all,

Please download and install the latest build 9.0.152. In this build the setup routines have been updated to resolve the issue with incorrect registry entries left from previous SQL Assistant versions. If after that you still receive SQL Server Management Studio add-on loading errors, please run saDiag.exe and post the output of that self-diagnostics test.
Wed Sep 28, 2016 2:06 am View user's profile Send private message
EricM



Joined: 27 Sep 2016
Posts: 4
Country: France

Post Reply with quote
It 's ok for me with the latest build but I have now a sql assistant warning on intelissense who says :
Sql Assistant is unable de join database connection in MS Management Studio. Ma ke sure the connection has been established and working ( result code = 0)
I'm connect on a sqlserver version 12.0.500 with sqlserver authentification and with a IP on name server.
Wed Sep 28, 2016 9:26 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
It appears you still have an issue with the add-on. To resolve that, please uninstall SQL Assistant version 7.x Restart your computer and then reinstall the latest beta 9.0.152. This will reolve the error with connections sharing, and add-on loading.

Basically the problem is caused by a conflict with add-on from version 7.5 or earlier. The above steps will fix it.


Last edited by SysOp on Wed Sep 28, 2016 3:53 pm; edited 1 time in total
Wed Sep 28, 2016 9:35 am View user's profile Send private message
EricM



Joined: 27 Sep 2016
Posts: 4
Country: France

Post Reply with quote
Yes with uninstall of previous version i don't have the error.
I have a message on first launch on sqlmanagement studio about sqlassist.DocMng.dll and sqlassist.vs.dll .
One replace the other. but after it's ok.
I have a crash when i closed sqlmanagement studio first time but now it seems that all is ok.
Wed Sep 28, 2016 10:28 am View user's profile Send private message
jeffw8713



Joined: 17 Nov 2010
Posts: 10
Country: United States

Post 7.5 not removed Reply with quote
Okay - I installed 9.0.152 without uninstalling 7.5. No errors on the install but when I launch SSMS 2014 the version of SQL Assistant that is running is the 7.5 version and not the 9.0 version. I am going to uninstall and reinstall and see what happens. Here is the results from the diag tool:

*************************************************************
* SQL Assistant files *
*************************************************************
Installation directory: C:\Program Files (x86)\SQL Assistant 9
SQL Assistant version: 9.0.152
SqlAssist.exe ... OK
SqlEditor.exe ... OK
sacmd.exe ... OK
sareg.exe ... OK
saddl.exe ... OK
sascan.exe ... OK
sqleditor_std.exe ... OK
SQLEditor64.exe ... OK
sacmd64.exe ... OK
SqlAssist.pdf ... OK
data\SqlAssist.sas ... OK
data\SqlAssist.setup.sas ... OK
data\SqlAssistDTMap.xml ... OK
data\dbdiagram.themes ... OK
data\SqlAssist.dll ... OK
data\SqlAssistPrefs.dll ... OK
data\SqlAssist64.dll ... OK
data\SqlAssistPrefs64.dll ... OK
data\SqlAssist.Sms.dll ... OK
data\SqlAssist.Dbm.dll ... OK
data\SqlAssist.Ase.dll ... OK
data\SqlAssist.Dex.dll ... OK
data\SqlAssist.Mso.dll ... OK
data\SqlAssist.vs.dll ... OK
data\SqlAssist.vs.14.dll ... OK
data\SqlAssist.DocMng.dll ... OK
data\SqlAssist.mwb.dll ... OK
data\SqlAssist.mwb4.dll ... OK
data\SqlAssist.Ase4.dll ... OK
data\SqlAssist.Dex4.dll ... OK
data\SqlAssist.DDL.dll ... OK
data\SqlAssist.re.dll ... OK
data\SqlAssist.DocMng.dll ... OK
data\SqlAssist.Sms.Bars.dll ... OK
data\SqlAssist.SSMS2005.dll ... OK
data\SqlAssist.SSMS2005Ent.dll ... OK
data\SqlAssist.SSMS2005Std.dll ... OK
data\SqlAssist.SSMS2008.dll ... OK
data\SqlAssist.SSMS2008R2.dll ... OK
data\SqlAssist.SSMS2012.dll ... OK
data\SqlAssist.SSMS2014.dll ... OK
data\SqlAssist.SSMS2016.dll ... OK
data\SA_SqlEdit.dll ... OK
data\SA_SqlEdit9.bpl ... OK
data\SA_SqlEdit10.bpl ... OK
data\SA_SqlEdit11.bpl ... OK
data\SA_SqlEdit12.bpl ... OK
data\SA_SqlEdit14.bpl ... OK
data\SA_SqlEdit15.bpl ... OK
data\SA_SqlEdit16.bpl ... OK
data\SA_SqlEdit17.bpl ... OK
data\SA_SqlEdit18.bpl ... OK
data\SA_SqlEdit19.bpl ... OK
data\SA_SqlEdit20.bpl ... OK
data\SA_SqlEdit21.bpl ... OK
data\SA_SqlEdit22.bpl ... OK
data\SA_SqlEdit23.bpl ... OK
data\sqlite3.dll ... OK
data\sqlite3x64.dll ... OK
data\git-credential-winstore.exe ... OK

*************************************************************
* User registration *
*************************************************************
Access rights: elevated
UAC Level: DISABLED (0)
Registration mode: Current User
All users serial ... YES
Current user serial ... YES

*************************************************************
* COM Objects *
*************************************************************
Loading SqlAssist.CSqlClient... OK
Loading SqlAssist.CSmsAddin... OK
Loading SqlAssist.Ase.Editor... OK
Loading SqlAssist.Ase.DbManager... OK
Loading SqlAssist.Dex.XtraBars... OK
Loading SqlAssist.Dex.DotNetBars... OK
Loading SqlAssist.Dbm.DbManager... OK
Loading SqlAssist.Mso.Addin... OK
Loading SqlAssist.DDLLoader... OK
Loading SqlAssist.CSmsAddin10... OK
Loading SqlAssist.MySQLWBAddin... OK
Loading SqlAssist.MySQLWBAddin4... OK
Loading SqlAssist.saRegExpr... OK
Loading SqlAssist.Ase.Editor... OK
Loading SqlAssist.Ase.DbManager... OK
Loading SqlAssist.Dex.XtraBars... OK
Loading SqlAssist.Ase.ToadDocumentManager... OK
Loading SqlAssist.Ase.ToadDocumentManager... OK

*************************************************************
* SQL Assistant Add-ons *
*************************************************************
SSMS 2005 ... REGISTERED FOR Current User and All Users
SSMS 2008 ... REGISTERED FOR Current User and All Users
SSMS 2012, 2014, 2016 COM Add-on ... REGISTERED FOR Current User and All Users
SSMS 2012 MEF ... REGISTERED FOR Current User and All Users
AU: Manifest location: c:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Extensions\SoftTree Technologies\SqlAssist.vs\1.0\
AU: Manifest registry:
SSMS 2014 MEF ... REGISTRATION ERROR
SSMS 2014 MEF ... REGISTERED
SSMS 2016 MEF ... TARGET NOT INSTALLED

VS 2005 ... NOT REGISTERED
VS 2008 ... NOT REGISTERED
VS 2010, 2012, 2013, 2015 COM Add-on ... NOT REGISTERED
VS 2010 MEF ... NOT REGISTERED
VS 2012 MEF ... NOT REGISTERED
VS 2013 MEF ... NOT REGISTERED
VS 2015 MEF ... TARGET NOT INSTALLED

MS Access ... NOT REGISTERED

Delphi 2005 ... NOT INSTALLED
Delphi 2006 ... NOT INSTALLED
Delphi 2007 ... NOT INSTALLED
Delphi 2009 ... NOT INSTALLED
Delphi 2010 ... NOT INSTALLED
Delphi XE ... NOT INSTALLED
Delphi XE 2 ... NOT INSTALLED
Delphi XE 3 ... NOT INSTALLED
Delphi XE 4 ... NOT INSTALLED
Delphi XE 5 ... NOT INSTALLED
Delphi XE 6 ... NOT INSTALLED
Delphi XE 7 ... NOT INSTALLED
Delphi XE 8 ... NOT INSTALLED
Delphi XE 10 ... NOT INSTALLED

SQL Assistant diagnostics completed ... WITH ERRORS
Wed Sep 28, 2016 10:51 am View user's profile Send private message
jeffw8713



Joined: 17 Nov 2010
Posts: 10
Country: United States

Post Working now Reply with quote
Uninstalled and removed the directory for SQL Assistant 9. Renamed the directory for SQL Assistant 7 and restarted - reinstalled SQL Assistant 9 and launched SSMS 2014. I was prompted from SSMS that the addin no longer existed and did I want to remove it - selected yes.

SQL Assistant 9 seems to be working now - will be testing and evaluating it further.

The diag tool still shows a manifest issue though - not sure if that is something that we should be worried about.
Wed Sep 28, 2016 11:09 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Thank you for good news. It looks like everyone who reported an issue with add-on loading in SSMS was eventually able to resolve it.
Wed Sep 28, 2016 11:53 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 1, 2  Next
Page 1 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.