My Oracle Support Banner

ODI File Load Error "java.lang.NumberFormatException: For input string: '0x'" when Executing Mapping (Doc ID 2407295.1)

Last updated on MAY 01, 2023

Applies to:

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


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_TASK>" failed because child task "Load data-LKM SQL to Oracle-<TASK>" 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(
  at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(
  at oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(
  at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(
  at oracle.odi.runtime.agent.execution.SessionTask.processTask(
  at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(
Caused by: java.lang.NumberFormatException: For input string: "0x"
  at java.lang.NumberFormatException.forInputString(
  at java.lang.Integer.parseInt(
  at com.sunopsis.jdbc.driver.file.c.o.a(
  at com.sunopsis.jdbc.driver.file.a.b.a.b(
  at com.sunopsis.jdbc.driver.file.a.b.a.a(
  at com.sunopsis.jdbc.driver.file.z.a(
  at com.sunopsis.jdbc.driver.file.z.executeQuery(
  at oracle.odi.query.JDBCTemplate.executeQuery(


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


To view full details, 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 a vibrant support community of peers and Oracle experts.