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

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
Ganendran
Posts: 10
Joined: Tue 21 Nov 2017 14:51

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

Post by Ganendran » Thu 10 Jan 2019 08:19

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
Devart Team
Posts: 2558
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Mon 14 Jan 2019 10:22

Please try reinstalling dbForge Compare Bundle for SQL Server.

Ganendran
Posts: 10
Joined: Tue 21 Nov 2017 14:51

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

Post by Ganendran » Tue 15 Jan 2019 13:21

Hi,

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

Regards,
Ganendran

alexa
Devart Team
Posts: 2558
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Thu 17 Jan 2019 12:40

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
Posts: 10
Joined: Tue 21 Nov 2017 14:51

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

Post by Ganendran » Thu 17 Jan 2019 12:58

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
Devart Team
Posts: 2558
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Mon 21 Jan 2019 13:49

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
Posts: 10
Joined: Tue 21 Nov 2017 14:51

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

Post by Ganendran » Wed 23 Jan 2019 15:14

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
Devart Team
Posts: 2558
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Fri 25 Jan 2019 12:14

Thank you for the reply.

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

Ganendran
Posts: 10
Joined: Tue 21 Nov 2017 14:51

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

Post by Ganendran » Fri 25 Jan 2019 12:53

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
Devart Team
Posts: 320
Joined: Wed 09 Sep 2009 06:55
Location: devart

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

Post by .jp » Thu 07 Feb 2019 13:53

Hello,

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

Best Regards.

Post Reply