My Oracle Support Banner

java.sql.SQLException: Numeric Overflow Is Generated In Application Server Log After Upgrading to 9.3.6.23, Running Averify 1.7.8.6 Reports Error: AGIL-00025157, AGIL-00025158, AGIL-00025159, AGIL-00025160, AGIL-00025161 (Doc ID 2994194.1)

Last updated on JANUARY 24, 2024

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

Below exception is generated in Agile Application Server log after upgrading to 9.3.6.23:
java.sql.SQLException: Numeric Overflow



The issue can be reproduced at will with the following steps:

  1. Restart Agile Application Server.
  2. Check Agile Application Server log. See Agile Application Server is started, but "java.sql.SQLException: Numeric Overflow" is generated repeatedly.
  3. Run Averify by executing averify.bat/averify.sh from %Averify_Home%\bin.
  4. Check oracle_averify_report.log generated under %Averify_Home%\logs. See the Averify sequence errors AGIL-00025157, AGIL-00025158, AGIL-00025159, AGIL-00025160, AGIL-00025161 reported.

Changes

Upgraded from 9.3.1.2 to 9.3.6.23, and ran GAP collector and ran below rebuild ID sqls to address Averify severe sequence errors (AGIL-00026000, AGIL-00026001, AGIL-00025151, AGIL-00025153):
rebuild-QueryIDs.sql
Rebuild-ChangeHistoryIDs.sql
Rebuild-ItemHistoryIDs.sql
 

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.