InForm Data Load Fails ORA-06512: at at "APPS.CDR_ATK_UTILS", "APPS.DME_INFORM_MODEL", "APPS.CDR_EXE_RUNTIME"

(Doc ID 2316044.1)

Last updated on OCTOBER 30, 2017

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.7 and later
Information in this document applies to any platform.

Symptoms

Working in DMW (PROD instance) and trying to load InForm data from an InForm Trial to a DMW study, in the Development lifecycle Data Model and hit:

Per job log:
Meta Data Processing
***************************************************************************
Differences where found when comparing the metadata installed in DMW with the metadata in the InForm database.
Data Load is skipped due to Data Source Status is Metadata Processing.
Please review the differences by executing a Metadata Comparison report.
Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin CDR_W517_BF7F71_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;" caught:java.sql.SQLException: ORA-20200: *** ERROR: getRemoteLoc:Getting Remote location and connection details - User-Defined Exception
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_INFORM_MODEL", line 2534
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 11790
ORA-06512: at "CDR_W517_BF7F71_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

Execution Status : Failed :: Job Status: Failure :: 10-02-2017 17:39:04

Please note that previously loaded metadata and data for this same study successfully, so the connection details are entered correctly in DMW.

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