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

Last updated on APRIL 30, 2023

Applies to:

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

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

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