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 18.104.22.168.0 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:
- Create a Mapping and add to VCS.
- Delete the Mapping.
- Add a new Version:
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
- Team > VCS Actions > Restore Deleted Object
- Select the time frame => the Mapping is found
- Select the "restore selected object" icon
=> ODI-12308: Restore Deleted operation failed.
- 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!