OBIA 11g: Executing startloadplan.sh and getting ODI-1516: Can not start Load Plan: Load Plan with Name xxxx it Does Not Exist in Work Repository BIAPPS_WORKREP (Doc ID 1964724.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

You are trying to use a startloadplan.sh shell script which is provided by Oracle.


The Command is:
/oracle/software/obiee/OBIEE11g/Oracle_ODI1/oracledi/agent/bin/startloadplan.sh WXYZ Global -AGENT_URL=http://machine.xxx.xx.xx:15001/oraclediagent

This produces the following error:

OracleDI: Starting load plan WXYZ in context Global ...
2015-01-25 12:26:56.288 ERROR ODI-1651: Error while executing:
oracle.odi.runtime.agent.invocation.InvocationException: ODI-1516: Can not start load plan: load plan with name "WXYZ" does not exist in work repository BIAPPS_WORKREP.
  at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:265)
  at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeStartLoadPlan(RemoteRuntimeAgentInvoker.java:1135)
  at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeStartLoadPlan(RemoteRuntimeAgentInvoker.java:1058)
  at oracle.odi.StartLoadPlan.run(StartLoadPlan.java:114)
  at oracle.odi.StartLoadPlan.main(StartLoadPlan.java:142)

The name of the Load Plan in BIACM is: WXYZ
The name of the Generated Load Plan in ODI Studio is: WXYZ1_41_25015125_113315

However, when testing:-

/oracle/software/obiee/OBIEE11g/Oracle_ODI1/oracledi/agent/bin/startloadplan.sh WXYZ_1_41_25015125_113315 Global -AGENT_URL=http://machine.xxx.xx.xx:15001/oraclediagent

Then it worked. 

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