SSMS application startup error

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
elsio
Posts: 2
Joined: Thu 18 Sep 2014 11:31

SSMS application startup error

Post by elsio » Thu 18 Sep 2014 11:46

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
Top
alexa

Re: SSMS application startup error

Post by alexa » Thu 18 Sep 2014 16:59

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
Top
elsio
Posts: 2
Joined: Thu 18 Sep 2014 11:31

Re: SSMS application startup error

Post by elsio » Fri 19 Sep 2014 09:08

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)
Top
alexa

Re: SSMS application startup error

Post by alexa » Fri 19 Sep 2014 09:38

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.
Top
Post Reply

Return to “dbForge for SQL Server”