ARXCSTXT: Customer Text Data Creation And Indexing Invalid Index DRG-10561 DRG-12602 (Doc ID 359339.1)

Last updated on JUNE 01, 2023

Applies to:

Symptoms

The concurrent process ARXCSTXT module: Customer text data creation and indexing ends with the
following errors.

First attempt:
----
DRG-10561: index HZ_CUST_ACCT_SITES_ALL_T1 is not valid for requested operation
----
Second attempt:
----
DRG-12602: index owner does not have the access to user datastore procedure:
"CTXSYS"."HZ_CTX_CUSTOMER_TEXT"."HZ_SITE_PROC2"
----

These errors prevent the successful creation of indexes so that users can perform TEXT searches
for customers.

The log files show the errors

Error.doc
---
ARXCSTXT module: Customer text data creation and indexing
Current system time is 13-FEB-2006 08:09:46
...
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10561: index HZ_CUST_ACCT_SITES_ALL_T1 is not valid for requested operation


Error_1.doc
---
ARXCSTXT module: Customer text data creation and indexing
Current system time is 13-FEB-2006 10:22:01
...
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-12602: index owner does not have the access to user datastore procedure:
"CTXSYS"."HZ_CTX_CUSTOMER_TEXT"."HZ_SITE_PROC2"

Changes

Cause

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