Agile9_check.sql Reports "ERROR: Missing or INVALID FTS CTX indexes"
(Doc ID 2746213.1)
Last updated on FEBRUARY 06, 2023
Applies to:
Oracle Agile PLM Framework - Version 9.3.4.0 and laterInformation 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 |