My Oracle Support Banner

Agile Throws java.sql.SQLException: Numeric Overflow Error (Doc ID 1923552.1)

Last updated on JANUARY 16, 2020

Applies to:

Oracle Agile PLM Framework - Version to [Release 9.3]
Information in this document applies to any platform.


Multiple problems happen such as Agile Application Server fails to start, unable to search object with below error in Agile Application Server log:


java.sql.SQLException: Numeric Overflow
    at oracle.jdbc.driver.DatabaseError.throwSqlException(
    at oracle.jdbc.driver.DatabaseError.throwSqlException(
    at oracle.jdbc.driver.DatabaseError.throwSqlException(
    at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(
    at oracle.jdbc.driver.NumberCommonAccessor.getInt(
    at oracle.jdbc.driver.OracleResultSetImpl.getInt(
    at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getInt(Unknown Source)
    at com.agile.pc.cmserver.util.OracleIDGenerator.getIDImpl(
    at com.agile.pc.cmserver.util.OracleIDGenerator.getNextIDImpl(
    at com.agile.util.dao.IDGenerator.getNextID(

Steps to Reproduce

The issue can be reproduced at will with the following steps:
1. Logon Web Client with any user
2. Do any type of Quick Search, error will occurs
Error: OracleIDGenerator getID for sequence 1 ; Message: Numeric Overflow Numeric Overflow


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

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