Severe Problem - Agile Object Sequence ID is Reaching Maximum When Running Averify (Doc ID 1606365.1)

Last updated on AUGUST 04, 2017

Applies to:

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

Symptoms

After running Averify, you see the following errors in the oracle_averify_report.log file:

AGIL-00025151 : E :   table has bad data (SEVERE PROBLEM - AGILE OBJECT SEQUENCE ID IS REACHING MAXIMUM. The Sequence Generator ID [QUERY_ID_SEQ] will be exhausted. The number of remaining IDs is about [xxxxxxxxxx]. Please review the Agile Administrator Guide Appendix ASAP to find out how to resolve the issue and avoid risk of system down time.)
AGIL-00025153 : E :   table has bad data (SEVERE PROBLEM - AGILE OBJECT SEQUENCE ID IS REACHING MAXIMUM. The Sequence Generator ID (AGILEBOJECTIDSEQUENCE) will be exhausted.  The number of remaining IDs is about xxxxxxxxxx. Please review the Agile Administrator Guide Appendix ASAP to find out how to resolve this issue and avoid risk of system down time.)

Note:  This is not a defect - these are new test cases that must be run on all Agile PLM systems.

Changes

These errors are the result of new test cases introduced in Averify version 1.7.5 and above to check for the possibility of running out of sequence numbers on prior versions of Agile PLM.  Versions 9.0 and above are affected by this change.

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