My Oracle Support Banner

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

Last updated on APRIL 15, 2018

Applies to:

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

Symptoms

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

Error

java.sql.SQLException: Numeric Overflow
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
    at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:6797)
    at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:121)
    at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:482)
    at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getInt(Unknown Source)
    at com.agile.pc.cmserver.util.OracleIDGenerator.getIDImpl(OracleIDGenerator.java:75)
    at com.agile.pc.cmserver.util.OracleIDGenerator.getNextIDImpl(OracleIDGenerator.java:93)
    at com.agile.util.dao.IDGenerator.getNextID(IDGenerator.java:91)


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


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
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.