Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Himanshu RaiJan 5 2012 — edited Feb 16 2012

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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2012

Added on Jan 5 2012

#business-intelligence-applications, #data-integrator, #system-management-and-integration

4 comments

6,755 views