"ODI-26182 Object was modified by another user and cannot be saved" Or "ODI-10196: Error while accessing the repository" When Generating an ODI 12c Scenario From a Mapping Already Open in Editor And Then Attempting to Save Further Changes in Editor (Doc ID 1956212.1)

Last updated on OCTOBER 04, 2022

Applies to:

Symptoms

When a user has a Mapping open in the Mapping editor, generates a Scenario from it, then attempts to save further changes in the editor, this fails with:

ODI-26182 Object was modified by another user and cannot be saved

    Which is followed by the stack trace in ODI 12.1.3:

oracle.odi.core.repository.ConcurrencyFailureException: ODI-10143: Error while accessing the ODI repository.
Exception [EclipseLink-5006]
...
...
Caused by: javax.persistence.OptimisticLockException: Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.OptimisticLockException
Exception Description: The object [Mapping New_Mapping1[27] owning folder=MAPPING1.First Folder] cannot be updated because it has changed or been deleted since it was last read.
Class> oracle.odi.domain.mapping.Mapping Primary Key> 27
... 

ODI-10182: Uncategorized exception during repository access.
ODI-10196: Error while accessing the repository.

Exception Description: The object [Mapping MY_MAPPING[1053] owning folder=MAPPING1.Mappings.MY_MAPPING] cannot be merged because it has changed or been deleted since it was last read.
Class> oracle.odi.domain.mapping.Mapping

Cause

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