Metadata Reload Failure In DMW after Change in Clinical One Study Design (Doc ID 2947149.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

On Oracle Life Sciences Data Management Workbench (DMW) 3.2 version,
when trying to reload metadata from Clinical One, after a new version has been pushed to Clinical One testing Container, the following error is generated:

ERROR
--------
Setting the status of the data source to STATUS_METADATA_ERROR
Released the lock..
Raising the error
Job failed with error(s). :: 05-02-2023 10:48:55.484
ORA-20200: *** ERROR: Error While calling create_tabs_in_c1_dm: U:1:ORA-01422: exact fetch returns more than requested number of rows in Package cdr_df_table Procedure createColumnUser-Defined Exception
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_DEF_C1", line 1716
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 15749
ORA-06512: at "CDR_WEDB_522_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1


The issue can be reproduced with the following steps.
1. Go to DMW and navigate to affected study and CLINICAL ONE data model configuration screen.
2. See the Difference in the study version between Clinical One and DMW.
3. Click the load metadata in development button and see the error log when the job fail.

Cause

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