ODI-1228 On ODI Interface Execution With "java.sql.SQLException: Missing IN or OUT parameter"

Last updated on MARCH 27, 2018

Applies to:

Symptoms

Trying to execute an Oracle Data Integrator (ODI) interface which uses a bind variable fails with the following error stack:

ODI-1228: Task ******* (Integration) fails on the target ORACLE connection ********.
Caused By: java.sql.SQLException: Missing IN or OUT parameter at index:: 3
  at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1890)
  at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:12872)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.addBatch(OraclePreparedStatementWrapper.java:1517)
  at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(BatchSQLCommand.java:42)
  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:84)
  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)

You have already tried to follow <Document 1356466.1> - 'java.sql.SQLException: Missing IN or OUT parameter at index:: 1' Error With Procedures In ODI 11g but the same error persists.

Changes

Cause