CDA - Complete Warehouse Load Plan Is Failing

(Doc ID 2055661.1)

Last updated on OCTOBER 02, 2017

Applies to:

Oracle Health Sciences Clinical Development Analytics - Version 3.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 3.1.0 version, ETL related issues

When attempting to execute CDA - Complete Warehouse load plan, the ODI task is failing and
the following errors occurs.

ERROR
-----------------------

Looking at the first failing scenario, the error stack looks like:

 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to ODI and go to Load Plans and Scenarios tab
2. Right-click the CDA - Complete Warehouse load plan and select Run.
3. The scenarios from 6>end are failing


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms