11g Upgraded Interface Using odiRef.getUser Function Errors Out when Executed in 12c as Mapping/package/scenario (Doc ID 2549637.1)

Last updated on FEBRUARY 25, 2022

Applies to:

Symptoms

In Oracle Data Integrator (ODI) 12.2.1.3, when attempting to execute any upgraded Interface from ODI 11g to ODI 12.2.1.3 which now executes as a mapping and or package, compiled and generated to a new scenario, fails if one of the attributes in the entity has a call to java method getUser()

  class'oracle.odi.domain.odireference.OdiRef’ getUser() , For eg. CRT_BY field has this expression “ odiRef.getUser("USER_NAME") “ and it fails for this step


ERROR:

oracle.odi.runtime.SessName: <SESSION_NAME>] [oracle.odi.runtime.SessId: <ID>] [oracle.odi.runtime.SessStep: 1/<PROCEDURE>/1] [oracle.odi.runtime.SessTask: 1.1/Procedure,<PROCEDURE>,<TASK>] [oracle.odi.runtime.ExecHierarchy: 12015733] Agent <AGENT> encountered an error: ODI-1226: Step <PROCEDURE> fails after 1 attempt(s).
[2019-04-18T11:38:15.249-04:00] [odi] [ERROR] [ODI-1217] [oracle.odi.agent] [tid: <TID>] [ecid: <ECID>] [oracle.odi.runtime.MrepExtId: <ID>] [oracle.odi.runtime.AgentName:<AGENT> [oracle.odi.runtime.ExecPhase: ExecuteTask] [oracle.odi.runtime.OdiUser: <SUPERVISOR>] [oracle.odi.runtime.WrepName:<WORKREP> [oracle.odi.runtime.ScenarioName: <SCENARIO>] [oracle.odi.runtime.ScenarioVer: <VER>] [oracle.odi.runtime.EntityGuid: <GUID>] [oracle.odi.runtime.SessName: <SESSION_NAME>] [oracle.odi.runtime.SessId: <ID>] [oracle.odi.runtime.SessStep: 1/<PROCEDURE>/1] [oracle.odi.runtime.SessTask: 1.1/Procedure,<PROCEDURE>,<TASK>] [oracle.odi.runtime.ExecHierarchy: <ID>] Session <SESSION_NAME> (<ID>) fails with return code 7000.[[
ODI-1217: Session <SESSION_NAME> (<ID>) fails with return code 7000.
ODI-1226: Step <STEP> fails after 1 attempt(s).
ODI-1232: Procedure <PROCEDURE> execution fails.
ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
  File "", line 3, in
Cannot Restart

at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:396)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:247)
at oracle.odi.runtime.agent.execution.interpreter.SessionTaskScriptingInterpretor.scripting(SessionTaskScriptingInterpretor.java:190)
at oracle.odi.runtime.agent.execution.SessionTask.scripting(SessionTask.java:105)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:49)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:21)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)
at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(StartScenRequestProcessor.java:85)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:917)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: Traceback (most recent call last):
  File "", line 3, in
Cannot Restart

at org.python.core.PyException.doRaise(PyException.java:219)
at org.python.core.Py.makeException(Py.java:1166)
at org.python.core.Py.makeException(Py.java:1170)
at org.python.core.Py.makeException(Py.java:1174)
at org.python.pycode._pyx0.f$0(:5)
at org.python.pycode._pyx0.call_function()
at org.python.core.PyTableCode.call(PyTableCode.java:165)
at org.python.core.PyCode.call(PyCode.java:18)
at org.python.core.Py.runCode(Py.java:1204)
at org.python.core.Py.exec(Py.java:1248)
at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)
at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)
... 27 more

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.