6 Replies Latest reply on Aug 8, 2017 4:05 PM by Francisco Amores

    Procedure Insert into Process Logs execution fails

    Karolus

      Hi All,

       

      I have a problem with FDMEE during import from MSSQL view.

      Digging into ODI shows an error when running sub session ERP_GL_LOAD_BALANCES_DATA under step 44 - Lanuch ERP Source Adapter Scenario task 54 Procedure Insert into Process Logs execution fails as below.

      Anybody have an idea what is the problem? Missing access right to some directory? Missing table/view?

      ***************************

      Session Failed :34501 : ODI-1217: Session MSSQL (34501) fails with return code 7000.

      ODI-1226: Step Insert into Process Logs fails after 1 attempt(s).

      ODI-1232: Procedure Insert into Process Logs execution fails.

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

      Traceback (most recent call last):

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

      error

       

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

      ******************************

       

      regards

      Karol

        • 1. Re: Procedure Insert into Process Logs execution fails
          Francisco Amores

          which FDMEE version are you?

           

          can you show the lowest level error? go to the specific ODI step within the session and see the error

          • 2. Re: Procedure Insert into Process Logs execution fails
            Karolus

            Hi,

             

            FDMEE version is 11.1.2.4.210.012

            Error I showed is the lowest level from ODI, here is the path how it was called:

            ERP_GL_LOAD_BALANCES_DATA under step 44 - Lanuch ERP Source Adapter Scenario task 54 Procedure Insert into Process Logs execution fails as below

             

            Full log is as following:

            Session Failed :34501 : ODI-1217: Session MSSQL (34501) fails with return code 7000.

            ODI-1226: Step Insert into Process Logs fails after 1 attempt(s).

            ODI-1232: Procedure Insert into Process Logs execution fails.

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

            Traceback (most recent call last):

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

            error

             

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

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

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

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

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

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

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

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

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

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

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:50)

                at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:93)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)

                at oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:49)

                at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:173)

                at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:140)

                at com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:271)

                at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)

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

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

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

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

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

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

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

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

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:50)

                at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:93)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)

                at oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:49)

                at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:173)

                at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:140)

                at com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:271)

                at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)

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

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

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

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

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

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

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

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

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

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

            Caused by: Traceback (most recent call last):

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

            error

             

                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.core.Py.makeException(Py.java:1174)

                at org.python.core.Py.makeException(Py.java:1178)

                at org.python.pycode._pyx282.f$0(<string>:149)

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

                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 com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

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

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

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

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

                at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)

                at oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:49)

                at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:173)

                at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:140)

                at com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:271)

                at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)

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

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

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

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

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

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

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

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

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

                at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)

                at oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:49)

                at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:173)

                at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:140)

                at com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:271)

                at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)

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

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

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

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

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

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

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

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

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

                ... 1 more

             

            regards

            Karol

            • 4. Re: Procedure Insert into Process Logs execution fails
              Ian50

              I have the same error (with an Oracle UDA source).

              FDMEE is 11.1.2.4.210.012

               

              Ian

              • 5. Re: Procedure Insert into Process Logs execution fails
                Francisco Amores

                but is the odi scenario executed?

                • 6. Re: Procedure Insert into Process Logs execution fails
                  Francisco Amores

                  I would suggest you edit the procedure in ODI and add debug code. This should be logged in the fdmee process log (set to log level 5)

                   

                  don't forget to regenerate the odi scenario after changes

                   

                  can you attach the fdmee process log?