Devart Forums

Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/

SSMS application startup error

https://forums.devart.com/viewtopic.php?f=33&t=30430

Page 1 of 1

SSMS application startup error

Posted: Thu 18 Sep 2014 11:46
by elsio
Hi,

I've installed dbForge SQL Complete, however I am unable to start the SSMS with dbForge SQL Complete addin. I get the following report error. I have uninstalled and reinstalled but with no luck.

Any assistance appreciated.

Error report:

=========================
IDE Information
=========================
Name: Microsoft SQL Server Management Studio
Path: C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe
Product Version: 10.50.1600.1
DTE Version: 2009.0100
Edition: Enterprise
LocaleID: 1033
Mode: vsIDEModeDesign
Registry Root: Software\Microsoft\Microsoft SQL Server\100\Tools\Shell

=========================
General
=========================
Application: dbForge SQL Complete
Product: Devart dbForge SQL Complete
Product Edition: Express
Product Locale: English
Assembly: Devart.DbForge.SqlComplete.AddIn, Version=4.7.226.1, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files (x86)\Devart\dbForge SQL Complete\Devart.DbForge.SqlComplete.AddIn.dll
Global cache: False
Framework: 2.0.50727.5485

=========================
Exception Information
=========================
Message: The service {4986b08c-c517-4980-8f9f-6a673978efdc} is already registered.
Source: Devart.Shell.Interfaces
TargetSite: Void RegisterServiceInternal(Devart.Shell.ServiceInfo)
HelpLink:
Type: System.InvalidOperationException
Place: 1
Stack:
at Devart.Shell.ServiceManager.RegisterServiceInternal(ServiceInfo serviceInfo)
at Devart.Shell.ServiceManager.AddService(Guid serviceId, Object serviceInstance)
at Devart.DbForge.SqlComplete.AddInShell.RegisterCoreServices()
at Devart.Shell.ShellBase.InitializeCore()
at Devart.DbForge.SqlComplete.AddInShell.Start()
at Devart.DbForge.SqlComplete.AddIn.Connect.a(AddIn A_0, DTE2 A_1)
at Devart.DbForge.SqlComplete.AddIn.Connect.OnConnection(Object application, ext_ConnectMode connectMode, Object addInInst, Array& custom)

=========================
Registered AddIns
=========================
Name: SSMS Tools Pack 3.2.2.0
Description: Copyright (c) 2014, Mladen Prajdic, www.SsmsToolsPack.com
Is Connected: True
ProgId: SSMSToolsPack10
Satellite Dll Path:

Name: dbForge SQL Complete 4.7
Description: dbForge SQL Complete - advanced code completion and SQL formatting add-in for SQL Server Management Studio and Visual Studio
Is Connected: True
ProgId: Devart.DbForge.SqlComplete.AddIn
Satellite Dll Path: C:\Program Files (x86)\Devart\dbForge SQL Complete\1033\Devart.DbForge.SqlComplete.Satellite.dll


=========================
Error Report Exception Information
=========================
Message: Object reference not set to an instance of an object.
Source: Devart.DbForge.SqlComplete.AddIn
TargetSite: Devart.Shell.IWindow get_ActiveDocumentWindow()
HelpLink:
Type: System.NullReferenceException
Stack:
at agx.get_ActiveDocumentWindow()
at aqf.l(StringBuilder A_0)
at aqf.e(StringBuilder A_0)
at aqf.a(StringBuilder A_0, Action`1 A_1)

=========================
Loaded Assemblies
=========================
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
AppIDPackage, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Program Files (x86)/Microsoft SQL Server/100/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
mscorlib.resources, Version=2.0.0.0, Culture=pt, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
Microsoft.SqlServer.SqlTools.VSIntegration, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Program Files (x86)/Microsoft SQL Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
Microsoft.VisualStudio.Shell.Interop, Version=7.1.40304.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 7.1.40304.0 C:/Windows/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
Microsoft.VisualStudio.OLE.Interop, Version=7.1.40304.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 7.1.40304.0 C:/Windows/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
SqlWorkbench.Interfaces, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Program Files (x86)/Microsoft SQL Server/100/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
Microsoft.SqlServer.SqlTDiagM, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
Microsoft.SqlServer.Instapi, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
EnvDTE, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 8.0.0.0 C:/Windows/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
Microsoft.VisualStudio.Shell, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
Microsoft.VisualStudio.Shell.Interop.8.0, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 8.0.0.0 C:/Windows/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
Microsoft.SqlServer.Management.SDK.SqlStudio, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Program Files (x86)/Microsoft SQL Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SDK.SqlStudio.DLL
Microsoft.DataWarehouse.SQM, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Program Files (x86)/Microsoft SQL Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
SSMSToolsPack10, Version=3.2.2.0, Culture=neutral, PublicKeyToken=a49c9b5533ef3445 3.2.2.0 C:/Program Files (x86)/SSMS Tools Pack/SSMS Tools Pack 2008/SSMSToolsPack10.dll
SSMSToolsPackB10, Version=3.2.2.0, Culture=neutral, PublicKeyToken=a49c9b5533ef3445 3.2.2.0 C:/Program Files (x86)/SSMS Tools Pack/SSMS Tools Pack 2008/SSMSToolsPackB10.DLL
Extensibility, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 7.0.3300.0 C:/Windows/assembly/GAC/Extensibility/7.0.3300.0__b03f5f7f11d50a3a/Extensibility.dll
Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Management.Sdk.Sfc/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.Management.Reports, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Program Files (x86)/Microsoft SQL Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Reports.DLL
EnvDTE80, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 8.0.0.0 C:/Windows/assembly/GAC/EnvDTE80/8.0.0.0__b03f5f7f11d50a3a/EnvDTE80.dll
SSMSToolsPackC10, Version=3.2.2.0, Culture=neutral, PublicKeyToken=a49c9b5533ef3445 3.2.2.0 C:/Program Files (x86)/SSMS Tools Pack/SSMS Tools Pack 2008/SSMSToolsPackC10.DLL
PostSharp, Version=3.1.49.9, Culture=neutral, PublicKeyToken=b13fd38b8f9c99d7 3.1.49.9 C:/Program Files (x86)/SSMS Tools Pack/SSMS Tools Pack 2008/PostSharp.DLL
System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
Microsoft.VisualStudio.TextManager.Interop, Version=7.1.40304.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 7.1.40304.0 C:/Windows/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
CustomMarshalers, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
Microsoft.SqlServer.Management.SqlStudio.Explorer, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Program Files (x86)/Microsoft SQL Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SqlStudio.Explorer.DLL
Microsoft.SqlServer.Management.Controls, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Program Files (x86)/Microsoft SQL Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Controls.DLL
ObjectExplorer, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Program Files (x86)/Microsoft SQL Server/100/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 3.5.0.0 C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
Microsoft.SqlServer.Management.UserSettings, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Program Files (x86)/Microsoft SQL Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UserSettings.DLL
SqlMgmt, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Program Files (x86)/Microsoft SQL Server/100/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
ConnectionDlg, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Program Files (x86)/Microsoft SQL Server/100/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
Microsoft.VisualStudio, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll
System.Drawing.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
Microsoft.VisualStudio.Designer.Interfaces, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 1.0.5000.0 C:/Windows/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll
Microsoft.SqlServer.RegSvrEnum, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 10.0.0.0 C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
Microsoft.VisualStudio.CommandBars, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 8.0.0.0 C:/Windows/assembly/GAC/Microsoft.VisualStudio.CommandBars/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.CommandBars.dll
4fbw55rj, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
Devart.DbForge.SqlComplete.AddIn, Version=4.7.226.1, Culture=neutral, PublicKeyToken=09af7300eec23701 4.7.226.1 C:/Program Files (x86)/Devart/dbForge SQL Complete/Devart.DbForge.SqlComplete.AddIn.dll
Devart.Shell.Utils, Version=2.1.16.1, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.16.1 C:/Program Files (x86)/Devart/dbForge SQL Complete/Devart.Shell.Utils.DLL
Devart.Shell.Interfaces, Version=2.1.16.1, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.16.1 C:/Program Files (x86)/Devart/dbForge SQL Complete/Devart.Shell.Interfaces.DLL
Devart.Shell.Studio, Version=2.1.16.1, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.16.1 C:/Program Files (x86)/Devart/dbForge SQL Complete/Devart.Shell.Studio.DLL
Devart.Shell.CommonRes, Version=2.1.16.1, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.16.1 C:/Program Files (x86)/Devart/dbForge SQL Complete/Devart.Shell.CommonRes.DLL
Devart.DbForge.SqlComplete.AddIn.resources, Version=4.7.226.1, Culture=en, PublicKeyToken=09af7300eec23701 4.7.226.1 C:/Program Files (x86)/Devart/dbForge SQL Complete/en/Devart.DbForge.SqlComplete.AddIn.resources.DLL
Devart.Shell.IocService, Version=2.1.16.1, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.16.1 C:/Program Files (x86)/Devart/dbForge SQL Complete/Devart.Shell.IocService.DLL
Devart.XUtils.v12.2, Version=12.2.15.0, Culture=neutral, PublicKeyToken=09af7300eec23701 12.2.15.0 C:/Program Files (x86)/Devart/dbForge SQL Complete/Devart.XUtils.v12.2.DLL
Devart.DbForge.Interfaces, Version=4.0.79.1, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.79.1 C:/Program Files (x86)/Devart/dbForge SQL Complete/Devart.DbForge.Interfaces.DLL
Devart.Shell.Controls, Version=2.1.16.1, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.16.1 C:/Program Files (x86)/Devart/dbForge SQL Complete/Devart.Shell.Controls.DLL

=========================
System Information
=========================
Wow64 detected.
Processor architecture: amd64
Processor quantity: 8
Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz Intel64 Family 6 Model 30 Stepping 5
Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz Intel64 Family 6 Model 30 Stepping 5
Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz Intel64 Family 6 Model 30 Stepping 5
Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz Intel64 Family 6 Model 30 Stepping 5
Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz Intel64 Family 6 Model 30 Stepping 5
Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz Intel64 Family 6 Model 30 Stepping 5
Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz Intel64 Family 6 Model 30 Stepping 5
Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz Intel64 Family 6 Model 30 Stepping 5

Total physical memory: 8151Mb
Total available paginal memory: 11152Mb
Process available virtual memory: 1720Mb
Process private memory size: 38Mb
Display1: 1920x1080, 100% DPI
Display2: 1920x1080, 100% DPI

Operating System Name: Windows 7 Enterprise
Operating System Version: Microsoft Windows NT 6.1.7601 Service Pack 1
UAC: Disabled
Elevation Level: Default

Instances: 1
Culture: Portuguese (Portugal)
Process started at 09/18/2014 12:37:50
Report created at 09/18/2014 12:37:52

Re: SSMS application startup error

Posted: Thu 18 Sep 2014 16:59
by alexa
You are using an obsolete product build. Please upgrade to the latest one which is 4.7.233 http://www.devart.com/dbforge/sql/sqlco ... nload.html

Re: SSMS application startup error

Posted: Fri 19 Sep 2014 09:08
by elsio
Thank you for your help.

I tried with the last build (4.7.233), but i've got the same error:

=========================
General
=========================
Application: dbForge SQL Complete
Product: Devart dbForge SQL Complete
Product Edition: Standard
Product Locale: English
Assembly: Devart.DbForge.SqlComplete.AddIn, Version=4.7.233.1, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files (x86)\Devart\dbForge SQL Complete\Devart.DbForge.SqlComplete.AddIn.dll, Trial
Global cache: False
Framework: 2.0.50727.5485

=========================
Exception Information
=========================
Message: The service {4986b08c-c517-4980-8f9f-6a673978efdc} is already registered.
Source: Devart.Shell.Interfaces
TargetSite: Void RegisterServiceInternal(Devart.Shell.ServiceInfo)
HelpLink:
Type: System.InvalidOperationException
Place: 1
Stack:
at Devart.Shell.ServiceManager.RegisterServiceInternal(ServiceInfo serviceInfo)
at Devart.Shell.ServiceManager.AddService(Guid serviceId, Object serviceInstance)
at Devart.DbForge.SqlComplete.AddInShell.RegisterCoreServices()
at Devart.Shell.ShellBase.InitializeCore()
at Devart.DbForge.SqlComplete.AddInShell.Start()
at Devart.DbForge.SqlComplete.AddIn.Connect.a(AddIn A_0, DTE2 A_1)
at Devart.DbForge.SqlComplete.AddIn.Connect.OnConnection(Object application, ext_ConnectMode connectMode, Object addInInst, Array& custom)

Re: SSMS application startup error

Posted: Fri 19 Sep 2014 09:38
by alexa
Please try the following:

1. Close Management Studio.

2. Uninstall dbForge SQL Complete selecting the 'Registry options' and 'Configuration files' options only on the 'Uninstall options' page of the Uninstall wizard.

3. Remove the installation folder of dbForge SQL Complete that is by default as follows:

%programfiles%\Devart\dbForge SQL Complete

4. Remove the following file (if applicable):

%SystemDrive%\Documents and Settings\%UserName%\Application Data\Devart\dbForge SQL Complete\uicache.dat

5. Install dbForge SQL Complete, 4.7.233 once again.
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/