My Oracle Support Banner

AGIL-00015002 Still Appears After Running AGIL-00015002_f1.sql (Doc ID 2522997.1)

Last updated on JANUARY 14, 2022

Applies to:

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

Symptoms

Averify reported below error even after running AGIL-00015002_f1.sql

ERROR
AGIL-00015002 : E : ADMINMSATT : table has bad data at id = XXXX (EXCEPTION:NO_DATA_FOUND.Please check error AGIL-00025018 for dangling nodetable reference at parentid XXXX.)

FACTS
1. Generic fix script AGIL-00015002_f1.sql provided from support did not fix this issue.
2. Averify did not report AGIL-00025018 error

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

  1. Run Averify
  2. Check oracle_averify_report.log, and see below error reported:
    AGIL-00015002
  3. Log into sqlplus as agile database user, and run below generic fix script provided from support:
    AGIL-00015002_f1.sql
  4. Run Averify
  5. Check oracle_averify_report.log, and see below error is still reported:
    AGIL-00015002

Changes

 

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.