My Oracle Support Banner

DMW Transformation Install fails with error "ERROR: Changes that would cause data loss in Production Table instances are not allowed" (Doc ID 2750591.1)

Last updated on MARCH 24, 2021

Applies to:

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

Symptoms

On Oracle Health Sciences Data Management Workbench (DMW) 2.4.8.4 version, Transformation installation failed with below error:

Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin <WA_SCHEMA>.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 12559

The corresponding Data Model installation log had the below error

Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin <WA_SCHEMA>.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;"
 caught:java.sql.SQLException: ORA-20200: *** ERROR: Changes that would cause data loss in Production Table instances are not allowed.

Changes

 

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.