My Oracle Support Banner

Agile9_check.sql Reports "ERROR: Missing or INVALID FTS CTX indexes" (Doc ID 2746213.1)

Last updated on JANUARY 22, 2021

Applies to:

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

Symptoms

On : 9.3.4.0 version, Database Install

During Agile Installation, following errors are reported by Agile9_check.sql

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Your database schema version is 9.3.xxx.
It matches Agile Oracle schema version 9.3.xxx.
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.xxx.

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

ERROR: Missing or INVALID FTS CTX indexes ABWF_PROCESS_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes ACTIVITY_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes AGILEUSER_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes AGILE_FLEX_CLOB_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes ATTACHMENT_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes CHANGE_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes CUSTOMER_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes DISCUSSION_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes FILES_CONTENT_IDX.
ERROR: Missing or INVALID FTS CTX indexes GROUP_HEADER_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes ITEM_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes LISTENTRY_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes MANUFACTURERS_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes MANU_PARTS_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes MDO_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes ORGANIZATION_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes OUTBOUND_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes PART_FAMILY_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes PDP_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes PRICE_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes PROJECT_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes PSR_CTX_IDX.
ERROR: Missing or INVALID FTS CTX indexes QCR_CTX_IDX.

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


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