8 Replies Latest reply on Sep 28, 2016 2:04 PM by ashud1

    ODI-1241: Oracle Data Integrator tool execution fails.

    3236194

      Hi All,

       

      Currently I am using ODI 11g and when I execute a package got below error.

      Please help me out to figure out and fix this issue.

       

      ODI-1226: Step Execution of the Scenario FTI_LOAD version 001 fails after 1 attempt(s).

      ODI-1241: Oracle Data Integrator tool execution fails.

        at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.getExceptionOnStepTaskFailure(SnpSessTaskSqlS.java:53)

        at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(SnpSessStep.java:1127)

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

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

       

       

      Thanks,

      Mahendra Biradar

        • 1. Re: ODI-1241: Oracle Data Integrator tool execution fails.
          ashud1

          hi,

          can you please check the scenario which you have placed in the package ?

           

          thanks

          • 2. Re: ODI-1241: Oracle Data Integrator tool execution fails.
            3236194

            Hi,

            I am calling FTI_LOAD scenario from ETL_LOAD package scenario.

            i.e calling a scenario from another scenario.

            FTI_LOAD's scenario is the last step in ETL_LOAD scenario.

            all the steps in ETL_LOAD package scenario got succeed except  FTI_LOAD scenario step.

             

            Thanks,

            Mahendra Biradar

            • 3. Re: ODI-1241: Oracle Data Integrator tool execution fails.
              ashud1

              Hi,

               

              can you please check that scenario is there(present) in the designer, if yes can you please run it manually and see that is the error coming ?

               

              thanks

              • 4. Re: ODI-1241: Oracle Data Integrator tool execution fails.
                3236194

                Hi,

                Scenario is present in the package.

                Sure as you said i will run it manually then i will get back to you.

                 

                Thanks

                • 5. Re: ODI-1241: Oracle Data Integrator tool execution fails.
                  3236194

                  Hi,

                  I have re-run that scenario and one of the interface is failing even  though target connection is successful.

                  Please find error details below .

                   

                  ODI-1228: Task SrcSet0 (Loading) fails on the target ORACLE connection ORACLE_FTI.

                  Caused By: java.sql.BatchUpdateException: IO Error: Connection reset

                    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)

                    at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:248)

                    at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(BatchSQLCommand.java:44)

                    at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)

                    at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)

                    at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:87)

                    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.RuntimeAgent.startScenario(RuntimeAgent.java:811)

                    at oracle.odi.runtime.agent.InternalRuntimeAgent.startScenario(InternalRuntimeAgent.java:52)

                    at com.sunopsis.dwg.tools.StartScen.startScenOnLocalAgent(StartScen.java:1009)

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

                    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.RuntimeAgent.startScenario(RuntimeAgent.java:811)

                    at oracle.odi.runtime.agent.InternalRuntimeAgent.startScenario(InternalRuntimeAgent.java:52)

                    at com.sunopsis.dwg.tools.StartScen.startScenOnLocalAgent(StartScen.java:1009)

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

                    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.RuntimeAgent.startScenario(RuntimeAgent.java:811)

                    at oracle.odi.runtime.agent.InternalRuntimeAgent.startScenario(InternalRuntimeAgent.java:52)

                    at com.sunopsis.dwg.tools.StartScen.startScenOnLocalAgent(StartScen.java:1009)

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

                    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.RuntimeAgent.startScenario(RuntimeAgent.java:811)

                    at oracle.odi.runtime.agent.InternalRuntimeAgent.startScenario(InternalRuntimeAgent.java:52)

                    at com.sunopsis.dwg.tools.StartScen.startScenOnLocalAgent(StartScen.java:1009)

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

                    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.RuntimeAgent.startScenario(RuntimeAgent.java:811)

                    at oracle.odi.runtime.agent.InternalRuntimeAgent.startScenario(InternalRuntimeAgent.java:52)

                    at com.sunopsis.dwg.tools.StartScen.startScenOnLocalAgent(StartScen.java:1009)

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

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

                  • 6. Re: ODI-1241: Oracle Data Integrator tool execution fails.
                    1049916

                    Hi 3236194

                     

                    This looks like a network problem. The connection is getting reset. See if the below mentioned thread is of any help:-

                    JDBC Connection Reset when using many processes on 64 bit system

                     

                    Thanks & Regards,

                    PV

                    • 7. Re: ODI-1241: Oracle Data Integrator tool execution fails.
                      3236194

                      Hi PV,

                       

                      I agree, I had reset JDBC connection with another schema and tested connection successfully.

                      may i know why this interface is running for long time and gets failed.

                       

                      I have run the interface and got below error.

                       

                      ODI-1228: Task SrcSet0 (Loading) fails on the target ORACLE connection ORACLE_FTI.

                      Caused By: java.sql.BatchUpdateException: IO Error: Connection reset

                        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)

                       

                      Please let me know the next process.

                       

                      Thanks

                      • 8. Re: ODI-1241: Oracle Data Integrator tool execution fails.
                        ashud1

                        hi,

                        connection rest could be caused by Firewall setting that you have. you can check that.

                        but speaking of the long running interface can you please check the below things

                        1. is the right KM is used ?

                        2. are most of the joins and other filtration are executing on the source side?

                         

                        is everything things is fine then Connection timeout setting at the firewall level.

                         

                        thanks