"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
Oracle Data Integrator - Version 126.96.36.199.0 and later Information in this document applies to any platform.
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 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 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
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