1 Reply Latest reply on Aug 22, 2013 4:02 PM by user589294

    org.apache.bsf.BSFException: exception from Jython and java.io.FileNotFoundException: \ENTRY_STG_LINES.ctl (Access is denied)

    fa0b58cf-4de9-4770-bcf9-20880b9c9c1f

      Hi

       

      I am getting following issue,while executing the interface.

       

      Description :

      1)position based file to DB

      2)using LKM File to Oracle (SQLLDR) and IKM Oracle Incremental Update in Interface.

      3)Getting same issue while using the IKM Oracle Incremental Update.

       

      NOTE:Executing with out Agent.

       

      loading the Drop work view,Drop temp table,creating Temp Table,create work view,Generate CTL File and failed in loading Call sqldr

       

      Error Desc

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

      Traceback (most recent call last):

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

      Load Error: See /ADA_ENTRY_STG_LINES.log for details

       

       

        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:558)

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

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

        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:662)

      Caused by: Traceback (most recent call last):

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

      Load Error: See /ADA_ENTRY_STG_LINES.log for details

       

       

        at org.python.core.PyException.fillInStackTrace(PyException.java:70)

        at java.lang.Throwable.<init>(Throwable.java:181)

        at java.lang.Exception.<init>(Exception.java:29)

        at java.lang.RuntimeException.<init>(RuntimeException.java:32)

        at org.python.core.PyException.<init>(PyException.java:46)

        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.pycode._pyx13.f$0(<string>:59)

        at org.python.pycode._pyx13.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


      and


      NOTE:Executing with agent


      loading the Drop work view,Drop temp table,creating Temp Table,create work view and getting failed in Generate CTL File


      ErrorDesc

      java.io.FileNotFoundException: \ENTRY_STG_LINES.ctl (Access is denied)

        at java.io.FileOutputStream.open(Native Method)

        at java.io.FileOutputStream.<init>(FileOutputStream.java:194)

        at java.io.FileOutputStream.<init>(FileOutputStream.java:116)

        at com.sunopsis.dwg.tools.OutFile.actionExecute(OutFile.java:110)

        at com.sunopsis.dwg.function.SnpsFunctionBase.execute(SnpsFunctionBase.java:276)

        at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

        at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

        at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)

        at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.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:558)

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

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

        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:662)


       

      Description :

      1)position based file to DB

      2)using LKM File to Oracle (SQLLDR) and IKM Oracle Incremental Update in Interface.

      3)Getting same issue while using the IKM Oracle Incremental Update.

       

      Thanks in advance

      david