My Oracle Support Banner

Although the Upgrade from ODI 11g to ODI 12.2.1.4.200618+ Succeeds, the Interfaces Are Not Upgraded and Subsequentially No Mappings Are Available in ODI 12c Studio (Doc ID 2724150.1)

Last updated on NOVEMBER 27, 2020

Applies to:

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

Symptoms

In the process of upgrading Oracle Data Integrator (ODI) Repositories from 11g to 12.2.1.4.200618 (or later) bundle patch...

... although the UA succeeds, and states that all the Interfaces have been converted:

Work Repository <NAME>: all interfaces - <TOTAL NUMBER>, converted - <TOTAL NUMBER MINUS 1>, failed - 1

... it appears that none of the 11g Integration Interfaces has been upgraded.

Post upgrade, the SNP_POP table still contains all the records, while SNP_MAPPING is empty.

When examining the log file generated by the UA, the following messages are observed:

...
A base component KM is specified for KM, but it is not found. KM: XKM Oracle Extract Base KM: XKM SQL Extract
  at oracle.odi.scripting.odixml.MappingBuilderXMLParser$7.doInTransaction(MappingBuilderXMLParser.java:767)

    and

java.lang.NullPointerException
  at oracle.odi.domain.mapping.MapRootContainer.rebuildPropertiesList(MapRootContainer.java:2247)
  at oracle.odi.core.persistence.toplink.handlers.MappingRebuildPropertiesHandler.rebuildProperties(MappingRebuildPropertiesHandler.java:32)
  at oracle.odi.core.persistence.toplink.handlers.MappingRebuildPropertiesHandler.preInsert(MappingRebuildPropertiesHandler.java:19)
  at org.eclipse.persistence.descriptors.DescriptorEventManager.notifyListener(DescriptorEventManager.java:715)
  at org.eclipse.persistence.descriptors.DescriptorEventManager.notifyListeners(DescriptorEventManager.java:769)
  at org.eclipse.persistence.descriptors.DescriptorEventManager.notifyListeners(DescriptorEventManager.java:775)
  at org.eclipse.persistence.descriptors.DescriptorEventManager.executeEvent(DescriptorEventManager.java:228)
  at org.eclipse.persistence.descriptors.changetracking.DeferredChangeDetectionPolicy.calculateChanges(DeferredChangeDetectionPolicy.java:91)
  at org.eclipse.persistence.descriptors.changetracking.DeferredChangeDetectionPolicy.calculateChangesForNewObject(DeferredChangeDetectionPolicy.java:52)
  at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.calculateChanges(UnitOfWorkImpl.java:665)
  at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:441)
  at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:874)
  at oracle.odi.core.persistence.jpa.JpaOdiEntityManager.flush(JpaOdiEntityManager.java:181)
  ... 31 more

    and

oracle.odi.domain.mapping.properties.PropertyException: Property: TARGET_LOAD_ORDER does not exist for this object.
  at oracle.odi.domain.root.PropertyOwner.getProperty(PropertyOwner.java:590)
  at oracle.odi.domain.root.PropertyOwner.getExpressionPropertyValue(PropertyOwner.java:543)
  at oracle.odi.domain.mapping.Mapping.getTargetLoadOrderText(Mapping.java:988)
  at oracle.odi.domain.mapping.MapComponentOwner.removeComponent(MapComponentOwner.java:744)
  at oracle.odi.domain.mapping.MapComponentOwner.removeComponent(MapComponentOwner.java:650)
  at oracle.odi.domain.mapping.MapComponentOwner.removeComponent(MapComponentOwner.java:773)
  at oracle.odi.domain.mapping.MapComponentOwner.removeComponent(MapComponentOwner.java:650)
  at oracle.odi.domain.mapping.component.Dataset.removeSourceFromDataset(Dataset.java:1628)
  at oracle.odi.domain.project.interfaces.SourceDataStore.removeExistingMapComponent(SourceDataStore.java:1801)
  at oracle.odi.domain.project.interfaces.SourceDataStore.addDataStorageDele(SourceDataStore.java:1824)
  at oracle.odi.domain.project.interfaces.SourceDataStore.setCompUnderlyingOdiDataStore(SourceDataStore.java:1654)
  at oracle.odi.domain.project.interfaces.SourceDataStore.setUnderlyingOdiDataStore(SourceDataStore.java:802)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.createSourceTab(InterfaceToMapping.java:1525)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.createDataset(InterfaceToMapping.java:1448)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertInterfaceToMapping(InterfaceToMapping.java:2592)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertInterfaceDependencies(InterfaceToMapping.java:3519)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.access$300(InterfaceToMapping.java:171

    and

oracle.odi.domain.mapping.properties.PropertyException: Property: DEFAULT_STAGING_LOCATION_NAME does not exist for this object.
  at oracle.odi.domain.root.PropertyOwner.getProperty(PropertyOwner.java:590)
  at oracle.odi.domain.root.PropertyOwner.setPropertyValue(PropertyOwner.java:357)
  at oracle.odi.domain.mapping.Mapping.setDefaultStagingLocationName(Mapping.java:1116)
  at oracle.odi.domain.project.OdiInterface.setCompLogicalSchema(OdiInterface.java:5121)
  at oracle.odi.domain.project.OdiInterface.access$5300(OdiInterface.java:169)
  at oracle.odi.domain.project.OdiInterface$StagingArea.setLogicalSchema(OdiInterface.java:1773)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.createOdiInterface(InterfaceToMapping.java:1008)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertInterfaceToMapping(InterfaceToMapping.java:2577)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertInterfaceDependencies(InterfaceToMapping.java:3519)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.access$300(InterfaceToMapping.java:171)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping$9$1.doAction(InterfaceToMapping.java:3561)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping$9.doInTransaction(InterfaceToMapping.java:3554)
  at oracle.odi.core.persistence.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:100)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertInterfaces(InterfaceToMapping.java:3549)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertInterfaces(InterfaceToMapping.java:3250)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertAllInterfaces(InterfaceToMapping.java:3168)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertAllInterfaces(InterfaceToMapping.java:3661)
  at oracle.odi.setup.support.WorkRepositorySetupImpl.upgradeWorkRepository(WorkRepositorySetupImpl.java:1420)
  at oracle.odi.setup.support.WorkRepositorySetupImpl.upgradeWorkRepository(WorkRepositorySetupImpl.java:1596)
  at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeWork(RepositoryUpgradeServiceImpl.java:164)
  at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:616)
  at oracle.ias.update.plugin.odi.ODIPlugin.upgrade(ODIPlugin.java:432)
  at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:730)
  at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:736)
  at oracle.ias.update.PhaseProcessor$UpgradeProcessor.runStepPhase(PhaseProcessor.java:775)
  at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:382)
  at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1178)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)

    and

oracle.odi.domain.mapping.properties.PropertyException: Property: DATA_FORMAT does not exist for this object.
  at oracle.odi.domain.root.PropertyOwner.getProperty(PropertyOwner.java:590)
  at oracle.odi.domain.root.PropertyOwner.getPropertyValue(PropertyOwner.java:347)
  at oracle.odi.domain.root.PropertyOwner.getStringPropertyValue(PropertyOwner.java:517)
  at oracle.odi.domain.mapping.MapAttribute.setDataFormat(MapAttribute.java:2235)
  at oracle.odi.domain.mapping.MapAttribute.syncWithColumn(MapAttribute.java:2287)
  at oracle.odi.domain.mapping.component.DefaultDelegate$DefaultAttributeDelegate.customSyncAttribute(DefaultDelegate.java:468)
  at oracle.odi.domain.mapping.MapAttribute.syncAttribute(MapAttribute.java:1454)
  at oracle.odi.domain.mapping.MapAttribute.bindTo(MapAttribute.java:1428)
  at oracle.odi.domain.project.interfaces.TargetColumn.setCompUnderlyingOdiColumn(TargetColumn.java:1530)
  at oracle.odi.domain.project.interfaces.TargetColumn.setUnderlyingOdiColumn(TargetColumn.java:721)
  at oracle.odi.domain.project.interfaces.TargetColumn.(TargetColumn.java:201)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.createPopCol(InterfaceToMapping.java:2015)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.createOdiInterface(InterfaceToMapping.java:1062)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertInterfaceToMapping(InterfaceToMapping.java:2577)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertInterfaceDependencies(InterfaceToMapping.java:3519)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.access$300(InterfaceToMapping.java:171)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping$9$1.doAction(InterfaceToMapping.java:3561)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping$9.doInTransaction(InterfaceToMapping.java:3554)
  at oracle.odi.core.persistence.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:100)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertInterfaces(InterfaceToMapping.java:3549)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertInterfaces(InterfaceToMapping.java:3250)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertAllInterfaces(InterfaceToMapping.java:3168)
  at com.sunopsis.repository.manager.upgrade.InterfaceToMapping.convertAllInterfaces(InterfaceToMapping.java:3661)
  at oracle.odi.setup.support.WorkRepositorySetupImpl.upgradeWorkRepository(WorkRepositorySetupImpl.java:1420)
  at oracle.odi.setup.support.WorkRepositorySetupImpl.upgradeWorkRepository(WorkRepositorySetupImpl.java:1596)
  at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeWork(RepositoryUpgradeServiceImpl.java:164)
  at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:616)
  at oracle.ias.update.plugin.odi.ODIPlugin.upgrade(ODIPlugin.java:432)
  at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:730)
  at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:736)
  at oracle.ias.update.PhaseProcessor$UpgradeProcessor.runStepPhase(PhaseProcessor.java:775)
  at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:382)
  at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1178)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)

Expected Behavior:

The upgrade of the same 11g Repositories succeeds if using ODI 12.2.1.4.200413 bundle patch.

It is expected that the upgrade also succeeds when using ODI 12.2.1.4.200618 (or later) bundle patch.

Cause

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
Symptoms
Cause
Solution
References


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