I just installed MS SQL Server migration assistance for Oracle and migration assistance for Oracle extension. The installation was successful. I also installed oracle client 19. I am using SQL Server 2019 developer edition.
However when I launch MS SQL Server migration assistance for Oracle, it immediately gives following error:
Any clue what could be the issue here?
=====================
Cannot start because of an initialization error
Try to restart the application. If this problem remains, contact support group (please provide a log file).
Exception: One or more errors occurred.
site:
source:
InnerException #1: The type initializer for 'Microsoft.SSMA.Framework.Oracle.SqlServer.Initializer' threw an exception.
site: Void EnsureInitialize()
source: Microsoft.SSMA.Framework.Oracle.SqlServer
at Microsoft.SSMA.Framework.Oracle.SqlServer.Initializer.EnsureInitialize()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.SSMA.GUI.Product.SourceToTarget.Startup.GuiBootstrap`1.<InitializeAsync>d__11.MoveNext()
InnerException #2: The type initializer for 'Microsoft.SSMA.Framework.Oracle.Generic.OracleTypeProcessor' threw an exception.
site: Microsoft.SSMA.Framework.Oracle.Generic.OracleTypeProcessor get_Instance()
source: Microsoft.SSMA.Framework.Oracle.Generic
at Microsoft.SSMA.Framework.Oracle.Generic.OracleTypeProcessor.get_Instance()
at Microsoft.SSMA.Framework.Generic.Converters.Types.Default.DefaultContainerDescriptor.GetSourceTypeDescriptor(String id)
at Microsoft.SSMA.Framework.Generic.Converters.Types.Default.DefaultTypeMappingSchemaDescriptor.Read(XNode node, IContainerDescriptor contDescriptor)
at Microsoft.SSMA.Framework.Generic.Converters.Types.Default.DefaultContainerDescriptor.ReadSchemaDescriptors(XNode node, IDictionary`2 descriptors)
at Microsoft.SSMA.Framework.Generic.Converters.Types.Default.DefaultContainerDescriptor.Read(XNode node)
at Microsoft.SSMA.Framework.Oracle.SqlServer.Initializer.AddContainerDescriptor(SqlServerVersion serverVersion, String descriptorXml)
at Microsoft.SSMA.Framework.Oracle.SqlServer.Initializer.InitContainerDescriptor()
at Microsoft.SSMA.Framework.Oracle.SqlServer.Initializer.Initialize()
at Microsoft.SSMA.Framework.Oracle.SqlServer.Initializer..cctor()
InnerException #3: The type initializer for 'Microsoft.SSMA.Framework.Generic.Logging.Logger' threw an exception.
site: Microsoft.SSMA.Framework.Generic.Logging.Logger get_GenericLogger()
source: Microsoft.SSMA.Framework.Generic.Factories
at Microsoft.SSMA.Framework.Generic.Logging.Logger.get_GenericLogger()
at Microsoft.SSMA.Framework.Oracle.Generic.OracleTypeProcessor..cctor()
InnerException #4: Configuration system failed to initialize
site: Void PrepareConfigSystem()
source: System.Configuration
at System.Configuration.ConfigurationManager.PrepareConfigSystem()
at System.Configuration.ConfigurationManager.GetSection(String sectionName)
at System.Configuration.PrivilegedConfigurationManager.GetSection(String sectionName)
at System.Diagnostics.DiagnosticsConfiguration.GetConfigSection()
at System.Diagnostics.DiagnosticsConfiguration.Initialize()
at System.Diagnostics.DiagnosticsConfiguration.get_IndentSize()
at System.Diagnostics.TraceInternal.InitializeSettings()
at System.Diagnostics.TraceInternal.get_Listeners()
at System.Diagnostics.Trace.get_Listeners()
at Microsoft.SSMA.Framework.Generic.Logging.Logger..cctor()
InnerException #5: Section or group name 'oracle.manageddataaccess.client' is already defined. Updates to this may only occur at the configuration level where it is defined. (C:\Program Files\Microsoft SQL Server Migration Assistant for Oracle\bin\SSMAforOracle.exe.Config line 4)
site: Void ThrowIfErrors(Boolean)
source: System.Configuration
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey)