My Oracle Support Banner

Error When Installing Transformation Post Constructive and Destructive Changes on DMW 3.0 (Doc ID 2754323.1)

Last updated on FEBRUARY 24, 2021

Applies to:

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

Symptoms

DMW 3.0, users are facing an issue while installing a Transformation post performing constructive and destructive changes in 3.0.

ERROR
------------
XXXX.XXXX to trgTabId.trgColId => XXXX.XXXX FAILED with error message - ORA-00001: unique constraint (.) violated in Package DME_CTXT_MAPPING Procedure insertCtxtMapObjColl
XFM_INSTALL:05-JAN-21 19:39:59:*** ERROR: *** ERROR: Insert Ctxt Map srcTabId.srcColId => XXXX.XXXX to trgTabId.trgColId => XXXX.XXXX FAILED with error message - ORA-00001: unique constraint (.) violated in Package DME_CTXT_MAPPING Procedure insertCtxtMapObjColl
XFM_INSTALL:05-JAN-21 19:39:59:*** ERROR: *** ERROR: Insert Ctxt Map srcTabId.srcColId => XXXX.XXXX to trgTabId.trgColId => XXXX.XXXX FAILED with error message - ORA-00001: unique constraint (.) violated in Package DME_CTXT_MAPPING Procedure insertCtxtMapObjColl


STEPS TO REPLICATE
-------------------------
1. Delete column.
2. Change the datatype from NUMBER to VARCHAR2.
3. Rename one existing table as "_OLD" and recreate the same table. Map the newly created table in transformation.
4. Install transformation.




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
References


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