Autoconfig is Failing With "DRG-10561: Index Jtf_amv_items_url_ctx Is Not Valid For Requested" Error (Doc ID 1334405.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle CRM Technical Foundation - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 04-Mar-2013***

Symptoms

When attempting to run autoconfig on the applications tier, jtfictx.sh causes the following error to occur.

Error

jtfictx.sh started at Wednesday, June 29, 2011 6:15:20 AM GMT

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jun 29 06:15:21 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
DECLARE
*
ERROR at line 1:
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-20000: Oracle Text error:
DRG-10561: index JTF_AMV_ITEMS_URL_CTX is not valid for requested operation
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 614
ORA-06512: at "SYS.DBMS_SQL", line 1053
ORA-06512: at line 96

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