mO SharemO Share

"Connection failed for GINESYS error:Column: 'invariantname is constrained to be unique value 'Oracle DataAccess Client' is already present.”

Owned by
Ginesys Knowledge Team
Last updated: Nov 07, 2017 by
Suchandra Nandi (Unlicensed)
1 min read

SYMPTOMS

When user is trying to run Ginesys Web Reports and the following error message is displayed - 

Connection failed for GINESYS error:Column: 'invariantname is constrained to be unique value 'Oracle DataAccess Client' is already present.

CAUSE

1. One of the probable causes for this issue is installating or uninstalling of ODAC multiple times.

RESOLUTION

1. Resolution for the above cause is to remove one row from machine.config file of Microsoft.Net folder.

The file can be found in the following path: \\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\Machine.config

The row to be deleted is given below:

 "<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.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />

Check before row deletion

Note: Please check that the row with the above given value exists twice in the machine.config file. Now remove the last row with these values.

This should resolve your issue, in case you face it again please contact our Ginesys Care portal - https://care.ginesys.in/