My Oracle Support Banner

"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:

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


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: 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.function.SnpsFunctionBaseRepositoryConnected.execute(
  at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(
  at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(
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(
  at oracle.odi.runtime.agent.loadplan.LoadPlanProcessor.retrieveLoadPlanRunStatus(
  ... 27 more

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




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

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