ODI File Load Error "java.lang.NumberFormatException: For input string: '0x'" when Executing Mapping

(Doc ID 2407295.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

When executing an Oracle Data Integrator (ODI) 12c mapping using a remote agent that reads from a file using the ODI Java Database Connectivity (JDBC) File driver, the following error is returned on the Loading Data step:

ODI-1298: Serial task "SERIAL-EU-10_1_1_21_UNIT (20)" failed because child task "Load data-LKM SQL to Oracle- (50)" is in error.
Caused By: oracle.odi.runtime.agent.exception.ExecutionEngineException: java.lang.NumberFormatException: For input string: "0x"
  at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:117)
  at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:38)
  at oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(Executor.java:309)
  at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:51)
  at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:189)
  at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:111)
  ...
Caused by: java.lang.NumberFormatException: For input string: "0x"
  at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
  at java.lang.Integer.parseInt(Integer.java:492)
  at com.sunopsis.jdbc.driver.file.c.o.a(o.java)
  at com.sunopsis.jdbc.driver.file.a.b.a.b(a.java)
  at com.sunopsis.jdbc.driver.file.a.b.a.a(a.java)
  at com.sunopsis.jdbc.driver.file.bb.a(bb.java)
  at com.sunopsis.jdbc.driver.file.z.a(z.java)
  at com.sunopsis.jdbc.driver.file.z.executeQuery(z.java)
  at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:196)

Changes

The ODI environment may have been recently converted from 10g.

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