Versions Compared

Old Version 16

changes.mady.by.user Arindam Banerjee

Saved on

compared with

New Version Current

changes.mady.by.user Arindam Banerjee

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

SYMPTOMS

...

In GinesysReport module , there is an option to test Ginesys Data Source connection from Server tab. Sometime users may face a problem while they are trying test Data Source of Ginesys . The below error message appeared on screen.

...

Info

Further Observation & Action taken :

  1. GINVIEW schema connection was successful while attempting using SQL plus.

  2. SYNC of Repository tab happened properly.

  3. IIS Reset performed but still Data Source test connection was not happening.

  4. No multiple Network adapter found in the system.

CAUSE

...

Duplicate entries exist for 'Oracle.DataAccess.Client' under DBProviderFactories section in .NET Framework 4 configuration (machine.config), entries having mention 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.

...

Sample file path:

C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

Area to look into:
DbProviderFactories section.

RESOLUTION

...

Note

Before modifying the machine.config file keep a backup of existing machine.config file.

  • 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 Data Source connection again.

...

Code Block
<system.data>
<DbProviderFactories>
  <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
  <add name="ODP.NET, Unmanaged Driver" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET, Unmanaged Driver" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
</system.data>

RELATED ARTICLE

...