Basic And Advanced Search Not Working After Upgrade : ORA-20000: Oracle Text Error DRG-10599 (Doc ID 2096669.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

After AUT upgrade, basic and advanced search is not working.


ERRORS:
ORA-20000: Oracle Text error:
DRG-10599: column is not indexed

 

Agile9_check.sql reports missing CTX indexes

SQL> @agile9_check.sql

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

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.

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms