3 Replies Latest reply on Dec 12, 2014 8:33 AM by Jeevan Kadam

    Problem  With IKM Oracle Multi Table Insert in Odi

    2805524

      Hi,

       

      While working with Ikm oracle multiple table insert,data was sucessfully load in first interface but data was unable to load remaining two interfaces.It don't show any errors by executing package.If we execute second and third interface separately then following error is like

       

      org.apache.bsf.BSFException: exception from Jython:

      Traceback (most recent call last):

        File "<string>", line 1, in <module>

       

       

      Defining a target, but no source has been defined, yet. Please define source first.

       

       

        at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

        at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

        at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

        at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

        at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

        at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

        at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

        at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

        at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

        at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

        at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

        at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)

        at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)

        at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

        at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)

        at java.lang.Thread.run(Thread.java:744)

      Caused by: Traceback (most recent call last):

        File "<string>", line 1, in <module>

       

       

      Defining a target, but no source has been defined, yet. Please define source first.

       

       

        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._pyx3.f$0(<string>:1)

        at org.python.pycode._pyx3.call_function(<string>)

        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)

        ... 19 more

       

       

       

      Regards,

      Sai