ORA-29874: Warning in the Execution of ODCIINDEXALTER Routine (Doc ID 847078.1)

Last updated on MARCH 28, 2016

Applies to:

Oracle Healthcare Transaction Base - Version: 5.3
This problem can occur on any platform.

Symptoms

When trying to load or import terminologies, the following error occured:

Error:
[35 sec.] Import failed
[35 sec.] java.sql.SQLException: ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-10595: ALTER INDEX HCT_ET_DESCRIPTIONS_I1 failed
DRG-11422: linguistic initialization failed
DRG-11446: supplied knowledge base file /opt/oracle/product/102/db/ctx/data/enlx/droldU.dat not installed

It looks for the file droldU.dat but the Oracle Text Supplied Knowlege base was installed:
oracle@tcn00qubc00365:~> ll /opt/oracle/product/102/db/ctx/data/enlx
total 49308
-rw-r--r-- 1 oracle oinstall 330062 Apr 13 1999 dren.ds
-rw-r--r-- 1 oracle oinstall 312942 Apr 13 1999 dren.is
-rw-r--r-- 1 oracle oinstall 3497330 Aug 29 1999 drofdUS.dat
-rw-r--r-- 1 oracle oinstall 2652662 Aug 29 1999 drofiUS.dat
-rw-r--r-- 1 oracle oinstall 37766593 Aug 29 1999 droldUS.dat
-rw-r--r-- 1 oracle oinstall 3263531 Aug 29 1999 droliUS.dat
-rw-r--r-- 1 oracle oinstall 2585766 Aug 29 1999 drolkUS.dat
-rw-r--r-- 1 oracle oinstall 12 Feb 29 2000 drolsUS.dat

The same error is encountered running Healthcare ETS Maintenance Program

Changes

Deploying E-Business Suite 11.5.10.2 and Healthcare Transaction Base 5.3 using Rapid Clone.

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