Devart Forums

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

Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

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

Page 1 of 1

Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

Posted: Thu 10 Jan 2019 08:19
by Ganendran
Hi,
I'm getting following error in SSMS v.17.9.1 after upgrading my schema (v.4.5.90) and data (v4.4.44) compare.
I upgraded both product with "dbForge Compare Bundle for SQL Server Professional' (v.5.6.2)

How can I remove the add-in from SSMS?

Error Message:
=========================
General
=========================
Application: dbForge Data Compare for SQL Server
Product: Devart dbForge Data Compare for SQL Server
Product Locale: English
Assembly: Devart.DbForge.SqlDataCompare.Integration, Version=4.4.44.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\Compare Bundle for SQL Server Professional\dbForge Data Compare for SQL Server\Addin\Devart.DbForge.SqlDataCompare.Integration.dll
Global cache: False
Framework: 4.6.2 or later

=========================
Exception Information
=========================
Message: An error occurred creating the configuration section handler for resources: Could not load file or assembly 'Devart.Shell.Common.r8, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (C:\Program Files\Devart\Compare Bundle for SQL Server Professional\dbForge Data Compare for SQL Server\Addin\Devart.DbForge.SqlDataCompare.Integration.dll.config line 4)
Source: System.Configuration
TargetSite: System.Configuration.FactoryRecord FindAndEnsureFactoryRecord(System.String, Boolean ByRef)
HelpLink:
Type: System.Configuration.ConfigurationErrorsException
Place: 1
Stack:
at System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere)
at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
at Devart.Shell.Common.ImageRepository.ImageRepository.DetectImagesFromConfig(String configFile)
at Devart.Shell.Common.ImageRepository.ImageRepository.Load()
at Devart.Shell.ServiceManager.GetService(Guid serviceId)
Start of InnerException

Message: Could not load file or assembly 'Devart.Shell.Common.r8, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Source: mscorlib
TargetSite: System.Reflection.RuntimeAssembly _nLoad(System.Reflection.AssemblyName, System.String, System.Security.Policy.Evidence, System.Reflection.RuntimeAssembly, System.Threading.StackCrawlMark ByRef, IntPtr, Boolean, Boolean, Boolean)
HelpLink:
Type: System.IO.FileNotFoundException
Stack:
at System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost host, String typeString, Boolean throwOnError)
at System.Configuration.MgmtConfigurationRecord.CreateSectionFactory(FactoryRecord factoryRecord)
at System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere)
End of InnerException
Regards,
Ganendran

Re: Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

Posted: Mon 14 Jan 2019 10:22
by alexa
Please try reinstalling dbForge Compare Bundle for SQL Server.

Re: Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

Posted: Tue 15 Jan 2019 13:21
by Ganendran
Hi,

Today I completely removed the Schema and data compare and reinstalled again, but the problem still exist.

Regards,
Ganendran

Re: Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

Posted: Thu 17 Jan 2019 12:40
by alexa
Please check for the file Devart.Shell.Common.r8 in the installation folder of dbForge Developer Bundle for SQL Server that is by default as follows:

Code: Select all

C:\Program Files\Devart\Compare Bundle for SQL Server Professional\dbForge Schema Compare for SQL Server\

Re: Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

Posted: Thu 17 Jan 2019 12:58
by Ganendran
Hi,

The file (Devart.Shell.Common.r8.dll) exist in folder

Code: Select all

C:\Program Files\Devart\Compare Bundle for SQL Server Professional\dbForge Data Compare for SQL Server\Addin\
And the file (Devart.Shell.Common.r9.dll) exist in folder

Code: Select all

C:\Program Files\Devart\Compare Bundle for SQL Server Professional\dbForge Schema Compare for SQL Server\Addin\
Regards,
Ganendran

Re: Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

Posted: Mon 21 Jan 2019 13:49
by alexa
Could you please let us know if you are using any antiviruses? Please try turning them off and let us know if it resolves the issue.

Re: Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

Posted: Wed 23 Jan 2019 15:14
by Ganendran
Hi,

Yes, we us McAfee antivirus, I tried as you said,
Turning off the antivirus and the firewall did not solve the problem, I also tried the following step and it also did not helped.

I uninstalled the data compare and schema compare bundle and turn off the antivirus and the firewall, then reinstalled the compare bundle, and start the SSMS, it gives the error message with the popup again.

regards,
Ganendran

Re: Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

Posted: Fri 25 Jan 2019 12:14
by alexa
Thank you for the reply.

Could you please provide us the list of the add-ins you have installed?

Re: Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

Posted: Fri 25 Jan 2019 12:53
by Ganendran
Hi,

In my SSMS is see only two add-ins
- SentryOne Plan Explorer
- SQL Pretty Printer for SQL Server Management Studio

If I can disable the Add-in feature of devart compare bundle, is also good, because we also use project files.

Regards,
Ganendran

Re: Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

Posted: Thu 07 Feb 2019 13:53
by .jp
Hello,

Thanks for the post.
We're investigating the problem and answer you as soon as any result is available.

Best Regards.

Re: Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

Posted: Thu 28 Feb 2019 15:53
by Ganendran
Hello,

Today I upgraded the "dbForge Compare Bundle for SQL Server Pro v.5.7.1)"
(Scheme v.4.6.24 and Data v.4.6.26).

Still the problem exist.

Code: Select all

=========================
 IDE Information
=========================
Name: Microsoft SQL Server Management Studio
Path: C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe
Product Version: 14.0.17289.0
DTE Version: 2017.0140
Edition: Express
LocaleID: 1033
Mode: vsIDEModeDesign
Registry Root: Software\Microsoft\SQL Server Management Studio\14.0

=========================
 General
=========================
Application: dbForge Data Compare for SQL Server
Product: Devart dbForge Data Compare for SQL Server
Product Locale: English 
Assembly: Devart.DbForge.SqlDataCompare.Integration, Version=4.5.26.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\Compare Bundle for SQL Server Professional\dbForge Data Compare for SQL Server\Addin\Devart.DbForge.SqlDataCompare.Integration.dll
Global cache: False
Framework: 4.6.2 or later

=========================
 Exception Information
=========================
Message: An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = Ety1hqp8HbjdXspy6Tb (ReflectionActivator), Services = [Devart.Shell.IWindowService], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = ExternallyOwned ---> An exception was thrown while invoking the constructor 'Void .ctor()' on type 'Ety1hqp8HbjdXspy6Tb'. ---> Object reference not set to an instance of an object. (See inner exception for details.) (See inner exception for details.)
Source: Devart.Shell.IocService.r8
TargetSite: System.Object Resolve(System.Type, System.Object[])
HelpLink: 
Type: Devart.Shell.ComponentNotRegisteredException
Place: 1
Stack:
   at Devart.Shell.IocContainer.Resolve(Type serviceType, Object[] args)
   at Devart.Shell.ServiceContainer.CreateServiceInstance(ServiceHolder service)
   at Devart.Shell.ServiceManager.GetService(Guid serviceId)
Start of InnerException
	
	Message: An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = Ety1hqp8HbjdXspy6Tb (ReflectionActivator), Services = [Devart.Shell.IWindowService], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = ExternallyOwned ---> An exception was thrown while invoking the constructor 'Void .ctor()' on type 'Ety1hqp8HbjdXspy6Tb'. ---> Object reference not set to an instance of an object. (See inner exception for details.) (See inner exception for details.)
	Source: Autofac
	TargetSite: System.Object Activate(System.Collections.Generic.IEnumerable`1[Autofac.Core.Parameter])
	HelpLink: 
	Type: Autofac.Core.DependencyResolutionException
	Stack:
	   at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters)
	   at Autofac.Core.Resolving.InstanceLookup.<Execute>b__5_0()
	   at Autofac.Core.Lifetime.LifetimeScope.GetOrCreateAndShare(Guid id, Func`1 creator)
	   at Autofac.Core.Resolving.InstanceLookup.Execute()
	   at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)
	   at Autofac.Core.Resolving.ResolveOperation.Execute(IComponentRegistration registration, IEnumerable`1 parameters)
	   at Autofac.Core.Lifetime.LifetimeScope.ResolveComponent(IComponentRegistration registration, IEnumerable`1 parameters)
	   at Autofac.Core.Container.ResolveComponent(IComponentRegistration registration, IEnumerable`1 parameters)
	   at Autofac.ResolutionExtensions.TryResolveService(IComponentContext context, Service service, IEnumerable`1 parameters, Object& instance)
	   at Autofac.ResolutionExtensions.ResolveService(IComponentContext context, Service service, IEnumerable`1 parameters)
	   at Devart.Shell.IocContainer.Resolve(Type serviceType, Object[] args)
	Start of InnerException
		
		Message: An exception was thrown while invoking the constructor 'Void .ctor()' on type 'Ety1hqp8HbjdXspy6Tb'. ---> Object reference not set to an instance of an object. (See inner exception for details.)
		Source: Autofac
		TargetSite: System.Object Instantiate()
		HelpLink: 
		Type: Autofac.Core.DependencyResolutionException
		Stack:
		   at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()
		   at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters, IEnumerable`1 defaultParameters)
		   at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters)
		Start of InnerException
			
			Message: Object reference not set to an instance of an object.
			Source: Devart.Shell.Studio.r8
			TargetSite: System.Collections.Generic.IEnumerable`1[Devart.Shell.IExportDefinition] GetExports[T]()
			HelpLink: 
			Type: System.NullReferenceException
			Stack:
			   at Devart.Shell.MefService.GetExports[T]()
			   at Devart.DbForge.Integration.Services.PackageWindowService.ak2ichnn6H()
			   at Devart.DbForge.Integration.Services.PackageWindowService..ctor()
			   at owFIDRpbqyvhZA8tvwg.Ety1hqp8HbjdXspy6Tb..ctor()
			   at lambda_method(Closure , Object[] )
			   at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()
		End of InnerException
	End of InnerException
End of InnerException
Regards,
Ganendran

Re: Error Opening SSMS v17.9.1 with Schema (v.4.5.90)and Data (v.4.4.44) Compare Add-in

Posted: Tue 12 Mar 2019 11:16
by alexa
Thank you for the information.

We are currently working on the functionality that should help us to identify the problem and will add it to one of the next product builds. We will notify you once it's available for downloading.
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/