My Oracle Support Banner

The Transformation Installation Fails: ORA-1758: table must be empty to add mandatory (NOT NULL) column (Doc ID 2499069.1)

Last updated on OCTOBER 09, 2019

Applies to:

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


On : version, Data Model

DMW Prod : transformation installation - Installation Failing

The user initiated the installation and its failing with the attached error log now.

JAN-19 20:13:16:------------------------- ********* ERROR ********* -------------------------
16-JAN-19 20:13:16:**************** START TRANSFORMATION DIAGNOSTICS ***************************************
DME_DEBUG_XFORM_MAP.duplicateMapCheck:16-JAN-19 20:13:16:START:DIAG_CHECK#1-DME_DEBUG_XFORM_MAP.duplicateMapCheck
DME_DEBUG_XFORM_MAP.duplicateMapCheck:16-JAN-19 20:13:16:Duplicate Table Maps Check..
DME_DEBUG_XFORM_MAP.duplicateMapCheck:16-JAN-19 20:13:16:No duplicate table maps found!
DME_DEBUG_XFORM_MAP.duplicateMapCheck:16-JAN-19 20:13:16:Duplicate Column Maps check..
16-JAN-19 20:13:16:Finding Duplicate Column Maps for Table Map: DMW_DOMAIN > EARLY_PRODUCTION_STUDIES > STUDY1 >  INF_STD_xForm > MY_xForm .. DME_DEBUG_XFORM_MAP.duplicateMapCheck:16-JAN-19 20:13:16:No duplicate column maps found!
AN-19 21:17:05:**************** END TRANSFORMATION DIAGNOSTICS *****************************************
XFM_INSTALL:16-JAN-19 21:17:05:dme_debug_xform_map.diagnoseXfm returned invalidMap=$YESNO$NO
Error from OWB/CDR DB Server-PLSQL Operator:  statement:"begin CDR_W517_BF7F71_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;"  caught:java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.DME_INST_XFORM_MAP", line 12439
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.DME_DF_XFORM_MAP", line 20470
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 14315
ORA-06512: at "CDR_W517_BF7F71_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

Job status is not Aborted/Pending Aborted. So, setting completion status:$EXECSTATUSES$FAILED
Finished post-processing. Elapsed time 00:00:00 :: 01-16-2019 21:17:05


The user initiated the transformation installation and it failed.




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

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