SYMPTOMS

An error occurred while trying to open DataExchange utility from Ginesys Head Office Launchpad. The following message appears after user tries to login into the utility.

GINESYSSchedulerService

Error occurred. ReasonColumn 'InvariantName' is constrained to be unique. Value 'Oracle.DataAccess.Client' is already present.
Stack Trace:
at GinApps.CacheManager.get_Instance()
at GinApps.Lists.Business.BusinessListConfigReader.GetListConfiguration(String listShortCode)
at DataExchange.UI.DataExchangeDashboardPresentation.BindToDomainModels()
at DataExchange.UI.DataExchangeDashboardPresentation..ctor()
at DataExchangeDashboard.UI.DataExchangeDashboard..ctor()
at DataExchangeDashboard.UI.frmDataExchange..ctor()
at DataExchangeDashboard.Program.Main()

CAUSE

Duplicate entries exist for 'Oracle.DataAccess.Client' under DBProviderFactories section in .NET Framework 4 configuration (machine.config), entries having mention as invariant="Oracle.DataAccess.Client. When the program tries to load the information of DB Providers which is mentioned in machine.config it detects the duplicate provider entries.

Config file:
machine.config

Area to look into:
DbProviderFactories section.

RESOLUTION

• Open the machine.config file from the path <System Drive>\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config.

• Then find the <DbProviderFactories> section under <system.data> tag where we can see duplicate entries of “Oracle.DataAccess.Client“ with various version. Remove one entry which is older with respect to version ( 4.121.1.0 & 4.121.2.0) & keep the current version. Here we will remove the version 4.121.1.0 .

• Then save the machine.config file & check the DataExchange Utility again.

As an example of duplicate entries shown below :

RELATED ARTICLE