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 12.1.3.0.0 and laterInformation in this document applies to any platform.
Symptoms
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(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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |