"java.sql.SQLException: Numeric Overflow" error in ODI 12.1.3
(Doc ID 2574649.1)
Last updated on AUGUST 09, 2021
Applies to:
Oracle Data Integrator - Version 12.1.3.0.0 to 12.1.3.0.1 [Release 12c]Information in this document applies to any platform.
Symptoms
The following error occurs when attempting to run an Oracle Data Integrator (ODI ) 12.1.3 Mapping with a sequence very large - in the order of 2,300,000,000:
oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLException: Numeric Overflow
at oracle.odi.query.SequenceDwgBridgeImpl.getValue(SequenceDwgBridgeImpl.java:150)
at oracle.odi.query.SequenceDwgBridgeImpl.getCurrentValue(SequenceDwgBridgeImpl.java:129)
at oracle.odi.runtime.agent.execution.event.SequenceTracker$SequenceTrackerInitializer.handleBeginFirstStep(SequenceTracker.java:481)
at oracle.odi.runtime.agent.execution.event.AbstractExecutionEventTracker.onBeginFirstStep(AbstractExecutionEventTracker.java:57)
at oracle.odi.runtime.agent.execution.event.ExecutionEventDispatcher.handleBeginFirstStep(ExecutionEventDispatcher.java:264)
at oracle.odi.runtime.agent.execution.event.ExecutionEventDispatcher.onBeginFirstStep(ExecutionEventDispatcher.java:250)
at oracle.odi.runtime.agent.execution.event.ExecutionEventDispatcher.onBeginStep(ExecutionEventDispatcher.java:271)
at oracle.odi.runtime.agent.execution.SessionStep.execute(SessionStep.java:575)
at ...
Caused by: java.sql.SQLException: Numeric Overflow
at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4203)
at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:102)
at oracle.jdbc.driver.GeneratedStatement.getInt(GeneratedStatement.java:231)
at oracle.jdbc.driver.GeneratedScrollableResultSet.getInt(GeneratedScrollableResultSet.java:1429)
at oracle.odi.query.SequenceDwgBridgeImpl.getNativeSeqValue(SequenceDwgBridgeImpl.java:439)
at oracle.odi.query.SequenceDwgBridgeImpl.getValue(SequenceDwgBridgeImpl.java:145)
... 52 more
Changes
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |