ORA-20100 ORA-20003 ORA-06512 Errors When Trying to Upload Table Descriptor (Doc ID 1076174.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Life Sciences Data Hub - Version 2.1.2 and later
Information in this document applies to any platform.

Symptoms

Users notice the following error messages when trying to upload Table Descriptor in Loadset:

Error:
java.sql.SQLException: ORA-20100: *** ERROR:
CDR_ATK_UTILS.createMultipleOperators - ORA-20003: *** Error in
CreateMultipleOperators at stage = Upload Column for Data Operator AE in
multi-table mode. - ORA-20003: *** Error in UploadOperatorColumns at stage =
Attempting to creating column# 14 of 15 - AEYN_DLV for DOB=481280001 in
AppArea=48140001 - ORA-20001: *** Error in CreateDOBColumn at stage=Calling
CreateCDRVar for AEYN_DLV - User-Defined Exception ORA-06512: at
"APPS.CDR_ATK_UTILS", line 859 ORA-06512: at "APPS.CDR_ATK_UTILS", line 1640
ORA-06512: at line 1

For example, of all two attributes for code list for SEX:

DVG Number Value Text DVG Long Value
1 M Male
2 F Female

The error seems to occur only on views where variables have the DVG Long Value in the views (in the examples the suffix '_DVL' notes the DVG Long value attribute of the variable).  Users are able to load OC RDC data for the DEMO study (the views did not contain any DVG Long Values).

They notice the behavior on numeric value of code (known as DVG Number in Oracle Clinical), short value of code (known as Value Text in Oracle Clinical), and long value of code (known as DVG Long Value in Oracle Clinical.



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