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

[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

[alexa]

Please try reinstalling dbForge Compare Bundle for SQL Server.

[Ganendran]

Hi,

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

Regards,
Ganendran

[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\

[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

[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.

[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

[alexa]

Thank you for the reply.

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

[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

[.jp]

Hello,

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

Best Regards.

[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

[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.