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

Last updated on JULY 19, 2016

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 problem happens such as Agile Application Server do not 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms