My Oracle Support Banner

Installation Of Production Lifecycle Transformation Fails With ORA-06510: PL/SQL: unhandled user-defined exception (Doc ID 2502578.1)

Last updated on JUNE 07, 2021

Applies to:

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

Symptoms

The following error occurs when installing a transformation in the Production lifecycle:


XFM_INSTALL:14-NOV-18 20:50:22:Model deployment has failed with errors.Please see message stack for details.
Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin <SCHEMANAME>.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 10070
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.DME_DF_XFORM_MAP", line 6829
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.DME_DF_XFORM_MAP", line 19965
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 12548
ORA-06512: at <SCHEMANAME>.PLSQL_UTIL_PROG_PKG", line 4

Changes

 Transformation is promoted from the Development to the Production lifecycle.

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.