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 OCTOBER 29, 2020

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


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.




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

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