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 JULY 03, 2018

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 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:

ODI-12308: Restore Deleted operation failed.
java.lang.RuntimeException: com.sunopsis.dwg.SQLWorkReposException:
ORA-00001: unique constraint (<REPO_SCHEMA>.PK_VCS_VERSIONW) violated

 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.