4 Replies Latest reply on Feb 16, 2012 1:30 PM by Himanshu Rai

    17009 : 08003 : java.sql.SQLRecoverableException: Closed Statement

    Himanshu Rai
      Hi,

      While running an interface I am getting the below error at the Load Data step,


      17009 : 08003 : java.sql.SQLRecoverableException: Closed Statement
      java.sql.SQLRecoverableException: Closed Statement
           at oracle.jdbc.driver.OracleClosedStatement.setObject(OracleClosedStatement.java:871)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:249)
           at oracle.odi.query.typemapping.PassThroughWriter.setValue(PassThroughWriter.java:35)
           at oracle.odi.query.JDBCTemplate.setValue(JDBCTemplate.java:199)
           at oracle.odi.runtime.agent.execution.sql.SQLCommand.bindResultSetColumns(SQLCommand.java:228)
           at oracle.odi.runtime.agent.execution.sql.SQLCommand.processRecord(SQLCommand.java:141)
           at oracle.odi.runtime.agent.execution.cmd.TextCommand.processRecord(TextCommand.java:1)
           at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:81)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2906)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2609)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:537)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:453)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1740)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:338)
           at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:214)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:272)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:263)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:822)
           at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:123)
           at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
           at java.lang.Thread.run(Thread.java:662)


      Seems to be an issue with the source DB however not getting any clue.

      Appreciate your attention on this.