My Oracle Support Banner

Not Able to Load Data From Inform Model (Doc ID 2514757.1)

Last updated on OCTOBER 02, 2019

Applies to:

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

Symptoms

While loading the data from InForm trial, the data load is failing.

The logs show the following:

Differences where found when comparing the metadata installed in DMW with the metadata in the InForm database.
----------
Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin <CDR_SCHEMA>.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;" caught:java.sql.SQLException: ORA-20200: *** ERROR: InForm_Submit:Datasource is found - User-Defined Exception
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_INFORM_MODEL", line 2619
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 14294
ORA-06512: at "<CDR_SCHEMA>.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

When trying to load Metadata from InForm the following error occurs in the log:

Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin CDR_W####_#####_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;" caught:java.sql.SQLException: ORA-20200: *** ERROR: InForm_Metadata_Submit:InForm_Metadata_Submit:Error locating metadata data model: ORA-01403: no data found - User-Defined Exception
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_INFORM_MODEL", line 3365
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 14299
ORA-06512: at "<CDR_SCHEMA>.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1


STEPS
---------
The issue can be reproduced at will with the following steps:
1. INFORM_MANUAL_DATA
2. INFORM_METADATA


Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.