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 JULY 13, 2023
Applies to:
Oracle Life Sciences Data Management Workbench - Version 2.4.7 and laterInformation 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
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 |