Mappings / Scenarios Upgraded From ODI 11g Fail With "ODI-1593 : bind parameters ... are not bound to any value" Error When Data Is Read From XML (Doc ID 2282016.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

Integration Interfaces / Scenarios that load data from XML do properly function in Oracle Data integrator (ODI) 11g.

Post upgrade to ODI 12c, these Mappings / Scenarios fail with ODI-1593 bind error messages, such as:

oracle.odi.runtime.agent.exception.ExecutionEngineException: ODI-1593: The following bind parameters (xxx) in the task command "insert into XXODI.C$_0xxx............) " are not bound to any value. All the bind parameters should be bound for the command to be successful.
  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:177)
  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
  at oracle.odi.runtime.agent.execution.Executor.performAction(Executor.java:449)
  at oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(Executor.java:334)
  at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:51)
  at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms