Monthly Archives: April 2016

ODI-1246: The Logical Schema has not been set

Scenario ODI Scenario errored
Error ODI-1217: Session LOAD_AGG_YEAR_WEEK (22467175) fails with return code 7000.
ODI-1226: Step LOAD_AGG_YEAR_WEEK fails after 1 attempt(s).
ODI-1232: Procedure LOAD_AGG_YEAR_WEEK execution fails.
ODI-1246: The Logical Schema has not been set for LOAD_AGG_YEAR_WEEK.
Cause No Logical schema set for the ODI procedure

ODI-1255: Tried stopping an ODI scenario – Insufficient privileges to stop the session

Scenario Tried stopping an ODI scenario from running
Error oracle.odi.runtime.agent.invocation.InvocationException: ODI-1255: Session PKG_OUT_REPORT_FEED_PL (34310225) could not be stopped by Agent UATREP: insufficient privileges to stop the session.
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:260)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeStopSession(RemoteRuntimeAgentInvoker.java:730)
at oracle.odi.ui.action.SnpsPopupActionKillImmediateHandler.actionPerformed(SnpsPopupActionKillImmediateHandler.java:127)
at com.sunopsis.graphical.frame.edit.EditFrameSnpSession$ActionForMenuToolButton.actionPerformed(EditFrameSnpSession.java:276)
Fix Stop the scenario using admin ODI user