My Oracle Support Banner

"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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.