My Oracle Support Banner

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

Last updated on APRIL 28, 2021

Applies to:

Oracle Trading Community - Version 11.5.8 and later
Information in this document applies to any platform.

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

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
References

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