After Upgrading to 9.3.6.26, Incorrect Error is Getting Generated When Running agile9_check.sql, Shows ERROR: Missing or INVALID index (columns) AGILE_FLEX_CLOB_HISTORY_IDX2 on table AGILE_FLEX_CLOB_HISTORY. (Doc ID 3007785.1)

Last updated on FEBRUARY 29, 2024

Applies to:

Goal

After upgrading to 9.3.6.26, incorrect error is getting generated when running agile9_check.sql.

SQL> @agile9_check.sql;

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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) AGILE_FLEX_CLOB_HISTORY_IDX2 on table AGILE_FLEX_CLOB_HISTORY.
declare
*
ERROR at line 1:
ORA-20001: Please fix schema error(s) and run this check again.
ORA-06512: at line 6

Solution

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