Averify 1.7.6 Output Reports AGIL-00025066 but Generic Fix AGIL-00025066_f1.sql Reports No Data Anomaly Found (Doc ID 2063677.1)

Last updated on JANUARY 24, 2016

Applies to:

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

Symptoms

When running Averify 1.7.6, oracle_averify_report.log shows AGIL-00025066 but after running generic fix script AGIL-00025066_f1.sql included in adt_averify.zip from <Note:1121926.1>, output log shows no data anormaly found.

Error

Example output of oracle_averify_report.log

AGIL-00025066 : C : ITEM_HISTORY table has bad data (Table ID:6000021 is greater than the Sequence ID -2096033640)

Example output of AGIL-00025066_f1.sql

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~                                                                                                                               ~                       Sequence value: -2096033520                                                                                                                                                                                                                 
~                   ITEM_HISTORY value: -2096033719                                                                                                                                                                                                                 
~                               Action: No data anomaly found.  Nothing to fix.                                                                                                                                                                                     
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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