"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 JULY 28, 2017

Applies to:

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

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
... 

     In ODI 12.2.1.x, the ODI-26182 error is followed by:

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

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 hundreds of Community platforms