"ODI-1278: Load plan instance X, run Y does not exist in work repository" When Running a Load Plan (Doc ID 2303414.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

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

Symptoms

On Oracle Data Integrator (ODI) Studio 12c, running a package scenario results in an error in the OdiStartLoadPlan task:

ODI-1226: Step LP_Test fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-30109: Error while polling run status of load plan LP_Test (instance id 1,998, run 1) for execution completion. Last polled status value: null.
  at com.sunopsis.dwg.tools.StartLoadPlan.waitForLpCompletion(StartLoadPlan.java:276)
  at com.sunopsis.dwg.tools.StartLoadPlan.actionExecute(StartLoadPlan.java:239)
  at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:219)
  at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:901)
  at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:582)
  ...
Caused by: ODI-1278: Load plan instance 1998, run 1 does not exist in work repository WORKREP.
  at oracle.odi.runtime.agent.loadplan.RepositoryUtil.getLoadPlanStatusList(RepositoryUtil.java:2477)
  at oracle.odi.runtime.agent.loadplan.LoadPlanProcessor.retrieveLoadPlanRunStatus(LoadPlanProcessor.java:1034)
  at com.sunopsis.dwg.tools.StartLoadPlan.waitForLpCompletion(StartLoadPlan.java:264)
  ... 27 more

This package was migrated from an identical second environment where it ran successfully. It was moved using Smart Export/Import.

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