Hi ,
I have created a mapping Using Oracle SQLLDR LKM.
But its failing at "LKM File to Oracle (SQLLDR)" step, If i choose any other LKM like L"KM File to SQL" is loading with any failure.
i am using "Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production" and ODI 12c.
i have installed ODI agent also and tested its working fine.
Error Msg:
ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 29, in <module>
sqlldr 'TARGET_USER/********' control='C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.ctl' log='C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.log'
produced error. See C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.log and C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.out for details
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:163)
oracle.odi.km.exception.OdiKMException: oracle.odi.km.exception.OdiKMException: ODIKM-STDKM-10012: Load command
sqlldr 'TARGET_USER/********' control='C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.ctl' log='C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.log'
produced error. See C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.log and C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.out for details
at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:353)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:216)
at oracle.odi.runtime.agent.execution.interpreter.SessionTaskScriptingInterpretor.scripting(SessionTaskScriptingInterpretor.java:171)
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:2227)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:607)
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.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
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:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: Traceback (most recent call last):
File "<string>", line 29, in <module>
sqlldr 'TARGET_USER/********' control='C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.ctl' log='C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.log'
produced error. See C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.log and C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.out for details
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:163)
oracle.odi.km.exception.OdiKMException: oracle.odi.km.exception.OdiKMException: ODIKM-STDKM-10012: Load command
sqlldr 'TARGET_USER/********' control='C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.ctl' log='C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.log'
produced error. See C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.log and C:\Users\ODI_DEV\Desktop\agent\local_files/C_0SRC.out for details
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>:64)
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)
... 27 more
Please help me in this.
Thanks in advance.