"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 DECEMBER 04, 2019

Applies to:

Symptoms

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

ODI-1226: Step <STEP> 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 <LOAD_PLAN> (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.

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.