Automate BPA 9.0.4 Unhandled Exception with Oracle

Product Feature: Installation / Upgrade


 

Issue

Automate BPA 9.0.4 Unhandled Exception with Oracle

System.AggregateException: A Task's exception(s) were not observed either by Waiting on the Task or accessing its Exception property.

Cause

Absence of a valid ODAC installation.

Resolution

UPDATED: November 27, 2017
The ODAC needs to be installed outside of BPA and is something Automate do not provide. The ODAC is required to connect to an Oracle database whether or not a user is connecting to Oracle with BPA or any other application. 
The ODAC files are on Oracle's web site: http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html 

User needs to make sure to install the ODAC that matched the Oracle version they are using.