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.
RELATED ARTICLES
Add Comment