TDoD error: The type initializer for 'Oracle.DataAccess.Client.OracleClientFactory' threw an exception

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

I am trying to use Test Data on Demand (TDoD) to expose the data pools I have created in Datamaker. When trying to start the TDoD service, I am seeing the following error messages in the log files:

2017-08-02 09:38:29,411 [4] FATAL GTWCFHost.GTWCFHost - Exception occurred while opening service host connection 
2017-08-02 09:38:29,448 [4] FATAL GTWCFHost.GTWCFHost - Exception: Exception has been thrown by the target of an invocation. 
2017-08-02 09:38:29,448 [4] FATAL GTWCFHost.GTWCFHost - Inner Exception: The type initializer for 'Oracle.DataAccess.Client.OracleClientFactory' threw an exception. 

This is the error I am seeing in the TDoD Config Editor: 
Unable to start TDoD Service in specified interval. Please check service logs for any error 

Environment

CA Test Data Manager (TDM)- Test Data on Demand (TDoD)

Cause

Here are common causes for this error message:

• You have more than one version of ODP.NET on your machine.
• You do not have the latest version of ODP.NET on your machine.
• The ODP.NET file is missing on your machine.

Resolution

Here are common resolutions for this error message:

1. Make sure there is only a single version of ODP.NET on the machine.  

2. Also, you might need to modify the machine.config file located at C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\ to reflect the latest ODAC version that exists on the system. 
- For example, update the version numbers on the lines similar to:  
<add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />  

3. Uninstall your existing ODP.NET installation in case it is corrupted. Then install a new version.  

4. If the 64-bit ODP.NET file was missing, you will need to add this, and then you will be able to start the TDoD service. 

Additional Information

If you experience any further issues, please open a support case by going to https://support.broadcom.com