"ODI-10245: Cannot import SNP_KMTEMPLATEJOIN null" is Received when Applying a Patch Deployment Archive in ODI 12C (Doc ID 2424875.1)

Last updated on NOVEMBER 19, 2021

Applies to:

Symptoms

In a new Oracle Data Integrator (ODI) production environment (master, work and execution repository newly created), a patch deployment archive from the development environment fails with the following error:

FAILED: ODI-11002: Error occurred while importing Objects ODI-11002: Error occurred while importing Objects ODI-10245: Cannot import SNP_KMTEMPLATEJOIN null (with global id: <GUID> and internal id: <ID>) belonging to <NAME>LKM (with global id: <GUID> and internal id: <ID>) because its referenced object is not found in the target repository.

The issue has been reproduced by support with the following steps but it may be possible to encounter the issue using different steps:

1. From the existing work repository in the development environment, create a deployment archive from the full repository: Team/Deployment Archives/Create from repository/Full repository (all physical topology objects included).
2. Create new schemas for master/work/execution in the production environment's DB as sys as sysdba
3. Create master/work repository with ODI Studio (New gallery)
4. Initiate the master/work repositories from the deployment export.
5. When trying to import any Patch deployment archive (Team -> Deployment Archives -> Patch Deployment Repository -> with or without including any physical objects) into the new environment, the error appears.
   
   
   

Changes

Cause

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