ERROR: Missing or INVALID index (columns) ATTACHMENT_LATEST_VSN_IDX on table ATTACHMENT on Agile Product Lifecycle Management (PLM) System (Doc ID 3043292.1)

Last updated on FEBRUARY 27, 2025

Applies to:

Symptoms

Running agile9_check.sql, the following error is seen in the _agile9_check.log file:

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Your database schema version is 9.3.525.26.
It matches Agile Oracle schema version 9.3.525.26.
Make sure that there are no errors reported to ensure schema integrity.
Otherwise fix error(s) and rerun this check.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Exit if versions mismatch, otherwise press Enter to continue.

Validate schema objects against Agile Oracle schema version 9.3.525.26.

Validation is in process and errors will be reported if any.

ERROR: Missing or INVALID index (columns) ATTACHMENT_LATEST_VSN_IDX on table ATTACHMENT.
ERROR: Missing or INVALID index (columns) REC_BOM_VAL_IDX3 on table RECURSIVE_BOM_VALIDATION.
ERROR: Missing or INVALID index (columns) REC_BOM_VAL_IDX2 on table RECURSIVE_BOM_VALIDATION.
ERROR: Missing or INVALID index (columns) REC_BOM_VAL_IDX4 on table RECURSIVE_BOM_VALIDATION.
ERROR: Missing or INVALID index (columns) AGILE_FLEX_CLOB_HISTORY_IDX2 on table AGILE_FLEX_CLOB_HISTORY.
ERROR: Missing or INVALID index (columns) SIGNOFF_IDX8 on table SIGNOFF.
ERROR: Missing or INVALID index (columns) REC_BOM_VAL_IDX1 on table RECURSIVE_BOM_VALIDATION.
declare
*
ERROR at line 1:
ORA-20001: Please fix schema error(s) and run this check again.
ORA-06512: at line 6


Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.22.0.0.0

Cause

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