| Author |
Message |
EricM
Joined: 27 Sep 2016
Posts: 4
Country: France |
|
 [SA 9.0.0151 Pro BETA] Error to load SqlAssist.DocMng.dll |
 |
I Have the error in the subject with Sql Server 2014 Management Studio
|
|
| Tue Sep 27, 2016 7:06 am |
  |
 |
jeffw8713
Joined: 17 Nov 2010
Posts: 19
Country: United States |
|
| SSMS.exe failed to load SqlAssist.DocMng.dll |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
jeffw8713
Joined: 17 Nov 2010
Posts: 19
Country: United States |
|
| Reinstalled - here are the errors |
|
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 |
|
|
EricM
Joined: 27 Sep 2016
Posts: 4
Country: France |
|
| |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
jeffw8713
Joined: 17 Nov 2010
Posts: 19
Country: United States |
|
| |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
EricM
Joined: 27 Sep 2016
Posts: 4
Country: France |
|
| |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
EricM
Joined: 27 Sep 2016
Posts: 4
Country: France |
|
| |
|
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 |
|
|
jeffw8713
Joined: 17 Nov 2010
Posts: 19
Country: United States |
|
| 7.5 not removed |
|
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 |
|
|
jeffw8713
Joined: 17 Nov 2010
Posts: 19
Country: United States |
|
| Working now |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
|
