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 JULY 13, 2023
Applies to:
Oracle Life Sciences Data Management Workbench - Version 2.4.8.4 and laterInformation in this document applies to any platform.
Symptoms
On Oracle Life 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 |