Skip to main content

Background: Our users would like “Keyword Search's” enabled for Customers window, Quotes window, etc.…

Problem: Each Keyword Search must have enabled “Search Domain” which contains three jobs: Synchronized, Optimized, and Rebuilt. The last job, Rebuilt, is failing. The Error Text is below (I’ve removed the App User ID from Error Text, as seen in blue highlight):

ORA-29874: warning in the execution of ODCIINDEXALTER routine

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 2025

ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_INDEX_SYS", line 508

ORA-29960: line 1,

DRG-10595: ALTER INDEX CUSTOMER_TIX failed

DRG-50857: oracle error in drepopen

ORA-04063: package body "CTXSYS.DRVDML" has errors

ORA-06508: PL/SQL: could not find program unit being called: "CTXSYS.DRVDML"

ORA-06512: at line 1

ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_INDEX_SYS", line 497

ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_SYS", line 778

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_SQL", line 1721

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 2015

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 282

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 2025

ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_INDEX_SYS", line 508

ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_INDEX_SYS", line 497

ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_SYS", line 778

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_SQL", line 1721

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 2015

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 282

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 857

 

Request: Assuming my problem statement is correct, how do we correct this failing job?

Notes:

1.) There are other posts regarding Keyword Searches, such as, Search with Keywords does not work in Customer database - APP10 | IFS Community, however, my post is seeking why this job fails.

2.) Attached screen shot for Keyword Search, Search Domain, Rebuilt Job.

Hi Toni,

 

This is happening from the Oracle end and it has been investigated previously by Oracle support.

As a workaround, please execute the following two statements log in as SYS user; which would first grant UTL_HTTP package to CTXSYS & then compile the invalid DRVDML package.

In a multitenant (CDB) environment, connect as SYS to Container DB (not to PDB).

GRANT EXECUTE ON UTL_HTTP TO CTXSYS;

ALTER PACKAGE CTXSYS.DRVDML COMPILE BODY;

Once done, disable & enable the search domains again.

If you are in Windows platform , please run the below statements connecting to PBD as well (as SYSDBA)

GRANT EXECUTE ON UTL_HTTP TO CTXSYS;

 ALTER PACKAGE CTXSYS.DRVDML COMPILE BODY;

(Once done, disable & enable the search domains again.)

Reply


Terms & ConditionsCookie settings