My Oracle Support Banner

DMW: Data Model Installation with *.MDD File Results in Error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" (Doc ID 2474582.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

DMW 2.4.7, you are getting the following error message when installing a Data Model with *.MDD file:

ERROR
=======
SQL error = ORA-06502: PL/SQL: numeric or value error: character string buffer too small


Steps to Replicate
===============
1. Go to DMW
2. Create a Study
3. Create a Clinical Data Model 
4. Upload an *.mdd file
5. Install the Data Model, results in "Failure" in the Install Job Status.



In the job log, users see the errors:

Data model install fails and the following errors are generated:
SQL error = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Install status :$INSTSTATUSES$GENACTIVE
Termination status :$INSTTERMSTAT$NOTSET
Set work area status to install failed
.....
<DD-MON-RRRR> 04:04:17 AM-  INSTALL SDM UI FAILED..RAISING ERROR

Error from OWB/CDR DB Server-PLSQL Operator:  statement:"begin CDR_W<ID>_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;"  caught:java.sql.SQLException: ORA-20200: *** ERROR: Exception while Installing the Model..Hence cannot proceed further

ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_DF_MODEL_INSTALL", line 2441
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 11475
ORA-06512: at "CDR_W4D_CE4C81_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1




Changes

 You loaded an *.mdd file that has over 30 columns listed for the Primary Key.

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
Changes
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.