My Oracle Support Banner

Error "ORA-00001: Unique Constraint" when Restoring Deleted Object from SVN in ODI 12c (Doc ID 2414405.1)

Last updated on MAY 09, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 to 12.2.1.4.0 [Release 12c]
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.

Symptoms

Oracle Data Integrator (ODI) 12c is configured with Apache Subversion (SVN).

When attempting to restore a deleted object from SVN, the following error occurs:

 To reproduce:

  1. Create a Mapping and add to VCS.
      
  2. Delete the Mapping.
     
  3. Add a new Version:

    • EITHER:

         Team > VCS Actions > Pending Changes
         Select the mapping that has been deleted along with the project and folder, select to create a new version
               
    • OR alternatively:

         The same can be achieved by selecting the parent folder or project of the deleted a mapping and create a new version
                
  4. Team > VCS Actions > Restore Deleted Object
          
  5. Select the time frame => the Mapping is found
          
  6. Select the "restore selected object" icon
    => ODI-12308: Restore Deleted operation failed.
             
  7. Select the "restore selected object" icon a second time:
    => this time the object can be restored.

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!

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